Posts

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

Presenters Andres Freund Source PGConf.dev 2025 Okay, great! Here’s the blog post, incorporating your feedback and aiming for a compelling narrative. Diving Deep: The PostgreSQL AIO Journey – Lessons in Patience, Perseverance, and Performance 🚀💡 PostgreSQL, the powerhouse open-source relational database, is constantly evolving. One of the most exciting and ambitious projects underway is the addition of asynchronous I/O (AIO). But adding AIO isn’s as simple as dropping in a few lines of code. It’s a deep dive into the core of the system, a journey fraught with challenges, and a testament to the power of perseverance. Let’s explore this fascinating project and what we can learn from it. ...

Presenters David Rowley Source PGConf.dev 2025 Supercharging PostgreSQL: A Deep Dive into Memory Access Patterns 🚀 PostgreSQL is a powerhouse database, but even the best systems can benefit from optimization. This presentation segment peeled back the layers, revealing how subtle changes in memory access patterns can lead to massive performance gains. Forget just optimizing individual queries - we’re talking about fundamentally changing how PostgreSQL interacts with your CPU! 🧠 The Core Message: It’s All About the Prefetcher! 🎯 ...