Data Engineering

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 Tomas Vondra Source PGConf.dev 2025 🚀 Level Up Your PostgreSQL Performance: A Deep Dive into Fast Path Locking (and What We Learned!) 🛠️ Hey everyone! Ever feel like you’re chasing a performance bottleneck, only to find another one lurking just around the corner? That’s exactly what Thomas explored in a fascinating presentation on Fast Path Locking in PostgreSQL, and we’re breaking down the key takeaways for you today. This isn’t just about a technical trick; it’s a masterclass in how PostgreSQL development really works and the iterative nature of performance tuning. ...

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 Matthias van de Meent Source PGConf.dev 2025 🚀 Level Up PostgreSQL: Optimizing Shared Memory for Peak Performance 💾 PostgreSQL is a powerhouse database, but even powerhouses can benefit from optimization! Recently, Matias presented a fascinating look at proposed changes to PostgreSQL’s shared memory structures, and we’re breaking down the key takeaways to help you understand how these changes can impact your database’s performance and resource usage. Let’s dive in! ...

Presenters Paul Jungwirth Dignös Böhlen and Gamper Source PGConf.dev 2025 🚀 Diving Deep: Benchmarking PostgreSQL Foreign Keys and Uncovering Surprises 🤯 Ever wondered how your database performs under pressure? What about those seemingly small decisions – like how you implement foreign key constraints? A recent presentation delved into the fascinating world of PostgreSQL foreign key performance, revealing some unexpected twists and turns. Let’s break down the journey and the key takeaways! ...