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
-
Сергей Кузнецов ОТР 2000
Ирина Токарева ОТР -
Дмитрий Ремизов ГНИВЦThis talk explores the challenges we encountered — and solved — while migrating massive databases from Oracle to PostgreSQL.
One of the most complex aspects of this process was rebuilding foreign keys (FKs). To overcome these challenges, we had to dive deep into the internal workings of FK creation and validation.
Key topics include:
Does ALTER TABLE ... ADD CONSTRAINT ... FOREIGN KEY have an execution plan?
Can an ordinary user influence this process?
What locks are applied during FK creation and validation?
Also, we’ll introduce a first-principles method for investigating performance issues, applying it to a real-world FK creation bottleneck.
-
Александр Степашкин PostgresProA brief presentation on various extensions that can assist with optimization.
-
Александр Попов PostgresProOver the past year, pgpro_redefinition has undergone significant enhancements. In this talk, we’ll review the key updates, improvements, and new capabilities that have been introduced.
Photos
Photo archive