Skip navigation

Speaker:

Polina Bungina

Polina Bungina

Senior Software Engineer, Zalando SE

Software and database engineer at Zalando. Greenplum contributor in the past, Patroni maintainer now (the smaller one :) ).


POSETTE 2024 Talk

Hazards of logical decoding in PostgreSQL

(Livestream 4)

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.

The Postgres team at Microsoft is proud to be the organizer of POSETTE: An Event for Postgres (formerly Citus Con).