Hazards of logical decoding in PostgreSQL | POSETTE 2024

Video of a conference talk about the hazards of logical decoding in PostgreSQL presented by Polina Bungina at POSETTE: An Event for Postgres 2024. Logical decoding was introduced in PostgreSQL 9.4 and has been greatly improved since then. One of the popular use cases of this feature is implementation of the Change Data Capture (CDC) pattern. Although developers are usually eager to adopt this modern approach to make use of all the apparent benefits it brings, my strong belief is that usage of logical decoding in PostgreSQL requires at least a basic understanding of the implementation and should definitely be treated with great care. In this talk I will share the problems we, as Zalando's DBaaS team, dealt with while adopting and maintaining our internal CDC solution based on logical decoding and point you out to the nuances you should always keep in mind when using this technology.

Polina is a software and database engineer at Zalando. She ias a greenplum contributor in the past, Patroni maintainer now (the smaller one :) ).

Chapters:

00:00 - Intro

02:01 - Logical decoding

02:59 - Decoding process

09:44 - Logical decoding slot

17:46 - Replication protocol

21:00 - Conclusion

📕 Everything you need to know about POSETTE: An Event for Postgres 2024 can be found at: https://aka.ms/posette

✅ Learn more:

Watch more POSETTE talks: https://aka.ms/posette-playlist-2024

📌 Let’s connect:

X – @PosetteConf https://x.com/PosetteConf

Mastodon - @posetteconf https://mastodon.social/@posetteconf

Threads – @posetteconf https://www.threads.net/@posetteconf

🔔 Subscribe to the POSETTE News: https://aka.ms/posette-subscribe

#PosetteConf #PostgreSQL #Database

Presenters:

Polina Bungina, Senior Software Engineer, Zalando SE

Connect:

Polina Bungina: https://www.linkedin.com/in/hughcapet