PGConf.Russia 2025

Moscow, Krasnopresnenskaya Naberezhnaya 12, Business Centre World Trade Centr

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

more than
0 participants
0 speakers
0
minutes of conversation
63 talks
hybrid
format

Владимир Комаров
Kintsugi — A New Tool for Database Administrators

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.
Presentation materials
Дмитрий Ремизов ГНИВЦ

Dancing Around Foreign Keys: Challenges in FK Creation and Validation

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.

Presentation materials
Alexey Lesovsky PostgresPro

Monitoring PostgreSQL with OpenTelemetry

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

Presentation materials
Yury Zhukovets Digital Design
SQL to PG Migration and Operational Experience with the "Priorytet" ECM System for a High-Load Client with a DB Volume of 8+ TB of Structured Data

In this talk, we’ll:
- Share our experience of reworking the ECM system and platform that was originally built on C.Net + MS SQL for Windows to run on Linux + Postgres, while maintaining the option to install and operate on Windows + MS.
- Discuss migrating clients to new platforms with data migration.
- Share insights from operating the system with a high-load client (PG servers with 192 cores and 3 TB of RAM).
Presentation materials

All talks

Informational

All photos

title

PGConf.Russia 2025

PGConf.Russia 2025

Agenda highlights

Talks

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.

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.

In this talk, we’ll:

Share our experience of reworking the ECM system and platform that was originally built on C.Net + MS SQL for Windows to run on Linux + Postgres, while maintaining the option to install and operate on Windows + MS.

Discuss migrating clients to new platforms with data migration.

Share insights from operating the system with a high-load client (PG servers with 192 cores and 3 TB of RAM).

Informational

Photos