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
-
Karel van der Walt MentalArrowExperience 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.
-
-
Anatoly Anfinogenov АО "ВНИИЖТ"This talk addresses a common issue and touches a bit on application architecture. Temporary tables in database applications are typically used for several purposes.
Firstly, they are used to store intermediate results when implementing complex data processing algorithms. Secondly, in the case of stored procedures, application servers often place large datasets into temporary tables when they are too large or inconvenient to pass as parameters to stored procedures.
The handling of temporary tables in different DBMSs is implemented in various ways, which often complicates migration from these systems to Postgres.
The drawbacks of temporary tables are well-known, which leads to a reasonable desire to replace them, where possible, with other methods that can achieve the same goal. This talk focuses on alternative mechanisms provided by Postgres to solve this problem.
-
Александр Попов PostgresProThis 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
-
-
Александр Рулинский
Алексей Мигуцкий КонвертумThis talk will cover key aspects of migrating from SQL Server to PostgreSQL, with a focus on converting stored procedures, triggers, views, functions, and other database objects. We’ll discuss the unique characteristics of each database system that can complicate code conversion, as well as unexpected factors that impact performance and correctness.
The session will be valuable for both experienced database professionals and those new to database migrations.
Photos
Photo archive