Even without a partition, consistency costs latency.
PACELC and Latency Tradeoffs: even without a partition, consistency costs latency
choose the failure mode you can explain
Async favors latency; sync favors consistency and durability.
PACELC extends CAP with the everyday case: outside of partitions, do you favor low Latency (async replication, possible staleness) or strong Consistency (synchronous replication, slower writes)?
Async replication: writes ack on leader; replicas catch up later. Low latency, possible staleness.
Sync replication: writes ack only after replicas confirm. Strong consistency, higher latency, lower availability if a replica is slow.
Real systems often pick per-table, per-region, per-operation — not globally.
Postgres primary + 2 read replicas, choosing replication mode.