PGConf.Russia 2025

A brief presentation on various extensions that can assist with optimization.

Currently, WAL files can be compressed with a ratio of up to 6x, but the existing compression system is inefficient.

In this talk, I’ll share my work on improving WAL compression.

There are many administrator consoles out there, ranging from the old-school DBeaver to the ubiquitous pgAdmin. However, we decided to create another one. Why?

In this talk, you’ll learn:

• How can a single installation manage tens of thousands of database instances.

• How many users can the console support.

• How can you inventory your infrastructure without losing your sanity.

• How do you integrate into an existing environment without starting from scratch.

• How to build a security model that earns the trust of leading banks and telecom operators.

• How can you get hands-on experience with all of this.

The visibility map in PostgreSQL is an important mechanism for optimizing database performance, accelerating read operations, data cleanup, and indexing. Despite some limitations, such as memory consumption and fragmentation, its use can significantly enhance performance in high-load systems. Effective utilization of the visibility map requires proper configuration and monitoring, which is especially crucial in systems with large data volumes and high transaction concurrency.