CODEWITHSUNDEEP
postgresqldatabase-replicationlatencydata-synchronization
boardrider
boardrider

Reputation: 6185

Can PostgreSQL Synchronous Replication between two datacetres — with 65 ms latency — work?

If I set up PostgreSQL Synchronous Replication between two datacetres (DC1 and DC5), with etcd cluster across three datacentes (DC1, DC3, and DC5) to avoid split-brain issues,
and the latency between DC1 and DC5 is 65 ms (so, 130 ms for both direction), will the PostgreSQL be able to sustain this latency?

Upvotes: 1

Views: 180

Answers (1)

Laurenz Albe
Laurenz Albe

Reputation: 247625

PostgreSQL has no problem with the network latency, but you will have a problem if you want to execute more than a few data modifications. A busy OLTP application like a web shop will be out of the question.

Upvotes: 1

Related Questions