Sharding vs replication vs partitioning: choosing a Postgres scaling path by bottleneck
Replication, partitioning and sharding solve different problems, and picking the wrong one buys complexity without relief. This guide starts from the bottleneck you can measure and walks to the option that fixes it, including when Citus is worth it.