PostgreSQL

Presenters Sam Willis Source PGConf.dev 2025 🚀 PG Lite: PostgreSQL Gets Tiny & Mighty with WebAssembly 🌐 The database world is evolving, and PostgreSQL is leading the charge! 💡 This isn’t hyperbole; as one speaker eloquently put it, “PostgreSQL is eating the database world.” But how can we make this already powerful system even more accessible and versatile? The answer, as demonstrated in a recent presentation, lies in PG Lite, a groundbreaking effort to embed a fully functional PostgreSQL within a WebAssembly (Wasm) environment. Let’s dive into what this means, why it’s so exciting, and where it’s headed. ...

Presenters Peter Geoghegan Source PGConf.dev 2025 Supercharging PostgreSQL: Mastering Complex OR Queries for Lightning-Fast Performance 🚀 Have you ever felt like your PostgreSQL queries were hitting a performance wall, especially when dealing with multiple OR conditions across indexed columns? You’re not alone! This presentation segment dives deep into the fascinating evolution of PostgreSQL’s query optimizer, revealing how it’s tackling this challenge head-on. 💡 The Problem: The Bitmap OR Bottleneck 😩 Traditionally, queries with complex OR conditions often defaulted to a “bitmap OR” approach. While functional, this method comes with a significant cost: ...

Presenters Jonathan Katz Melanie Plageman Source PGConf.dev 2025 Welcome to pgmp.dev 2025! 🎉 Let’s Dive into the Future of PostgreSQL 💾 Hey everyone! Welcome to pgmp.dev 2025! We’re thrilled to be back and ready to explore the exciting future of PostgreSQL. After a bit of a whirlwind last year, we’re laser-focused on delivering a packed agenda filled with insightful sessions, workshops, and community connection. Let’s get started! 🚀 Getting Situated & Staying Connected 🌐 Before we jump into the content, here’s a quick rundown of what to expect and how to make the most of the conference: ...

Presenters Gwen Shapira Source PGConf.dev 2025 Nile: Scaling PostgreSQL with Tenant Isolation - A Deep Dive 🚀 Ever wondered how to handle millions of tenants on a single PostgreSQL instance? The team behind Nile has tackled this ambitious goal, and their insights into a scalable tenant database are fascinating. This post dives into the architecture, motivations, benefits, and challenges of Nile, a system designed to handle massive multi-tenancy while retaining the power and flexibility of PostgreSQL. ...

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’s 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’s break down what this means and why it matters. ...