System Architecture and Design

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 Cédric Villemain Source PGConf.dev 2025 Level Up Your PostgreSQL Performance with cgroups and eBPF 🚀 Are you a PostgreSQL DBA or systems engineer looking for ways to squeeze even more performance out of your database? Do you dream of fine-grained control over resource allocation? Then buckle up, because we’re diving into the fascinating world of cgroups and eBPF, and how they can revolutionize your PostgreSQL setup! This post summarizes a recent presentation that explored a deep dive into these technologies and their potential to unlock a new level of resource management for your PostgreSQL deployments. Let’s break it down! ...

Presenters Magnus Hagander Source PGConf.dev 2025 Keeping Postgres Running: A Look Inside Their Infrastructure Needs 🚀 Postgres.com, the global postcard platform, powers connections between people around the world. But behind the beautiful postcards and vibrant community lies a critical infrastructure that needs constant attention. Recently, a presentation shed light on the challenges and opportunities surrounding Postgres’s technical foundation. Let’s dive in! The Foundation: Stability First 🛠️ Postgres prioritizes a core philosophy: stability and maintainability above all else. They’re not chasing the latest and greatest tech; they’s focused on providing reliable services for developers and users. This means choosing technologies and approaches that ensure consistent performance and uptime. ...

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