Ashutosh Bapat
Principal SDE, community contributors team @ Microsoft
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, logical replication. He has spoken at PostgreSQL conferences across the globe. He has contributed features to Hive in the areas of replication and metastore.
POSETTE 2025 Talk
Logical replication theory and concepts
It's 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 decision about using logical replication in their applications and set correct expectations from the feature.
Join the conversation
Use the hashtag #PosetteConf