January 2024 Citus Open Source Newsletter

📣 CFP for POSETTE is open until Apr 7, 2024

The Call for Proposals / Speakers is open for POSETTE: An Event for Postgres (formerly Citus Con)! We can’t wait to see your talk proposals about what you do with Postgres.

Submit a talk ⟶

📣 Citus Con has a new name!

Our 3rd annual virtual event no longer has the Citus Con nickname. Find out what POSETTE stands for and why the name was changed.

Get the details ⟶

🎙️ Path To Citus Con Ep12 – Wed Feb 7

Derk van Veen will join Pino and Claire on Wed Feb 7 to share his journey from developer to Postgres specialist.

Mark your calendar ⟶

📹 PostgreSQL Distributed: Architectures and best practices

In this talk at PGConf EU, Marco discusses the properties and trade-offs of different distributed PostgreSQL architectures. Follow along with the slides.

Watch Marco's talk ⟶

📣 Nordic PGDay Schedule announced!

The schedule for Nordic PGDay is out. Claire Giordano will reprise her PGConf EU talk on Partitioning & Sharding, and Alexander Kukushkin will give a step-by-step Patroni cooking guide.

Check out the schedule ⟶

📹 Leveraging pgBadger for Effective PostgreSQL Troubleshooting

Alicja shows you how to harness pgBadger’s potential & turn diagnostic data into actionable strategies to enhance the Postgres performance and stability in her PGConf EU talk. Slides too.

Watch Alicja’s video ⟶

🎙️ Podcast highlights on benchmarking Postgres performance, from Path To Citus Con Episode 11

Co-producer for the Path To Citus Con podcast Aaron Wislang shares highlights from the most recent episode on benchmarking with Jelte Fennema-Nio & Marco Slot.

Read Aaron’s post ⟶

📹 The path to using AIO in postgres @ PGConf EU

In this talk Andres describes what using AIO in Postgres looks like, what is already in Postgres (e.g. speeding up concurrent COPY by 3x in 16), plans for PG17, & what the longer term may bring. + Slides.

Watch Andres’s talk ⟶

📹 Tame the growth of your database

In his talk at PGConf EU, Adam shows you how to tame the growth of your database by understanding copy-on-write and HOT updates—with examples and slides.

Watch Adam’s talk ⟶

📹 Beginner's Guide to Partitioning vs. Sharding in Postgres

What’s the difference between sharding and partitioning in Postgres? What are the pros & cons of each? Watch Claire’s PGConf EU talk or if you prefer, peruse her slides.

Watch Claire’s talk ⟶

📹 Making your patch more committable

Postgres contributor Melanie Plageman shares her tips for increasing the committability of your patch in her talk at PGConf EU. Slides are available too.

Watch Melanie’s talk ⟶