cockroachdb / cockroachdb/cockroach

sql: columnar direct scan results in 10x more messages

Open
#99,838 2 comments 0 reactions 0 assignees View on GitHub
C-bug O-qa T-sql-queries
Dominant language
Go
Stars
32.5k
Forks
4.1k
PR merge metrics
PR metrics pending

Description

Setup:
```
create table t(i int, s string);
insert into t select generate_series(1,100000), repeat("asdfasdf", 1024);
```
with columnar direct scan:

```
maximum memory usage: 144 KiB
network usage: 7.2 MiB (7,261 messages)
sql cpu time: 4ms
```
w/o
```
maximum memory usage: 10 MiB
network usage: 6.4 MiB (805 messages)
sql cpu time: 95ms
```

Jira issue: CRDB-26103

Contributor guide

Open the contributing guide

Assessment

This issue has not been assessed yet.

Get new issues in your inbox

A short digest of beginner-friendly GitHub issues.