PostgreSQL container groups, aka cgroups down the road

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

June 9, 2025 · 4 min

postgresql.org: The hidden parts

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

June 9, 2025 · 3 min

Re-engineering Postgres for Millions of Tenants

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

June 9, 2025 · 4 min

Reproducible Postgres

Presenters Javier Maestro Alvaro Hernandez Source PGConf.dev 2025 🚀 Building Trust: How Bazel & Monobot are Revolutionizing PostgreSQL Builds 💾 The world of open-source software is built on trust. We rely on the integrity of the code we use, and ensuring that code is built consistently and reliably is paramount. But what if the very process of building that software was inconsistent? That’s the challenge the team behind Bazel and Monobot are tackling, and the results are pretty exciting. Let’s dive in! ...

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

June 9, 2025 · 3 min