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

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 know about POSETTE: An Event for Postgres 2025 can be found at: https://posetteconf.com

✅ Learn more:
Watch more POSETTE talks: https://aka.ms/posette-playlist

📌 Let’s connect:  
LinkedIn - https://www.linkedin.com/company/posetteconf/
X – @PosetteConf, https://twitter.com/PosetteConf
Mastodon – @posetteconf, https://mastodon.social/@posetteconf
Bluesky – @posetteconf.com, https://bsky.app/profile/posetteconf.com

_________________________________
#PosetteConf #PostgreSQL #replication

Видео Logical replication theory and concepts | POSETTE: An Event for Postgres 2025 канала Microsoft Developer