Programming Language

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