-
Notifications
You must be signed in to change notification settings - Fork 4.1k
sql: columnar direct scan results in 10x more messages #99838
Copy link
Copy link
Open
Labels
C-bugCode not up to spec/doc, specs & docs deemed correct. Solution expected to change code/behavior.Code not up to spec/doc, specs & docs deemed correct. Solution expected to change code/behavior.O-qaT-sql-queriesSQL Queries TeamSQL Queries Team
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
Reactions are currently unavailable
Metadata
Metadata
Assignees
Labels
C-bugCode not up to spec/doc, specs & docs deemed correct. Solution expected to change code/behavior.Code not up to spec/doc, specs & docs deemed correct. Solution expected to change code/behavior.O-qaT-sql-queriesSQL Queries TeamSQL Queries Team
Type
Projects
Status
Backlog