A journey toward the columnar data store - lessons from past discussions and new proposals

Presenters Aya Iwata Source PGConf.dev 2025 🚀 Supercharge Your Analytics: Fujitsu’s Columnar 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 Columnar data store, and a groundbreaking community proposal called the Vertical Clustered Index (VCI)! ...

June 9, 2025 · 4 min

Adventures in Extension Packaging

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

June 9, 2025 · 4 min

Changing shared_buffers on the fly

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

June 9, 2025 · 4 min

Compiling Postgres to WASM with PGlite

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

June 9, 2025 · 4 min

Keynote: From RAP to Snowflake - A Look at 50 Years of SQL DB Scalability

Presenters David J. DeWitt Source PGConf.dev 2025 The Unexpected Rise of PostgreSQL: A Journey Through Database Scalability 🚀 For those of us immersed in the world of data, the evolution of database systems is a fascinating story of innovation, adaptation, and sometimes, unexpected turns. This presentation, delivered by a seasoned industry veteran, offers a captivating retrospective on that journey, spanning from the 1980s to the present day. Forget the hype cycles – this is a grounded look at how we got here, and what the future might hold. ...

June 9, 2025 · 4 min