No video of the event yet, sorry!

Logical replication is one of the most intricate yet fascinating parts of PostgreSQL. In this session, we’ll take a closer look at how a single tuple travels through the logical replication pipeline, from the moment it’s changed on the publisher to when it’s finally applied on the subscriber.

We’ll begin with how changes are captured in the WAL, then see how the walsender and reorder buffer extract those records and pass them through logical decoding using the pgoutput plugin. From there, we’ll explore how the replication slot ensures data retention and continuity, how messages are streamed to the subscriber, and how the apply worker and table sync worker reconstruct and apply these changes to maintain transactional consistency.

By the end of the session, you’ll have a clear, end-to-end understanding of how PostgreSQL logically replicates data and what happens behind the scenes when a tuple is replicated.