Synchronous Replication: Where is data visible first?

From: P C <puravc(at)gmail(dot)com>
To: pgsql-admin(at)lists(dot)postgresql(dot)org
Subject: Synchronous Replication: Where is data visible first?
Date: 2024-01-11 06:00:17
Message-ID: CADrzpjH8A_bOVU4vTwtDanrCuE5wt63NRcJ5QGQZZeLmaBuOgQ@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

Hello,

While discussing with the development team, an interesting question came
up: in a synchronous streaming replication scenario, with
synchronous_commit = remote_apply, will the change be first visible on
Standby (replica)? Primary will wait till the change is applied and
committed on standby, and hence logically this looks to be correct. But I
couldn't find this mentioned explicitly anywhere and hence seeking comments
from the community.

Assuming that the answer is yes, potentially the same can happen even with
synchronous_commit = remote_write | ON because on the way back to Primary,
if the network is slow, there is a chance that Standby may complete
applying the change and make it visible to the users.

Would sincerely appreciate if someone can share a documentation/blog link
that explains this, if there is one.

Many Thanks!

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message David G. Johnston 2024-01-11 06:43:50 Re: Synchronous Replication: Where is data visible first?
Previous Message Herman Anker 2024-01-10 20:08:27 Upgrade postgres 11 to 15 and postgis 2.5 to 3.3