PostgreSQL

Presenters Bohan Zhang Source PGConf.dev 2025 Pushing PostgreSQL to the Limit: Insights & Feature Requests from a High-Load Environment 🚀 Running a mature database like PostgreSQL at scale is a testament to its power and flexibility. However, as workloads grow and demands increase, the limitations of even the most robust systems become apparent. This presentation segment, gleaned from a deep dive into real-world PostgreSQL performance challenges, highlighted a wealth of observations and feature requests from a high-load environment. Let’s break down the key takeaways and explore how these insights can benefit the wider PostgreSQL community. ...

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 Lukas Fittl Source PGConf.dev 2025 🚀 Level Up Your PostgreSQL Performance with PG App Plans (PGAPP) 💡 PostgreSQL is a powerhouse database, but keeping it running smoothly requires constant vigilance. Ever felt like you were flying blind when trying to diagnose a performance bottleneck? You’re not alone! Traditional methods for monitoring query execution plans have their drawbacks. That’s why the development of PG App Plans (PGAPP) is so exciting. Let’s dive into what it is, why it matters, and what the future holds. ...

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