Postgres Conference 2025 Program

Unscheduled events
Palak Chaturvedi Debugging Data Corruption in PostgreSQL

presented by Palak Chaturvedi

Data corruption in PostgreSQL can critically impact database integrity, leading to service disruptions, data loss, or incorrect query results. This proposal outlines a systematic methodology for identifying, diagnosing, and resolving data corruption in PostgreSQL databases. The approach integrates PostgreSQL’s built-in tools, Linux utilities, and advanced debugging techniques to diagnose errors...

more

Dev
Ibrar Ahmed Scaling PostgreSQL: Horizontal vs. Vertical

presented by Ibrar Ahmed

Scaling PostgreSQL is critical for handling larger workloads as your application grows. But what’s the best path: scale up or scale out? In this talk, we’ll explore both approaches, breaking down the tools, partitioning strategies, and performance considerations that make PostgreSQL shine in any scalability scenario. With insights tailored to PostgreSQL’s unique capabilities, you’ll walk away p...

more

Ops
Greg Dostatni Proper PostgreSQL Parameters to Prevent Poor Performance
Configuration Basics for All

presented by Greg Dostatni

Getting core parameters right is essential for ensuring good performance and stability from your PostgreSQL database. As PostgreSQL is now approaching 400 parameters that can be set in addition to OS, kernel and disk options, configuring a PostgreSQL database can be a daunting task. In this beginner friendly session, we will focus on some key parameters and discuss the trade-offs between them. ...

more

Essentials
Clay  Jackson Lead people, Manage Databases
Why people are more important than things

presented by Clay Jackson

Rear Admiral Grace Murray Hopper, "The mother of computer science" said repeatedly, "You lead people, you manage things".

In this presentation, we'll review principles of leadership, including: - Building trust - Identifying what matters - Walking other's shoes - Communication - People Development

We'll review how you can apply each of these principles to your career, if you're an i...

more

Professional Development
Grant Fritchey You Need a PostgreSQL Restore Plan, Not a Backup Plan
You are only as good as your last restore

presented by Grant Fritchey

Over and over, you'll hear the need to have a plan in place for backing up your PostgreSQL databases. However, this truly has things completely backwards. The most important thing is not your ability to backup a database. Instead, your most important ability will be to restore a database. This session will explore the concepts that will enable you to create a viable restore plan for your Postgr...

more

Ops
Lloyd Albin AutoVacuum - Tuning and Monitoring

presented by Lloyd Albin

I have been asked many times by other PostgreSQL DBA's about what could be causing queries to run progressively slower while their application is running but then runs fast again after the application is stopped and restarted a short time later or the database is reloaded from backup and now runs fast again. These can all be symptoms of AutoVacuum/AutoAnalyze/Index issues.

Some of the slow ...

more

Essentials
Alan Zakrzewski Rules of indexing in PostgreSQL

presented by Alan Zakrzewski

There are many articles about indexing in PostgreSQL, but very few present a complete picture. This session aims to provide the audience 'everything you need to know about indexing in PostgreSQL' in less than 50min. The presentation provides an overview of different types of indexes available, differences between them and some comparison with other RDBMSs. It also includes PostgreSQL specific i...

more

Ops
Andrey Borodin Data lifecycle management with SPQR and Apache Cloudberry
From shared_buffers to S3, without logical replication

presented by Andrey Borodin

There is a common data architecture pattern OLTP-CDC-OLAP. The operational database (OLTP) is constantly rebuilt in an analytical database (OLAP) through change data capture (CDC). CDC processes can be fragile: engineers need to scale them when they scale the databases, update them during database migrations, and constantly monitor them to ensure that everything is up-to-date.

SPQR (Stateles...

more

Variants and Cloud
Shine Zhang From Greenplum to Apache Cloudberry
Your new choice for distributed analytic workloads with PG kernel

presented by Shine Zhang

If you are interested in using PostgreSQL kernel for analytics, come and join us! We are introducing Apache Cloudberry as a PostgreSQL variant to the community. It's designed based on PostgreSQL as kernel and aims to process distributed analytic workloads. Cloudberry adopts a MPP shared-nothing architecture fully integrated with PostgreSQL 14.4.

We added quite a few new features to make it ...

more

Variants and Cloud