Presenters David Wheeler Source PGConf.dev 2025 Taming the Beast: Simplifying PostgreSQL Extension Management in Kubernetes 🚀 Managing PostgreSQL extensions in cloud-native environments, especially Kubernetes, can feel like wrestling a hydra. Each head represents a dependency, a configuration quirk, or a deployment hurdle. This presentation segment tackles this challenge head-on, outlining a vision for a more streamlined, accessible, and immutable extension ecosystem. The Current State of Affairs: A Complex Web 🕸️ ...

Presenters Dian Fay Source PGConf.dev 2025 Wrangling PostgreSQL: A Realistic Look at Production Database Management 🛠️ Let’s be honest: working with PostgreSQL in production isn’s always a walk in the park. While it’s a powerful and feature-rich database, it demands a level of understanding that can be challenging, especially for those who find themselves as accidental DBAs - developers thrust into database management roles. This post distills the key takeaways from a recent presentation, offering a candid look at the challenges, tradeoffs, and emerging solutions in the world of PostgreSQL. ...

Presenters Ashutosh Bapat Source PGConf.dev 2025 Level Up Your PostgreSQL: A Deep Dive into Dynamic Shared Buffer Resizing 🚀 For PostgreSQL DBAs and developers, performance is everything. But what happens when your database is struggling under load? Often, that means adjusting the shared buffers – a critical component for caching data and speeding up queries. Unfortunately, the current process for resizing these buffers in PostgreSQL is… well, let’s just say it’s not ideal. 😬 ...

Presenters William Zhang Source PGConf.dev 2025 🚀 Protox: Revolutionizing PostgreSQL Tuning with a Holistic Approach 🌐 Are you struggling to optimize your PostgreSQL database? Traditional tuning methods often fall short, tackling individual components in a sequential manner. Enter Protox, a groundbreaking system that’s changing the game by taking a holistic approach. Let’s dive into what makes Protox so special and the impressive results it’s achieving! 🎯 What is Protox and Why Does it Matter? Protox isn’t just another tuning tool; it’s a paradigm shift. It aims to find the absolute best configuration for your PostgreSQL database, considering a vast array of settings and options – everything from system knobs to table-level adjustments and even query hints. The result? Significant performance gains. ...

Presenters Robert Haas Source PGConf.dev 2025 Level Up Your Code Review Game: Lessons from the PostgreSQL Masters 🚀💡👨‍💻 Ever wondered what it takes to build a database system as robust and reliable as PostgreSQL? It’s not just about clever algorithms and efficient data structures – it’s about a culture of rigorous code review. Recently, Robert Haas, a long-standing PostgreSQL committer, shared invaluable insights on this very topic, and we’ve broken down the key takeaways for you. ...