Cloud

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

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

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