Hazards of logical decoding in PostgreSQL
Friday, October 24 at 09:25–10:15
Logical decoding was introduced in PostgreSQL 9.4 and is being constantly improved. It has enabled many new applications. The extensible mechanism of output plugins and in-core logical replication based on logical decoding make this feature truly exciting.
One popular use case of this feature is implementing the Change Data Capture (CDC) pattern. Although developers are usually eager to adopt this modern approach to leverage its apparent benefits, I strongly believe that using logical decoding in PostgreSQL requires at least a basic understanding of its implementation and should be treated with great care.
In this talk, I will share the problems we, as Zalando's DBaaS team, encountered while adopting and maintaining our internal CDC solution based on logical decoding. I will also highlight the nuances you should always keep in mind when using this technology.
