Observability

Presenters Paul Jungwirth Dignös Böhlen and Gamper Source PGConf.dev 2025 🚀 Diving Deep: Benchmarking PostgreSQL Foreign Keys and Uncovering Surprises 🤯 Ever wondered how your database performs under pressure? What about those seemingly small decisions – like how you implement foreign key constraints? A recent presentation delved into the fascinating world of PostgreSQL foreign key performance, revealing some unexpected twists and turns. Let’s break down the journey and the key takeaways! ...

Presenters Thomas Munro Stonebraker Source PGConf.dev 2025 Postgres’ Path to Multi-Threading: A Complex Journey 🚀💡👨‍💻 PostgreSQL is a powerhouse database, but its architecture presents some interesting challenges when it comes to scaling performance. This presentation segment dives deep into the ambitious goal of transforming PostgreSQL into a truly multi-threaded database, outlining the challenges, proposed solutions, and current progress. The speaker emphasizes that this isn’t a simple task, requiring significant architectural changes and community effort. ...

Presenters Peter Geoghegan Source PGConf.dev 2025 Supercharging PostgreSQL: Mastering Complex OR Queries for Lightning-Fast Performance 🚀 Have you ever felt like your PostgreSQL queries were hitting a performance wall, especially when dealing with multiple OR conditions across indexed columns? You’re not alone! This presentation segment dives deep into the fascinating evolution of PostgreSQL’s query optimizer, revealing how it’s tackling this challenge head-on. 💡 The Problem: The Bitmap OR Bottleneck 😩 Traditionally, queries with complex OR conditions often defaulted to a “bitmap OR” approach. While functional, this method comes with a significant cost: ...

Presenters Karen Jex Source PGConf.dev 2025 🚀 Building a More Inclusive PostgreSQL Community: A Look at PGEU’s Diversity Task Force 🌐 The PostgreSQL ecosystem is known for its technical prowess and robust database solutions. But what about the people behind the code? A recent talk at Postgres Europe (PGEU) highlighted a vital initiative: the Diversity Task Force and their mission to cultivate a more inclusive and welcoming community. This isn’t just about ticking boxes; it’s about fostering a sense of belonging, unlocking innovation, and ensuring everyone feels welcome and valued. Let’s dive into what they’ve been doing, what’s next, and how you can help! ...

Presenters Yuya Watari Source PGConf.dev 2025 🚀 Level Up Your PostgreSQL: Custom Transaction Management for the Modern Age 🌐 PostgreSQL is a powerhouse, but are its default transaction management settings keeping up with the demands of today’s distributed database deployments? The answer, increasingly, is no. A recent presentation delved deep into this challenge, showcasing a compelling solution: custom transaction management using a new framework called XTM (eXtendable Transaction Manager). Let’s break down what this means and why it matters. ...