Where Does My INSERT Go? A Logical Replication Story | POSETTE: An Event for Postgres 2026

Microsoft Developer
AI summary

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.