Re: Read consistency when using synchronous_commit=off - Mailing list pgsql-general

From Ravi Krishna
Subject Re: Read consistency when using synchronous_commit=off
Date
Msg-id 1547553278.1840928.1635056376.7E488891@webmail.messagingengine.com
Whole thread Raw
In response to Re: Read consistency when using synchronous_commit=off  (Fabio Pardi <f.pardi@portavita.eu>)
Responses Re: Read consistency when using synchronous_commit=off  (pshadangi <pshadangi@gmail.com>)
List pgsql-general

> I m not sure other clients are able to read from WAL buffer, therefore i m not sure the data is
> available to other clients at that specific point in time.

No.  On the standby the buffer cache has to be populated with the updates before other client sessions can read it.  AFAIK other client sessions do not read WAL buffers.

That is why synchronous_commit=ON option is there.


pgsql-general by date:

Previous
From: Ian Barwick
Date:
Subject: Re: repmgr and SSH
Next
From: "Daniel Verite"
Date:
Subject: RE: Oracke BLOB to Postgres BYTEA using ora2pg