05:35Myths and Truths about Synchronous Replication in PostgreSQL | POSETTE: An Event for Postgres 2025
From the creator
Video of a conference talk discussing synchronous replication in PostgreSQL. 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. Alexander Kukushkin is better known in the PostgreSQL community as "the Patroni guy". Patroni is an open source tool for implementing PostgreSQL clustering and high availability. Besides Patroni, Alexander occasionally contributes to PostgreSQL and other open-source projects and tools, usually Postgres related. Alexander is a principal software engineer at Microsoft. ► Video bookmarks: ⏩ 00:00 Introduction ⏩ 00:37 Understanding Write-Ahead Log (WAL) and Replication Types ⏩ 05:35 Synchronous replication types ⏩ 07:41 Myth #1: Transaction Commit Order in Synchronous Replication ⏩ 10:35 Myth #2: Zero Data Loss Guarantees and RPO Claim ⏩ 16:18 Myth #3: Reading from synchronous standby nodes vs prim ⏩ 19:34 Myth #4: pg_rewind Requirements Even with Synchr
Published 2025-06-12 · Watch on YouTube ↗
Availability and playback restrictions are controlled by the original channel.





