Artificial Intelligence

Presenters Gary Evans Nishchay Kothari Source PGConf.dev 2025 🚀 Learned Indexes & PostgreSQL: A Challenging Integration Journey 💡 PostgreSQL is a powerhouse of a database, relied on by countless applications. But as workloads evolve – especially those driven by machine learning and AI – traditional indexing methods sometimes struggle to keep pace. This presentation explored a fascinating, and ultimately complex, journey: attempting to integrate Microsoft’s learned index structure, “Alex,” directly into PostgreSQL. While the initial ambition was high, the experience highlighted some critical architectural realities and paved the way for exciting, more targeted solutions. Let’s dive in! ...

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! ...

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! ...

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! ...