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