title

text

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

Talks

Talks archive

PGConf.Russia 2025
  • Евгений Бредня
    Евгений Бредня PostgresPro

    In this talk, we will discuss what character encodings and collations are. I will explain the issues that can arise from sorting (COLLATION) in databases and show how these problems can be addressed using the COLLATION PROVIDER = ICU feature in PostgreSQL.

  • Вадим Войтенко
    Вадим Войтенко

    Greenmask is an open-source utility for database anonymization and synthetic data generation. A common challenge in development is creating test environments that closely resemble production. In this talk, we will explore how to use Greenmask’s features to prepare a test environment with ease. 

    We will discuss its architecture, database subsets, types of transformations, the reasons for integrating with the PostgreSQL driver, and porting some pg libraries. Additionally, we will explain how our technology helps businesses solve problems faster, more efficiently, and securely.

  • Дмитрий Ремизов
    Дмитрий Ремизов ГНИВЦ

    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.

  • Александр Попов
    Александр Попов PostgresPro

    This talk will explore different approaches to storing files in PostgreSQL, including:

    • Simple table-based storage

    • Large objects with pg_largeobject

    • pgpro_sfile – a large object (pgpro_bfile) storage solution

All talks

Informational