KEYNOTE: The Distributed PostgreSQL Problem & How Citus Solves it

on YouTube ↗31m

" summary

Citus is a Postgres extension that shards and replicates tables across PostgreSQL servers to get “Postgres performance at any scale,” with a decade of engineering and open source code on GitHub and a managed option via Azure Cosmos DB for PostgreSQL. It enforces co-location by shard key and replicated reference tables to keep joins local, shows GigaOM/HammerDB distributed SQL benchmark wins when modeled for locality, and admits gaps (schema-level sharding, snapshot isolation) under active development.

AI-written summary · about

" chapters (11)

1. 0:00Introducing Marco
2. 2:01Marco’s talk begins: what is Citus?
3. 2:56Why we need distributed PostgreSQL
4. 7:44Data locality problem
5. 12:54How Citus addresses data locality
6. 15:12Distributed SQL benchmark results
7. 15:57Distributed data modeling problem
8. 18:53Versatility problem
9. 19:12Citus features & gaps
10. 20:09Engineering culture problem
11. 22:57Q&A

" related talks

• 08mFoundations of Distributed PostgreSQL with CitusOnder Kalaci · Azure Cosmos DB: Liftoff 2022
• 32m8 keys to the growth of Citus & Distributed PostgreSQLUmur Cubukcu · Citus Con: An Event for Postgres 2022
• 44mDistributed Postgres with CitusWill Leinweber · HighLoad++ 2017
• 16mKeynote – Umur CubukcuUmur Cubukcu · PGConf Silicon Valley 2015
• 31mSharding Without the ComplexityCédric Villemain · PG Day France 2024
• 28mEfficiently distributing Postgres with Citus – How to choose the right shard key?Sai Krishna Srirampur · Citus Con: An Event for Postgres 2022
• 38mPostgreSQL as a distributed computing platformMarco Slot · PostgresOpen Silicon Valley 2017
• 52mBuilding Distributed OLTP with Azure Cosmos DB for PostgreSQLCharles Feddersen · SQLBits 2023