August 2024 Citus Open Source Newsletter

📣 See you at PGConf NYC 2024!

Rumor has it that PGConf NYC will sell out soon. Microsoft will be there with bells on. Come find us.

📹 State of the Postgres Extension Ecosystem

This talk from POSETTE 2024 gives a brief history of Postgres extension distribution, the current state, and then outlines the projects to build the future extension ecosystem.

Watch David’s talk ⟶

🎙️ How David Rowley got started as a developer (& in Postgres)

Ever wonder how driving a forklift at a cheese factory could lead to a career in databases? David & Claire chat about how that really happened.

Listen In ⟶

📹 Open Source Contributions to Postgres: The Basics

New to Postgres? Want to understand how to contribute to the project? If so, this talk is for you. Or, you can review the slides.

Watch Elizabeth’s talk ⟶

📹 Scaling PostgreSQL with Citus: Building High-Performance Distributed Database Clusters

This webinar from Percona covers distributed scaling with Citus plus deployment tips and how Percona adds on-premises sharding.

Watch the webinar ⟶

🎙️ Talking Postgres EP19 – Wed Sep 18

Melanie Plageman joins Claire to talk about becoming a Postgres committer.

Mark your calendar ⟶

📹 Using Azure Query Store to Understand PostgreSQL Performance

Capturing query metrics in Postgres can be a challenge. In his POSETTE 2024 talk Grant shares how Query Store gives you tools to help with tuning PostgreSQL queries on Azure.

Watch Grant’s talk ⟶

📣 Patroni 4.0 is out!

Patroni 4.0 introduces quorum-based failover, the ability to register Citus secondaries, configurable retention of members’ replication slots, and a whole lot more.

Read the release notes ⟶

📹 Vector data in Postgres - how's it different from "normal" data?

AI works with vectors. But what is a vector? Heikki explains vectors and how they are different from other types of data in his POSETTE 2024 talk. (Slides)

Watch Heikki’s talk ⟶

✍ Optimizing Query Performance with Work_Mem

Query Store is an invaluable tool for analyzing and optimizing query performance in PostgreSQL. This post shares tips & tricks for both vanilla Postgres and on Azure.

Read Mahendraprasad’s post ⟶

📹 ICYMI: A Walking Tour of PostgreSQL

Find out all about the origin of Postgres, its history, and the current structure of the project. It’s fascinating.

Watch Thomas’s talk ⟶