• Aayush Shah's avatar
    sql: native support for creating hash sharded indexes · 6a3d3818
    Aayush Shah authored
    This PR accompanies the hash sharded indexes RFC (#42924).
    
    Currently, in CockroachDB, write workloads that are sequential on a
    particular key will cause a hotspot on a single range if there's any
    sort of index with the said key as a prefix.
    
    This PR alleviates this problem by allowing users to _shard_ their
    indexes into a specific number of buckets by creating a computed shard
    column under the hood and prefixing the index with this shard column in
    order to distribute sequential traffic uniformly over the index's ranges.
    
    Fixes #39340
    
    Release note (sql change): Improve user experience for creating hash
                               sharded indexes.
    6a3d3818
Name
Last commit
Last update
.github Loading commit data...
build Loading commit data...
c-deps Loading commit data...
cloud Loading commit data...
docs Loading commit data...
githooks Loading commit data...
licenses Loading commit data...
monitoring Loading commit data...
pkg Loading commit data...
scripts Loading commit data...
vendor @ ea15e182 Loading commit data...
.editorconfig Loading commit data...
.gitattributes Loading commit data...
.gitignore Loading commit data...
.gitmodules Loading commit data...
AUTHORS Loading commit data...
CONTRIBUTING.md Loading commit data...
Gopkg.lock Loading commit data...
Gopkg.toml Loading commit data...
LICENSE Loading commit data...
Makefile Loading commit data...
README.md Loading commit data...