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
  • Yury Zhukovets
    Yury Zhukovets Digital Design

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

  • Евгений Бредня
    Евгений Бредня 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.

  • Aleksandr Kalendaryov
    Aleksandr Kalendaryov Datagile

    This talk will likely be of interest to network providers who can enhance their cool features by adding something to the syntax to simplify administration, as well as anyone interested in machine learning. We will explore the SQL parsing mechanism, what, where, and how to modify it in order to introduce new syntax constructs. Additionally, I will demonstrate the capabilities of machine learning on tabular data, all within the database, using the new syntax.

  • Karel van der Walt
    Karel van der Walt MentalArrow

    Experience Report addressing the manual migration of MS SQL Server Stored Procedures and Table-Valued Functions to PL/pgSQL. We chose a manual migration from T-SQL over using a PostgreSQL Extension with an automated translation. The motivation was that the T-SQL code contains non-trivial business logic for which we wanted idiomatic PL/pgSQL code. 

    The T-SQL Code used features like 

    • Mix of Stored Procedures and Table-valued Functions

    • Table variables, (user-defined) table types 

    • Recursive Common Table Expressions 

    • Optional parameters 

    The migration required

    • Adopting naming conventions 

    • Renaming parameters and local variables 

    • Maping table types 

    • Mapping table-valued parameters to arrays 

    • Mapping table-valued return types to SETOF record

    • Translating between arrays and tables 

    In this session we will migrate a chain of dependend functions T-SQL functions to PL/pgSQL. We will work around quirks in both T-SQL functions and PL/pgSQL.

All talks

Informational