Range partitioning.
also: range-based partitioning · range sharding · range-based shardingGiving each partition a contiguous key range (A-F, G-L…): range queries stay on one partition, but hot ranges overload one.
the two-minute refresher
- Range queries hit a single partition, and related keys sit together.
- Boundaries can be split or merged without reshuffling everything.
- Danger: auto-increment IDs or timestamps send every new write to the last partition.
- Works when access is spread across the range, fails when it piles up at one end.