PGConf.Russia 2025

In some cases, business logic is implemented directly within the database. It's well known that maintaining and developing business logic becomes much easier when it's covered by tests. However, backend tests often treat the database as an external resource and don’t always interact with a live database.

This talk will introduce an enhanced version of the pgTap library, designed not only to facilitate unit testing and CI for database code but also to accelerate the development process itself.

For over a year, Postgres Pro has provided extended vacuum statistics, reflecting its operation on individual relations.

We've started receiving observations from production databases of clients that include these statistics. It has been quite successful, and in 2024, we began actively promoting vacuum statistics in PostgreSQL. In this talk, we will review what these statistics can tell us about the complex life of vacuum, using real-world data from live systems.

Diagnostic Methods: Analyzing the Issue of Long CREATE DATABASE Execution

This talk covers two cases of long CREATE DATABASE execution in PostgreSQL 11, which, in a Corosync/Pacemaker cluster configuration, caused node failover due to a monitoring timeout from the clustering software. The first case is related to a large shared buffers size, while the second involves the use of the WITH OWNER option during database creation and a large pg_shdepend system table (a feature of using the jBPM software).

In this session, we’ll provide an overview of the features of the pg_probackup3 backup utility. 

The new version has completely rethought the application architecture, introduced several long-awaited features, and added integration possibilities with other applications. We’ll dive into these updates and discuss them in detail during the presentation.