cockroachdb / cockroachdb/cockroach
Support for dimension tables
Open
C-enhancement
T-sql-foundations
- Dominant language
- Go
- Stars
- 32.5k
- Forks
- 4.1k
- PR merge metrics
- PR metrics pending
Description
We should consider providing CREATE TABLE and ALTER TABLE syntax to configure small lookup tables (aka dimension tables) so that they have a replica on every node in a single region cluster. These would be tables that are small enough to exist in a single range, are infrequently written to, but read with high frequency. Placing a replica on each node provides the ability for each node to quickly use or join the table locally vs having to perform a remote read on the table.
This is similar to GLOBAL tables we support for MR clusters but applied to non multi-region clusters.
Jira issue: CRDB-36419
Epic CRDB-10667
Contributor guide
Assessment
This issue has not been assessed yet.