Fraught Feedback: Trying and Failing to Implement Adaptive Behavior in Postgres

Presenters Melanie Plageman Source PGConf.dev 2025 🐌 The Quest for Smarter Vacuuming in PostgreSQL: A Journey of Discovery (and a Few Setbacks) 🐌 Hey everyone! Ever wondered what happens behind the scenes in your PostgreSQL database? It’s not all just queries and results. There’s a vital, often unseen process keeping things running smoothly: vacuuming. And as PostgreSQL evolves, so too must our approach to this critical operation. Recently, I attended a fascinating presentation diving deep into the complexities of PostgreSQL vacuuming and transaction ID (XID) management. It wasn’t a straightforward success story – it was a journey of exploration, experimentation, and ultimately, a humbling realization about the challenges of adaptive algorithms. Let’s break down what we learned! ...

June 9, 2025 · 4 min

Reproducible Postgres

Presenters Javier Maestro Alvaro Hernandez Source PGConf.dev 2025 🚀 Building Trust: How Bazel & Monobot are Revolutionizing PostgreSQL Builds 💾 The world of open-source software is built on trust. We rely on the integrity of the code we use, and ensuring that code is built consistently and reliably is paramount. But what if the very process of building that software was inconsistent? That’s the challenge the team behind Bazel and Monobot are tackling, and the results are pretty exciting. Let’s dive in! ...

June 9, 2025 · 4 min

What can Postgres learn from DuckDB?

Presenters Jelte Fennema-Nio Source PGConf.dev 2025 🚀 DuckDB: The Analytical Database That’s Changing the Game 💡 Are you a data scientist, analyst, or just someone wrestling with large datasets? Do you find traditional database solutions clunky and slow? Then get ready to meet DuckDB, a rising star in the world of analytical databases that’s quickly gaining a devoted following. This post breaks down everything you need to know about DuckDB, from its core concepts to its impressive capabilities. Let’s dive in! ...

June 9, 2025 · 4 min