May 2022 Citus Open Source Newsletter

Speeding up sort in PostgreSQL 15

David’s blog post dives deep into the 4 improvements to sort performance in PostgreSQL 15, with charts to compare PG 14 vs. PG 15 query speeds.

Read David’s post ⟶

Moving Postgres data 26X faster with ADF

Learn how the latest improvements to Azure Data Factory can help you move data into and out of Postgres on Azure faster than ever, using parallel read and COPY commands.

Read Ozan’s post ⟶

Subscribe to Citus Con news

Sign up to get email updates when the next Citus Con: An Event for Postgres is announced, when the CFP opens/closes, when the scheduled is posted, and other important news about the event.

Subscribe for notifications ⟶

IO in Postgres: Past, Present, & Future

In his talk at CMUDB, Andres digs deep into why hardware trends are triggering PostgreSQL to change course and modernize the IO stack to use asynchronous/direct IO. Slides for reference.

Watch Andres’s talk ⟶

How to choose the right shard key

In this Citus Con talk, Sai explains how to choose an optimal shard key (aka distribution column) for Citus—which is oh so useful since the shard key determines how efficiently Citus executes Postgres queries.

Watch Sai’s talk ⟶

Build scalable apps with Citus on Azure

This new series of articles covers how to build scalable relational apps with Citus on Azure. Start with Basic Tier (aka single-node Citus)—later, add more nodes, rebalance, and scale out seamlessly.

Read the docs ⟶

Optimizing autovacuum

Super-useful Citus Con talk on how autovacuum works, and what you can do to fix it if/when it’s not working as expected. Samay shares his learnings from improving production databases for 50+ Postgres customers.

Watch Samay’s talk from Citus Con ⟶

Bruce Momjian’s great talk at Citus Con

In this video Bruce uses the explain command to show how the optimizer interprets queries and determines optimal execution.

Watch Bruce’s talk ⟶

Data import techniques for Citus

Colton covers how to load data into Citus, when to use \COPY versus single-row inserts, and microbatching \COPY operations in his talk at Citus Con. Index juggling anyone?

Watch Colton’s customer talk ⟶

Customer talk on Postgres, PostGIS, & Citus

Learn how Guy Carpenter, a Marsh McLellan company, uses spatial indexing with PostGIS and sharding with Citus to serve their huge geospatial application—without negatively impacting performance.

Watch the customer talk ⟶

Lesser known features of PostgreSQL

In his Citus Con talk, Haki presents a few lesser known, but useful features. E.g., do you know how you can get the number of inserted and update rows in an upsert?

Watch Haki’s talk ⟶

ICYMI: Coming soon in Citus 11.0

If you want to know more about what’s coming next for Citus, check out the video of Marco’s Citus Con talk about Citus 11. Or, read his post on test driving Citus 11.0 beta.

Watch Marco’s talk ⟶