cockroachdb / cockroachdb/cockroach
table locality that places a replica on all nodes
Open
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
Assessment
This issue has not been assessed yet.