Citus & Patroni: The Key to Scalable and Fault-Tolerant PostgreSQL
summary
Shows a concrete integration: Patroni+ETCD+HAProxy coordinates a Citus coordinator and multiple worker Postgres clusters, with Citus 11.2 rebalance UDFs used to move shards live. Demo uses Docker Compose (2 coordinators, 2 workers, add a 3rd), runs continuous inserts, calls citus_rebalance_start() and citus_rebalance_status, moves shards with logical replication, and client insert latency briefly spikes to ≈3s — rebalance completes without breaking connections.
AI-written summary · about
chapters (10)
- 0:00Introducing Alexander
- 0:47Talk begins: using Patroni & Citus together
- 2:13As an application developer, I want
- 4:44High Availability with Patroni
- 7:23Horizontal scalability
- 11:12Sharding with Citus
- 14:26Citus HA with Patroni 3.0
- 17:24Adding new workers to the Citus cluster
- 18:41Demo of Patroni 3.0 with Citus
- 28:37Q&A
related talks
44mDistributed Postgres with Citus
31mSharding Without the Complexity
08mFoundations of Distributed PostgreSQL with Citus
54mContainerized Clustered PostgreSQL
34mElephants on Automatic: HA Clustered PostgreSQL with Helm [I]
38mPostgreSQL as a distributed computing platform
50mPatroni Deployment Patterns
23mFollowing Select Statements Through Citus Internals