Postgres Conference 2025 Program
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 Devpresented 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 OpsConfiguration 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 EssentialsWhy 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 DevelopmentYou 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 Opspresented 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 Essentialspresented 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 OpsFrom 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 CloudYour 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