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.
-
Алексей Гордеев PostgresProI’ll talk about the challenges you’ll face if you decide to implement a new TableAM. What to choose: Generic XLog or Custom RMGR? Why use a Custom SMGR? How to integrate PostgreSQL allocators into third-party libraries, even if they don't officially support it? What’s missing for a columnar engine (including vectorization and late materialization), and how can we work around those limitations?
In the second part, I’ll dive into the internals of pgpro_tam — a new native table engine for OLAP that supports standard data formats, various SMGRs, and, if needed, third-party schedulers and execution engines, all while adhering to ACID principles. This is designed to achieve the fastest analytics on PostgreSQL (not just plugging in DuckDB).
-
Павел Филин YADROFor DBAs, ensuring database protection and integrity is always a top priority. Along with that comes the need to store data efficiently and compactly, without overloading the network, and ensuring reliable recovery.
In this talk, we’ll discuss a universal solution for backup and archive storage that not only offers effective deduplication but also minimizes network load. TATLIN.BACKUP is a platform for storing PostgreSQL backups or WAL archives with compression, deduplication, and minimal data transmission over the network.
TATLIN.BACKUP is a versatile solution for transferring and storing PostgreSQL archives at remote locations from a central office.
-
Александр Рулинский
Алексей Мигуцкий КонвертумThis talk will cover key aspects of migrating from SQL Server to PostgreSQL, with a focus on converting stored procedures, triggers, views, functions, and other database objects. We’ll discuss the unique characteristics of each database system that can complicate code conversion, as well as unexpected factors that impact performance and correctness.
The session will be valuable for both experienced database professionals and those new to database migrations.
Photos
Photo archive