cockroachdb / cockroachdb/cockroach

sql,kv,storage: avoid unnecessary value retrievals

Open
#146,575 1 comment 0 reactions 0 assignees View on GitHub
A-kv A-sql-executor A-storage C-enhancement T-storage
Dominant language
Go
Stars
32.5k
Forks
4.1k
PR merge metrics
PR metrics pending

Description

With value separation (cockroachdb/pebble#112), values will commonly be stored externally to sstables. Retrieving a value will commonly require 1 or 2 additional block reads. Current KV API interfaces do not support retrieving just a key, even if query execution only requires a key. Similarly uniqueness checks that find a key will retrieve its values unnecessarily.

Avoiding value retrievals is the simplest form of end-to-end projection push down, and it doesn't suffer from the API complexity that more general forms of projection push down do.

Jira issue: CRDB-50603

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.