Engineering at Scale
Sharding vs partitioning: how databases split data
Partition inside one server before you shard across many: Postgres declarative partitioning by date, shard keys for multi-institute platforms, the costs of sharding and when it pays.