Do you want to know what VACUUM has done?

PGConf.Russia 2022

June 20 – 21 |
Radisson Slavyanskaya Business Center, Square of Europe 2, Moscow

What is PGConf.Russia 2022?

About

PGConf.Russia is a leading Russian PostgreSQL international conference, annually taking together more than 700 PostgreSQL professionals from Russia and other countries — core and software developers, DBAs and IT-managers. The 2-day program includes training workshops presented by leading PostgreSQL experts, more than 40 talks, panel discussions and a lightning talk session.

i

When and Where

June 20 – 21, 2022 (10:00-19:00)
Radisson Slavyanskaya Business Center, Square of Europe 2, Moscow

Attendees

PostgreSQL DBAs
PostgreSQL core and extension developers
Application developers
System architects
IT-managers
Database migration engineers and managers.

Main topics

PostgreSQL technology frontiers for highest workloads, huge databases, mission-critical applications
PostgreSQL scalability for transactional and analytical workloads
New features in PostgreSQL and around: PostgreSQL and its ecosystem development
PostgreSQL for business software applications: system architecture, migration issues and operating experience
PostgreSQL specific features and their applications: JSON(b), (geo)Spatial data, Full text search

>500
participants

hybrid format

1000
minutes of networking

Selected talks

Alexander Kukushkin

Zalando SE

Database Engineer

Talk

Implementing failover of logical replication slots in Patroni

Logical decoding and replication slots introduced in PostgreSQL 9.4 (released in 2014) created a solid foundation for implementing built-in core logical replication in version 10 (released in 2017). Unfortunately, there are a few limitations that make logical replication not very useful in real-world scenarios. Logical decoding currently isn’t supported on the standby server, and PostgreSQL allows creating logical replication slots only on the primary server. Or in other words, logical slots are lost on failover/switchover.

Postgres hackers made many attempts to address the problem, and most of them resulted in not too much success. Although, there is one little function introduced in PostgreSQL 11 that made it possible to implement failover of logical replication slots externally.

In my talk I will tell a story of how Patroni solves the problem of logical replication slots failover without using invasive third-party extensions, dig down into some of the Postgres internals in order to prove why this approach is safe, and finally, we will discuss limitations and potential downsides of this solution.

Pavel Luzanov

Postgres Professional

Head of Educational Programs

Talk

PostgreSQL 15: on the finish line

The release cycle for version 15 is nearing completion. At the time of the presentation, the complete list of changes will not be known. But for sure there will be something to talk about.

Program All talks