cockroachdb / cockroachdb/cockroach

table locality that places a replica on all nodes

Open
#114,780 7 comments 0 reactions 0 assignees View on GitHub
A-multiregion C-wishlist T-sql-foundations
Dominant language
Go
Stars
32.5k
Forks
4.1k
PR merge metrics
PR metrics pending

Description

In multi-region clusters, [global](https://www.cockroachlabs.com/docs/v23.1/table-localities#global-tables) tables place a replica in every region, but not necessarily on every node. Reads from such a table avoid inter-region round trips, but still might incur intra-region round trips.

To avoid _any_ round trips at all, we would need a locality that places a replica on _every_ node. A table with such a guarantee might allow some interesting optimizations in the physical planner or distsender, like always planning local execution or calling directly into kvserver.

Jira issue: CRDB-33678

Epic CRDB-10667

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.