31 March – 01 April 2025
PGConf.Russia 2025
PGConf.Russia is the largest PostgreSQL conference in Russia and the CIS. The event offers technical sessions, hands-on demos of new DBMS features, master classes, networking opportunities, and knowledge exchange with top PostgreSQL community experts. Each year, hundreds of professionals participate, including DBAs, database architects, developers, QA engineers, and IT managers.
Agenda highlights
-
Latest news and updates from the PostgreSQL global community
-
Monitoring, high availability, and security
-
Streamlined migration from Oracle, Microsoft SQL Server, and other systems
-
Query optimization
-
Scalability, sharding and partitioning
-
AI applications in DBMS
-
PostgreSQL compatibility with other software
Talks
Talks archive
-
Andrey Zubkov PostgresProFor 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.
-
Alexey Lesovsky PostgresProIn 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.
-
Петр Петров PostgresProDatabases 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
-
Andrey Borodin YandexCurrently, 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.
Photos
Photo archive