Foundations of Distributed PostgreSQL with Citus
summary
Citus is a PostgreSQL extension that turns Postgres into a multi-node distributed database and is what powers Azure Cosmos DB for Postgres. Queries are split by shard and executed as ordinary Postgres queries on worker nodes; shards are regular Postgres tables and metadata/schema live on a coordinator. Distributed transactions use PostgreSQL’s hooks and two-phase commit. Since Citus 11 the cluster supports query from any node for reads and writes while DDL still routes through the coordinator, enabling very high writes/sec.
AI-written summary · about
chapters (9)
- 0:00Introduction
- 0:23What is Citus
- 1:23What is Extension
- 2:21Extensions in PostgreSQL
- 3:22Queries
- 4:05Distributed Transactions
- 4:49Two Phase Commit
- 5:55Citus Coordinator
- 7:16Conclusion
related talks
31mKEYNOTE: The Distributed PostgreSQL Problem & How Citus Solves it
32m8 keys to the growth of Citus & Distributed PostgreSQL
44mDistributed Postgres with Citus
24mCitus from the Customer eyes
31mSharding Without the Complexity
38mPostgreSQL as a distributed computing platform
52mBuilding Distributed OLTP with Azure Cosmos DB for PostgreSQL
16mKeynote – Umur Cubukcu