Security

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

Presenters Palak Chaturvedi Source PGConf.dev 2025 💾 Data Corruption in PostgreSQL: Prevention, Detection, and Recovery 🚀 PostgreSQL is a powerhouse for data management, known for its reliability and robustness. But even the most reliable systems aren’t immune to data corruption. This post distills a recent technical presentation on this critical topic, providing practical advice and actionable steps you can take to protect your data. Let’s dive in! 🛠️ 1. Prevention: Building a Fortress Against Corruption 🛡️ The best defense is a good offense. Preventing data corruption in the first place is far easier (and less stressful!) than recovering from it. Here’s how to build a strong foundation: ...

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