System Architecture and Design

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

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