Postgres FM Replication
Dec 16, 2022
The hosts discuss the various options for replication in PostgreSQL, including physical and logical replication. They explore offloading reads, implementing sticky reads, and using replicas for read-only parts of applications. They mention risks and downsides of using Postgres for replication, limitations and future improvements of logical replication, and differences between physical and logical replication in Postgres.
Chapters
Transcript
Episode notes
1 2 3 4 5 6
Introduction
00:00 • 2min
Options for Offloading Reads in Data Centers and Clouds
01:46 • 13min
Understanding RPO RTO, Choosing Between Wall-shipping and Streaming Replication, Implementing Sticky Reads, and Using Replicas for Read-only Parts of Applications
14:46 • 3min
Risks and Options for Replication with Postgres
17:51 • 4min
Limitations and Future Improvements of Logical Replication
21:51 • 13min
Differences Between Physical and Logical Replication in Postgres
34:30 • 3min