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 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.
-
Евгений Бузюркин PostgresPro
Дарья Барсукова НГУ
Рустам Хамидуллин PostgresProIn PostgreSQL performance testing, benchmarks measure query execution time (latency). To get more reliable results, queries are executed repeatedly, generating a dataset of latency values. Performance is often assessed using standard metrics like the median or mean, but we propose a more advanced approach.
In practice, latency distributions are often multimodal, consisting of multiple underlying distributions with distinct characteristics. In such cases, traditional statistical methods are insufficient, requiring a more detailed analysis of the dataset’s structure.
Our work presents a tool that automatically performs statistical analysis of benchmark results, accounting for dataset-specific features. It detects multimodality, identifies the number and boundaries of dominant modes, and determines key distribution parameters—providing deeper insights into PostgreSQL performance variations.
-
Karel van der Walt MentalArrowExperience Report addressing the manual migration of MS SQL Server Stored Procedures and Table-Valued Functions to PL/pgSQL. We chose a manual migration from T-SQL over using a PostgreSQL Extension with an automated translation. The motivation was that the T-SQL code contains non-trivial business logic for which we wanted idiomatic PL/pgSQL code.
The T-SQL Code used features like
-
Mix of Stored Procedures and Table-valued Functions
-
Table variables, (user-defined) table types
-
Recursive Common Table Expressions
-
Optional parameters
The migration required
-
Adopting naming conventions
-
Renaming parameters and local variables
-
Maping table types
-
Mapping table-valued parameters to arrays
-
Mapping table-valued return types to SETOF record
-
Translating between arrays and tables
In this session we will migrate a chain of dependend functions T-SQL functions to PL/pgSQL. We will work around quirks in both T-SQL functions and PL/pgSQL.
-
-
Владимир КомаровThere are many administrator consoles out there, ranging from the old-school DBeaver to the ubiquitous pgAdmin. However, we decided to create another one. Why?
In this talk, you’ll learn:
-
How can a single installation manage tens of thousands of database instances.
-
How many users can the console support.
-
How can you inventory your infrastructure without losing your sanity.
-
How do you integrate into an existing environment without starting from scratch.
-
How to build a security model that earns the trust of leading banks and telecom operators.
-
How can you get hands-on experience with all of this.
-
Photos
Photo archive