Skip to content

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

@cucaroach

Description

@cucaroach

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

Metadata

Metadata

Assignees

No one assigned

    Labels

    C-bugCode not up to spec/doc, specs & docs deemed correct. Solution expected to change code/behavior.O-qaT-sql-queriesSQL Queries Team

    Type

    No type

    Projects

    Status

    Backlog

    Milestone

    No milestone

    Relationships

    None yet

    Development

    No branches or pull requests

    Issue actions