cockroachdb / cockroachdb/cockroach
sql,kv,storage: avoid unnecessary value retrievals
Open
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
Assessment
This issue has not been assessed yet.