PGConf.Russia 2025

Over 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.

Dozens of PostgreSQL instances have replaced a single large Oracle database. One of our key business systems was completely redesigned and rebuilt on an import-independent solution.  

This talk will cover the unique challenges, architecture, issues, and operational aspects of this migration. Expect an insightful deep dive into the process!

Many Russian companies are striving to establish themselves in the relational database market by developing their own commercial solutions, often based on forks of vanilla PostgreSQL. But beyond the database itself, customers also need a graphical management tool — Enterprise Manager. Since forking it is extremely challenging, vendors often have to build their own from scratch while considering competitive solutions.

This talk will explore Enterprise Managers from various Russian database vendors, comparing their key features — functionality, usability, and design — to identify which one stands out as the most effective.

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.