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!
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 |