Data Engineering

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

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