June 2024 Citus Open Source Newsletter

📣 POSETTE 2024: It’s a wrap!

If you missed POSETTE: An Event for Postgres not to worry. You can watch all 4 livestreams or pick and choose your favorites.

Explore all 42 talks ⟶

🎙️ The Making of POSETTE with Aaron Wislang & Teresa Giacomini

Get a backstage pass to POSETTE (formerly Citus Con) when Aaron & Teresa join Claire to chat about all the nitty gritty details of creating a virtual conference.

Listen in ⟶

📹 Analyzing cacheline contention using perf c2c

At the first PGConf.dev Andres Freund provided a brief introduction into cache coherency, how to find contended cachelines using perf c2c, and how to address some identified problems.

Watch Andres’s talk ⟶

📹 Still deciding which POSETTE talks to watch?

These short snippets from each of the speakers let you know what each talk is about and who should watch it. These and the Ultimate Guide are your friends when choosing POSETTE talks.

Watch the trailers ⟶

📹 The PostgreSQL Protocol: The Good, The Bad, & the Future

In his talk from PGConf.dev in May, Jelte Fennema-Nio takes a deep-dive into the PostgreSQL protocol—plus upcoming changes.

Watch Jelte’s talk ⟶

🎙️ Path To Citus Con EP17 – Wed Jul 10

Pino de Candia, former co-host of Path to Citus Con, joins Claire to talk about podcasting about Postgres.

Mark your calendar ⟶

📹 Data-intensive Postgres: 3 ways to scale

In this talk from POSETTE, Marco Slot explores 3 data-intensive workload patterns, and potential solutions for each type.

Watch Marco’s talk ⟶

📣 Platinum sponsor of PGConf EU 2024

PGConf EU lands in Athens, Greece in October and Microsoft is a Platinum sponsor again this year. Hope to see you there!

Registration opens soon ⟶

📹 Curious about how to benchmark distributed Postgres?

This POSETTE talk covers different distributed architectures, why quantifying performance for distributed systems is tough, and how to identify bottlenecks.

Watch Lotte’s talk ⟶

📹 SaaS on Rails on Postgres

In this POSETTE talk you’ll learn how Ruby on Rails and Postgres can be used to create scalable SaaS applications.

Watch Andrew’s talk ⟶

✍ ICYMI: More Session Variables for PgBouncer Connection Pooler for Postgres

The new track_extra_parameters configuration option in PgBouncer allows clients to change a list of Postgres parameters—even in transaction pooling mode.

Read Emel’s post ⟶