Schedule - PGConf.DE 2025
Myths and Truths about Synchronous Replication in PostgreSQL
Date: 2025-05-09
Time: 11:10–11:55
Room: Ballsaal 1
Level: Intermediate
Ever wondered if synchronous replication in PostgreSQL is too slow or if it always prevents data loss? Let's uncover the truth.
Synchronous replication in PostgreSQL has been available for almost 15 years and provides a foundation for high availability with zero RPO. However, even experienced DBAs and application developers often don’t understand all the quirks and trade-offs of using it.
This session will explore myths and truths surrounding synchronous replication. Using real-world examples and tests, we'll separate facts from fiction and give clear explanations on how synchronous replication works and how to use it effectively.