System Architecture and Design

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

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