PGConf.Russia 2025

In today’s rapidly evolving technology landscape, PostgreSQL has emerged as a popular choice for organizations seeking to leverage the power of open-source databases while maintaining scalability, performance, and flexibility. 

As enterprises migrate from proprietary database systems like Oracle to PostgreSQL, developers face the challenge of adapting existing PL/SQL codebases to PL/pgSQL. Despite the similarities between these two procedural languages, significant differences in their syntax, performance characteristics, and ecosystem features require a thoughtful approach to migration and optimization. 

This session will focus on highlighting the key differences between Oracle’s PL/SQL and PostgreSQL’s PL/pgSQL, providing actionable insights on how to efficiently navigate these differences during migration. A deep dive will be taken into critical areas including compilation methodology, Code Debugging , Exception Handling, work_mem , Bulk Load and more.

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.

Two years ago, I spoke about data retrieval queries, where the LINQ to DB library offers almost limitless possibilities.

This talk is about data modification operations. LINQ to DB allows you to execute UPDATE + JOIN queries, INSERT FROM SELECT, supports the MERGE operator, row-level locking with SELECT FOR UPDATE, temporary table creation, and features a fast data insertion mechanism.

I will also discuss the linq2db. EntityFrameworkCore project — a solution for those who aren’t ready to leave EF Core but still want the capabilities of LINQ to DB. I’ll share our experience implementing LINQ to DB in a large-scale project.

Sometimes, issues arise with the operation of PostgreSQL on Linux. We will define a classification of these scenarios and provide solutions, from simple to complex. Which failures lead to data corruption? Which scenarios are more dangerous than others, and what should be monitored? We will review logging examples from DBM.P Skala-R and analyze debugging scenarios, including OS libraries, Linux kernel, drivers, and kernel modules to identify causes and resolve errors.