PostgreSQL Europe Diversity Task Force

Presenters Karen Jex Source PGConf.dev 2025 馃殌 Building a More Inclusive PostgreSQL Community: A Look at PGEU鈥檚 Diversity Task Force 馃寪 The PostgreSQL ecosystem is known for its technical prowess and robust database solutions. But what about the people behind the code? A recent talk at Postgres Europe (PGEU) highlighted a vital initiative: the Diversity Task Force and their mission to cultivate a more inclusive and welcoming community. This isn鈥檛 just about ticking boxes; it鈥檚 about fostering a sense of belonging, unlocking innovation, and ensuring everyone feels welcome and valued. Let鈥檚 dive into what they鈥檝e been doing, what鈥檚 next, and how you can help! ...

June 9, 2025 路 4 min

Revisiting XTM: A Practical Case Study Highlighting Its Needs

Presenters Yuya Watari Source PGConf.dev 2025 馃殌 Level Up Your PostgreSQL: Custom Transaction Management for the Modern Age 馃寪 PostgreSQL is a powerhouse, but are its default transaction management settings keeping up with the demands of today鈥檚 distributed database deployments? The answer, increasingly, is no. A recent presentation delved deep into this challenge, showcasing a compelling solution: custom transaction management using a new framework called XTM (eXtendable Transaction Manager). Let鈥檚 break down what this means and why it matters. ...

June 9, 2025 路 3 min

Scaling Postgres to the next level at OpenAI

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鈥檚 break down the key takeaways and explore how these insights can benefit the wider PostgreSQL community. ...

June 9, 2025 路 4 min

Tracking plan shapes over time with Plan IDs, and a new pg_stat_plans

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鈥檙e not alone! Traditional methods for monitoring query execution plans have their drawbacks. That鈥檚 why the development of PG App Plans (PGAPP) is so exciting. Let鈥檚 dive into what it is, why it matters, and what the future holds. ...

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鈥檚 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鈥檙e hitting some walls. Let鈥檚 explore the latest advancements in pgvector, the challenges we face, and what the future holds. What鈥檚 Vector Search, and Why Does it Matter? 馃幆 Imagine searching for images that resemble a given image, or finding documents with similar themes. That鈥檚 the power of vector search! Instead of exact matches, you鈥檙e 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