Security

Presenters Rahila Syed Source PGConf.dev 2025 🚀 Diving Deep: On-Demand Dynamic Statistics in PostgreSQL 💾 PostgreSQL, the powerhouse behind countless databases, is constantly evolving. Recently, a fascinating new feature has been developed: the ability to retrieve on-demand dynamic statistics about process memory usage. This isn’t your average database metric – it’s a deep dive into how PostgreSQL manages memory, and it’s surprisingly complex! Let’s break down what this means, why it’s important, and what’s under the hood. ...

Presenters Stacey Haysler Source PGConf.dev 2025 Level Up Your PostgreSQL Community: It’s About More Than Just Diversity 🚀💡👨‍💻 For years, the tech industry has wrestled with the challenge of diversity and inclusion. But what if there was a better way? What if we shifted our focus and redefined how we build and nurture our communities? This blog post dives into a fascinating presentation that argues exactly that – focusing on community development as the most effective path to a truly inclusive PostgreSQL ecosystem. Let’s explore how we can all contribute to a more welcoming and vibrant space for everyone. ...

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