Observability

Presenters Michael Paquier Source PGConf.dev 2025 Unlock PostgreSQL’s Secrets: Mastering Injection Points for Advanced Testing 🚀 Ever wished you could peek behind the curtain of PostgreSQL and directly influence its behavior? Well, you can! This post dives into a fascinating (and admittedly complex) feature: injection points. These aren’t for your average user, but for developers and testers working on PostgreSQL itself, offering a unique window into its inner workings. 🛠️ ...

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