Sign in to confirm you’re not a bot
This helps protect our community. Learn more

Hazards of logical decoding in PostgreSQL | POSETTE 2024

Microsoft Developer
588K subscribers
<__slot-el>
<__slot-el>
563 views 10 months ago #PostgreSQL #Database #PosetteConf
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  …...more
...more
Hazards of logical decoding in PostgreSQL | POSETTE 2024
24Likes
563Views
Jun 132024
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:   / hughcapet  

Follow along using the transcript.

Microsoft Developer

588K subscribers