Update in October 2022: Citus has a new home on Azure! The Citus database is now available as a managed service in the cloud as Azure Cosmos DB for PostgreSQL. Azure documentation links have been updated throughout the post, to point to the new Azure docs.
I recently gave a talk about the Citus extension to Postgres at the Warsaw PostgreSQL Users Group. Unfortunately, I did not get to go in person to beautiful Warsaw, but it was still a nice way to interact with the global Postgres community and talk about what Citus is, how it works, and what it can do for you.
If you are already familiar with Postgres then this talk should be a good introduction to all the powerful capabilities that Citus gives you. The tl;dr is this: Citus is an open source extension to Postgres that transforms Postgres into a distributed database. Citus uses sharding and replication to distribute your data and your Postgres queries across a distributed database cluster.
Every so often, I try to rethink how I talk about Citus as Postgres and the needs of applications evolve. One thing we have not done very much is talk directly about the performance improvements in Citus. Sometimes it’s actually slower, but at scale can be a lot faster. Therefore, I introduced every Citus feature with some benchmarks that show the performance compared to a (large) Postgres server.
The talk is also worth watching for the demo (the demo starts at 46:52) where I compare the performance of Hyperscale (Citus) on Azure Database for PostgreSQL against a single Postgres server. For the demo, I use GitHub archive data in an analytics use case, and the demo shows >250x speedups for analytical queries with Citus!
Click here to watch the video of my talk at Warsaw PostgreSQL Users Group, on Citus: PostgreSQL at any Scale. The demo starts at 46:52, but the introductory discussion should be useful, too.
Props to the organizers of the Warsaw PostgreSQL Users Group—especially Alicja Kucharczyk—for the time they spend organizing Postgres talks for their community. And for inviting me to give a talk to their Postgres users group. I really appreciated all the good questions, too.
Here are a few of the getting-started next steps I usually recommend to developers:
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.