Logical replication theory and concepts | POSETTE: An Event for Postgres 2025

From the creator

Video of a conference talk presenting a layman introduction to the concepts and theory behind logical replication in PostgreSQL. We will discuss following topics: • Physical WAL streaming as a way to replicate physical view of database • Logical change streaming as a way to replicate logical view of database • Role of reorder buffer, WAL sender on the origin database • Role of logical receiver and change application on the target database • Theory behind initial data synchronization • Reasons behind logical replication being a delicate feature to handle These simple concepts will help users make educated decisions about using logical replication in their applications and set correct expectations from the feature. Ashutosh Bapat is a Major Contributor to PostgreSQL and is part of the PostgreSQL community contributors' team in Microsoft. He has contributed features and bug fixes in the areas of partitioning, FDW, query optimization, and logical replication. He has spoken at PostgreSQL conferences across the globe. He has contributed features to Hive in the areas of replication and metastore. ► Video bookmarks: ⏩ 00:00 Introduction - Logical Replication ⏩ 01:18 Physical/Streaming Replication ⏩ 04:34 Logical Replication ⏩ 07:25 WAL Sender (Logical Change Sender) ⏩ 10:00 Logical Receiver ⏩ 11:03 Replication Slot ⏩ 21:10 When things Go Wrong (Error Loops) ⏩ 25:50 Conclusion - Use Cases, Limitations & Things to Watch for 📕 Everything you need to kn

Published 2025-06-12 · Watch on YouTube ↗
Availability and playback restrictions are controlled by the original channel.