Reproducible Postgres

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

June 9, 2025 · 4 min

Vector search is now boring, but PostgreSQL has ways to go

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

June 9, 2025 · 3 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 went wrong with AIO

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

June 9, 2025 · 4 min