#Partitioning
2 notas · última:
How to design a system for scale
The newsletter outlines three ways to scale systems: add server clones, partition by function, or partition data. It compares their advantages and limits, especially around state, coordination, and complexity.
Solving Bottlenecks With SQL Indexes and Partitions
Explains when SQL indexes help range queries, when wildcards defeat them, how B-tree depth and fragmentation affect reads, and how partitioning changes maintenance and query plans.