Data Engineering

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 Sam Willis Source PGConf.dev 2025 🚀 PG Lite: PostgreSQL Gets Tiny & Mighty with WebAssembly 🌐 The database world is evolving, and PostgreSQL is leading the charge! 💡 This isn’t hyperbole; as one speaker eloquently put it, “PostgreSQL is eating the database world.” But how can we make this already powerful system even more accessible and versatile? The answer, as demonstrated in a recent presentation, lies in PG Lite, a groundbreaking effort to embed a fully functional PostgreSQL within a WebAssembly (Wasm) environment. Let’s dive into what this means, why it’s so exciting, and where it’s headed. ...

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