System Architecture and Design

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 Jonathan Katz Source PGConf.dev 2025 Level Up Your Vector Search in PostgreSQL: What’s New with PGVector 0.8 and Beyond 🚀 Are you diving into the exciting world of vector search? 🌐 PostgreSQL, with its powerful pgvector extension, has become a go-to choice for many. But as workloads grow, we’re hitting some walls. Let’s explore the latest advancements in pgvector, the challenges we face, and what the future holds. What’s Vector Search, and Why Does it Matter? 🎯 Imagine searching for images that resemble a given image, or finding documents with similar themes. That’s the power of vector search! Instead of exact matches, you’re finding data based on similarity. The pgvector extension brings this capability to PostgreSQL, leveraging machine learning models (embedding models) to convert data into vectors. 💡 ...

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

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

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