PGConf.Russia 2025

In 2024, Postgres Professional introduced pgpro-otel-collector, a new tool for gathering PostgreSQL telemetry data using OpenTelemetry technologies and standards.

In this talk, I’ll explain why we chose OpenTelemetry, showcase the features of pgpro-otel-collector, and demonstrate how it helps streamline telemetry collection within a monitoring infrastructure.

Databases are a core component of any information system, and query performance directly impacts overall efficiency.

Last year, we explored suboptimal queries and optimization techniques, and the topic proved highly relevant. In this second installment, we’ll cover:

Using extended statistics for computed columns

Pagination techniques for improved query handling

Real-world optimization examples from 1C

The issue of slow month-end closing and cost calculation on PostgreSQL has been a long-standing problem. In this talk, we will explore what modern versions of PostgreSQL offer in this regard and answer the question, "Do replicas slow down the master?"

We will also take a look at different types of physical replication and, for dessert, share a recipe for quick and painless month-end closing in 1C without affecting the daily operations of users.

Currently, WAL files can be compressed with a ratio of up to 6x, but the existing compression system is inefficient.

In this talk, I’ll share my work on improving WAL compression.