June 2023 Citus Open Source Newsletter

Why are databases so hard to benchmark?

Marco digs into the GigaOM benchmark report (including Citus) and along the way explains why measuring database performance is so tough.

Read Marco’s post ⟶

Improved Citus metadata sync for Postgres in 11.3—a technical dive

Find out how our Citus database team improved metadata sync in Citus 11.3—useful if you have very large numbers of tables that have memory issues during metadata sync.

Read Aykut’s post ⟶

🎙️Path To Citus Con: Ep05 on Wed Jul 12

Listen to Grant Fritchey & Ryan Booz chatting live about their favorite ways to learn more about PostgreSQL. Hosts Claire & Pino are sure to chime in too.

Mark your calendar ⟶

🎙️Path To Citus Con: Ep04 - How I got started as a developer (& in Postgres)

Some fun stories are told in this episode about how Melanie, Thomas, Claire, & Pino got started as developers and with Postgres.

Listen to Path To Citus Con Ep04 ⟶

PGSQL Phriday #010: You’re invited to delve into the world of pgBadger

PGSQL Phriday is a monthly community blog event for the PostgreSQL community. The July edition focuses on pgBadger and is hosted by Alicja Kucharcyzck.

Read Alicja’s post for more info ⟶

June updates for Citus on Azure

Audit logging of database activities with the PostgreSQL Audit extension is now in preview—plus lots of other general availability announcements.

Read the docs ⟶

📹 Understanding & Managing Postgres Table Bloat

All about table bloat—why it occurs, how to mitigate it, and (best of all) how to avoid tripping over it in the first place.

Watch the Citus Con talk ⟶

📹 Postgres without SQL: Natural language queries using GPT-3 & Rust

Watch this engaging talk about Generative AI and a new Postgres extension which allows you to use the power of GPT-3 right from your database.

Watch Jelte’s Citus Con talk ⟶

📹 Multi-tenant Saas apps made simple on Citus on Azure

This talk covers building multi-tenant apps with Postgres & Citus—plus a dive into various tradeoffs of different sharding models.

Watch Adam & Alicja’s Citus Con talk ⟶

📹 PostgreSQL performance tips you have never seen before

A lot can be done to speed up your SQL queries in Postgres. You’ll find lots of new trickery and tips in this talk from a seasoned PG consultant.

Watch this Citus Con talk ⟶

ICYMI: 11.3 is the newest Citus open source release

Citus 11.3 has lots of new features for multi-tenant SaaS workloads. Watch the recording of the 11.3 release party livestream for demos, or read the release notes for all the details.

Read Marco’s 11.3 blog post ⟶