Data Engineering

Presenters David Wheeler Source PGConf.dev 2025 Taming the Beast: Simplifying PostgreSQL Extension Management in Kubernetes 🚀 Managing PostgreSQL extensions in cloud-native environments, especially Kubernetes, can feel like wrestling a hydra. Each head represents a dependency, a configuration quirk, or a deployment hurdle. This presentation segment tackles this challenge head-on, outlining a vision for a more streamlined, accessible, and immutable extension ecosystem. The Current State of Affairs: A Complex Web 🕸️ ...

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