Citus Newsletter

Wishing y’all a wonderful 2023. May it be chock full of all things Postgres. Here’s the year-end wrap up of our most popular Citus & Postgres posts & videos of 2022. Happy New Year!

Citus 11 for Postgres goes fully open source

Plus, if your app needs high query throughput, Citus 11 includes automatic schema & metadata syncing across nodes.

Read Marco’s post ⟶

Citus has a new home on Azure

Powered by open source Citus and PostgreSQL, the managed Citus database service has a new home as Azure Cosmos DB for PostgreSQL, formerly Hyperscale (Citus). And this video shows you how it all works.

Read all about it ⟶

Speeding up sort performance in Postgres 15

With charts that compare PG14 vs. PG 15 query speeds, David dives deep into the 4 improvements to sort performance in PostgreSQL 15.

Read David’s post ⟶

Submit a talk to Citus Con by Feb 5, 2023

The 2022 edition of Citus Con: An Event for Postgres was such a success, we’re doing it again. We can’t wait to see your talk proposals for the 2023 event.

Submit a talk ⟶

Why, what & how the Citus database was open sourced

A developer’s take on why, what, and how the remaining Citus enterprise features were open sourced in the Citus 11 release.

Read Jelte’s post ⟶

Debugging Postgres autovacuum problems: 13 tips

With a cheat sheet of 13 useful tips, this post helps you solve many autovacuum problems (not triggering enough? too slow? not cleaning up dead rows?). Or, watch the video.

Read Samay’s post ⟶

Reducing replication lag with IO concurrency in Postgres 15

All about the crash recovery & physical replication performance improvements made in PG 15 in this deep-dive post by a PostgreSQL committer—and the future work needed too.

Read Thomas’s post ⟶

Citus 11.1 blog post

With 11.1, not only do you get shard rebalancing in the background and PG15, but you can also distribute Postgres tables, isolate tenants, & split shards—without interruption.

Read Marco’s post ⟶

Azure Cosmos DB for PostgreSQL with PG 15 support in just 1 week

Within just 1 week of the PG 15 release, our team added PostgreSQL 15 into Azure Cosmos DB for PostgreSQL. You can also read the engineering deep dive into how we did it.

Read Nik’s post ⟶

Benchmark performance of Citus and Postgres on Azure

Deep dive into database performance benchmarks, starting from the different types of benchmarks for OLTP, OLAP, and HTAP workloads.

Read Jelte’s post ⟶

New in 2022: Citus release parties

With demos & Q&A, Citus release party livestreams are an interactive way to learn what’s new in each release. Another livestream coming soon. Watch for it!

Watch 11.1 party ⟶

New in 2022: release notes for Citus open source

Want to know all the details about a Citus release? The Updates page has them all—from Citus 11.1 all the way back to Citus v9.2.

Read the release notes ⟶

8 keys to the growth of Citus & Distributed PostgreSQL

Umur Cubukcu’s Keynote @ Citus Con 2022

The Building Blocks for Self-Driving PostgreSQL

Andy Pavlo’s Keynote @ Citus Con 2022

PostgreSQL—more relevant than ever

Magnus Hagander’s Keynote @ Citus Con 2022

Queues in PostgreSQL

from Thomas Munro @ Citus Con

IO in Postgres: Past, Present, & Future

from Andres Freund’s talk at Carnegie Mellon

Top 10 reasons to choose Flexible Server for Azure Database for PostgreSQL

from Sunil Agarwal @ Citus Con 2022

Analyzing Postgres performance problems using perf and eBPF

from Andres Freund @ Citus Con 2022

Following Select Statements Through Citus Internals

from Onder Kalaci @ Citus Con 2022

Django with PostgreSQL superpowers

from Paolo Melchiorre @ Citus Con 2022

CFP open for Citus Con: An Event for PostgreSQL 2023 – til Feb 5, 2023

Online | Apr 18-19, 2023| CFP

Nordic PGDay 2023 – CFP closes today, Dec 31, 2022

Stockholm, Sweden | Mar 21, 2023 | CFP

PGDay Chicago 2023 – CFP open til Jan 2, 2023

Chicago, IL | Apr 20, 2023 | CFP

pgDay Paris 2023 – CFP open til Jan 6, 2023

Paris, France | Mar 22-23, 2023 | CFP

PGCon 2023 – CFP open til Jan 19, 2023

Ottawa, Canada | May 31-Jun 1, 2023 | CFP