Re: Read consistency when using synchronous_commit=off

From: Ravi Krishna <srkrishna(at)fastmail(dot)com>
To: pgsql-general(at)lists(dot)postgresql(dot)org
Subject: Re: Read consistency when using synchronous_commit=off
Date: 2019-01-15 11:54:38
Message-ID: 1547553278.1840928.1635056376.7E488891@webmail.messagingengine.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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.

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Daniel Verite 2019-01-15 11:56:05 RE: Oracke BLOB to Postgres BYTEA using ora2pg
Previous Message Ian Barwick 2019-01-15 11:53:04 Re: repmgr and SSH