Decision#d1
Catalogue / notion-2023-postgres-reshard
Notion triples its Postgres space shards from 32 to 96 and shards PgBouncer with zero downtime
Notion, 2023. Postgres space shards and PgBouncer layer.
Records
Decision#d2
Replicate logical schemas to new shards with Postgres logical replication and deferred index builds
Decision#d3
Shard the PgBouncer cluster into four groups of 24 space shards before database cutover
Decision#d4
Verify with sampled bounded dark reads and cut over per shard via PgBouncer pause and reverse replication
Sign in to read what was chosen, what was rejected and what it cost, each with its place in the source. An account is free.