Posts

Presenters Javier Maestro Alvaro Hernandez Source PGConf.dev 2025 🚀 Building Trust: How Bazel & Monobot are Revolutionizing PostgreSQL Builds 💾 The world of open-source software is built on trust. We rely on the integrity of the code we use, and ensuring that code is built consistently and reliably is paramount. But what if the very process of building that software was inconsistent? That’s the challenge the team behind Bazel and Monobot are tackling, and the results are pretty exciting. Let’s dive in! ...

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

Presenters Bohan Zhang Source PGConf.dev 2025 Pushing PostgreSQL to the Limit: Insights & Feature Requests from a High-Load Environment 🚀 Running a mature database like PostgreSQL at scale is a testament to its power and flexibility. However, as workloads grow and demands increase, the limitations of even the most robust systems become apparent. This presentation segment, gleaned from a deep dive into real-world PostgreSQL performance challenges, highlighted a wealth of observations and feature requests from a high-load environment. Let’s break down the key takeaways and explore how these insights can benefit the wider PostgreSQL community. ...

Presenters Marco Slot Source PGConf.dev 2025 ⚠️ Navigating the Wild West of PostgreSQL Extensions: A Developer’s Guide 🛠️ PostgreSQL extensions are a huge deal. They allow us to supercharge our databases with custom functionality, from spatial data processing (thanks, PostGIS!) to advanced replication. But as one recent presentation revealed, the world of PostgreSQL extensions isn’t always sunshine and rainbows. It can be a bit of a… wild west. 🤠 This post dives into the key takeaways from that presentation, highlighting potential pitfalls and offering practical advice for developers. Let’s get started! ...

Presenters Lukas Fittl Source PGConf.dev 2025 🚀 Level Up Your PostgreSQL Performance with PG App Plans (PGAPP) 💡 PostgreSQL is a powerhouse database, but keeping it running smoothly requires constant vigilance. Ever felt like you were flying blind when trying to diagnose a performance bottleneck? You’re not alone! Traditional methods for monitoring query execution plans have their drawbacks. That’s why the development of PG App Plans (PGAPP) is so exciting. Let’s dive into what it is, why it matters, and what the future holds. ...