PGConf.Russia 2025

For over a year, Postgres Pro has provided extended vacuum statistics, reflecting its operation on individual relations.

We've started receiving observations from production databases of clients that include these statistics. It has been quite successful, and in 2024, we began actively promoting vacuum statistics in PostgreSQL. In this talk, we will review what these statistics can tell us about the complex life of vacuum, using real-world data from live systems.

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.

What does a modern application developer need to transition from familiar cloud-based solutions to SQL databases?

This talk is a practical report on how we transformed an SQL database into a NoSQL-like solution with a developer-friendly interface. We’ll discuss:

What application developers expect from a data framework

How to implement declarative DDL, access control, and automation for reading and writing data

Simplified DML operations, pagination, and other essential features for application development

Poolers play a crucial role in PostgreSQL database operations. In this talk, we’ll discuss the challenges we faced when using and implementing existing poolers and the benefits we gained by developing our own pooler.