Tracking plan shapes over time with Plan IDs, and a new pg_stat_plans

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

June 9, 2025 · 4 min

What 10 Postgres Major Contributors Did to Become a Hacker

Presenters Claire Giordano Robert Haas Source PGConf.dev 2025 🚀 Decoding the PostgreSQL Contributor’s Journey: Beyond the Code 💡 Ever wondered what it really takes to contribute to a massive open-source project like PostgreSQL? It’s more than just being a coding whiz. This post dives into the fascinating “Lessons Learned From PostgreSQL Contributors,” revealing the often-unspoken aspects of open-source collaboration – the invisible curriculum, the emotional intelligence, and the collaborative practices that separate good contributors from exceptional ones. Let’s explore! ...

June 9, 2025 · 4 min

What can Postgres learn from DuckDB?

Presenters Jelte Fennema-Nio Source PGConf.dev 2025 🚀 DuckDB: The Analytical Database That’s Changing the Game 💡 Are you a data scientist, analyst, or just someone wrestling with large datasets? Do you find traditional database solutions clunky and slow? Then get ready to meet DuckDB, a rising star in the world of analytical databases that’s quickly gaining a devoted following. This post breaks down everything you need to know about DuckDB, from its core concepts to its impressive capabilities. Let’s dive in! ...

June 9, 2025 · 4 min

What does moving to Pull Requests look like? The nginx story

Presenters Alastair Turner Source PGConf.dev 2025 🚀 From Mailing Lists to Pull Requests: Can PostgreSQL Embrace GitHub? 🌐 The PostgreSQL community is a cornerstone of the open-source world, known for its robust database and dedicated contributors. But as the landscape of software development evolves, so too does the question of how best to manage contributions. Should PostgreSQL, traditionally reliant on mailing lists, consider embracing GitHub pull requests? The recent presentation on “From Mailing Lists to Pull Requests: Lessons from Nginx’s Journey” offered some fascinating insights, drawing on the experience of the Nginx project. Let’s dive into what we learned! ...

June 9, 2025 · 3 min

What is new in C and POSIX?

Presenters Peter Eisentraut Source PGConf.dev 2025 🚀 Level Up PostgreSQL: Embracing the Future of C 🛠️ Hey everyone! Let’s dive into a fascinating exploration of how PostgreSQL can benefit from embracing newer C language standards. This isn’s just about fancy new syntax; it’s about making our codebase safer, more readable, and ultimately, more robust. The presentation outlined a roadmap for modernizing PostgreSQL’s C language baseline, and we’re going to break down the key takeaways. ...

June 9, 2025 · 3 min