System Architecture and Design

Presenters Melanie Plageman Source PGConf.dev 2025 🐌 The Quest for Smarter Vacuuming in PostgreSQL: A Journey of Discovery (and a Few Setbacks) 🐌 Hey everyone! Ever wondered what happens behind the scenes in your PostgreSQL database? It’s not all just queries and results. There’s a vital, often unseen process keeping things running smoothly: vacuuming. And as PostgreSQL evolves, so too must our approach to this critical operation. Recently, I attended a fascinating presentation diving deep into the complexities of PostgreSQL vacuuming and transaction ID (XID) management. It wasn’t a straightforward success story – it was a journey of exploration, experimentation, and ultimately, a humbling realization about the challenges of adaptive algorithms. Let’s break down what we learned! ...

Presenters Matthias van de Meent Source PGConf.dev 2025 🚀 Level Up PostgreSQL: Optimizing Shared Memory for Peak Performance 💾 PostgreSQL is a powerhouse database, but even powerhouses can benefit from optimization! Recently, Matias presented a fascinating look at proposed changes to PostgreSQL’s shared memory structures, and we’re breaking down the key takeaways to help you understand how these changes can impact your database’s performance and resource usage. Let’s dive in! ...

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 David J. DeWitt Source PGConf.dev 2025 The Unexpected Rise of PostgreSQL: A Journey Through Database Scalability 🚀 For those of us immersed in the world of data, the evolution of database systems is a fascinating story of innovation, adaptation, and sometimes, unexpected turns. This presentation, delivered by a seasoned industry veteran, offers a captivating retrospective on that journey, spanning from the 1980s to the present day. Forget the hype cycles – this is a grounded look at how we got here, and what the future might hold. ...