Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

sql: columnar direct scan results in 10x more messages #99838

Open
Tracked by #82323
cucaroach opened this issue Mar 28, 2023 · 2 comments
Open
Tracked by #82323

sql: columnar direct scan results in 10x more messages #99838

cucaroach opened this issue Mar 28, 2023 · 2 comments
Labels
C-bug Code not up to spec/doc, specs & docs deemed correct. Solution expected to change code/behavior. O-qa T-sql-queries SQL Queries Team

Comments

@cucaroach
Copy link
Contributor

cucaroach commented Mar 28, 2023

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

@cucaroach cucaroach added the C-bug Code not up to spec/doc, specs & docs deemed correct. Solution expected to change code/behavior. label Mar 28, 2023
@blathers-crl blathers-crl bot added the T-sql-queries SQL Queries Team label Mar 28, 2023
@cucaroach cucaroach added O-qa T-sql-queries SQL Queries Team and removed T-sql-queries SQL Queries Team labels Mar 28, 2023
@mgartner mgartner moved this to 23.2 Release in SQL Queries Jul 24, 2023
@mgartner
Copy link
Collaborator

mgartner commented Aug 3, 2023

@yuzefovich are you planning on working on this for v23.2?

@yuzefovich
Copy link
Member

No, I don't think so.

@yuzefovich yuzefovich moved this from 23.2 Release to 24.1 Release in SQL Queries Aug 3, 2023
@mgartner mgartner moved this from 24.1 Release to New Backlog in SQL Queries Nov 22, 2023
@yuzefovich yuzefovich removed their assignment Feb 10, 2024
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
C-bug Code not up to spec/doc, specs & docs deemed correct. Solution expected to change code/behavior. O-qa T-sql-queries SQL Queries Team
Projects
Status: Backlog
Development

No branches or pull requests

3 participants