PGConf.dev 2025

Presenters Aya Iwata Source PGConf.dev 2025 🚀 Supercharge Your Analytics: Fujitsu’s Calamina and the Vertical Clustered Index (VCI) 💡 Are you struggling to keep up with the ever-increasing demands of real-time analytics? Do you need blazing-fast query performance without sacrificing the speed of your operational updates? Then you’re going to want to learn about Fujitsu’s exciting work with PostgreSQL, the Calamina data store, and a groundbreaking community proposal called the Vertical Clustered Index (VCI)! ...

Presenters Michael Paquier Source PGConf.dev 2025 Unlock PostgreSQL’s Secrets: Mastering Injection Points for Advanced Testing 🚀 Ever wished you could peek behind the curtain of PostgreSQL and directly influence its behavior? Well, you can! This post dives into a fascinating (and admittedly complex) feature: injection points. These aren’t for your average user, but for developers and testers working on PostgreSQL itself, offering a unique window into its inner workings. 🛠️ ...

Presenters David Wheeler Source PGConf.dev 2025 Taming the Beast: Simplifying PostgreSQL Extension Management in Kubernetes 🚀 Managing PostgreSQL extensions in cloud-native environments, especially Kubernetes, can feel like wrestling a hydra. Each head represents a dependency, a configuration quirk, or a deployment hurdle. This presentation segment tackles this challenge head-on, outlining a vision for a more streamlined, accessible, and immutable extension ecosystem. The Current State of Affairs: A Complex Web 🕸️ ...

Presenters Dian Fay Source PGConf.dev 2025 Wrangling PostgreSQL: A Realistic Look at Production Database Management 🛠️ Let’s be honest: working with PostgreSQL in production isn’s always a walk in the park. While it’s a powerful and feature-rich database, it demands a level of understanding that can be challenging, especially for those who find themselves as accidental DBAs - developers thrust into database management roles. This post distills the key takeaways from a recent presentation, offering a candid look at the challenges, tradeoffs, and emerging solutions in the world of PostgreSQL. ...

Presenters Ashutosh Bapat Source PGConf.dev 2025 Level Up Your PostgreSQL: A Deep Dive into Dynamic Shared Buffer Resizing 🚀 For PostgreSQL DBAs and developers, performance is everything. But what happens when your database is struggling under load? Often, that means adjusting the shared buffers – a critical component for caching data and speeding up queries. Unfortunately, the current process for resizing these buffers in PostgreSQL is… well, let’s just say it’s not ideal. 😬 ...