Where Does My INSERT Go? A Logical Replication Story | POSETTE: An Event for Postgres 2026
Postgresql Logical replication Wal Write Ahead logging Database replication Cdc Change data capture Postgres internals Replication slots Reorderbuffer Postgresql replication
This technical talk traces the full lifecycle of a PostgreSQL INSERT through the logical replication pipeline, covering WAL generation, logical decoding internals, ReorderBuffer processing, replication slot guarantees, and output plugin conversion. It is designed for developers, DBAs, and engineers building CDC pipelines or working with PostgreSQL replication who want a deep understanding of how PostgreSQL reliably moves data between databases.