Read consistency when using synchronous_commit=off

From: pshadangi <pshadangi(at)gmail(dot)com>
To: pgsql-general(at)postgresql(dot)org
Subject: Read consistency when using synchronous_commit=off
Date: 2019-01-15 10:58:53
Message-ID: CAA+OQsSRuQX8vaDV0=v5x9U0Vcj_1G71aTCQ7wx+YBE==uHvEQ@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

To improve commit performance we are planning to use
"synchronous_commit=off", with this if multiple clients are reading the
same data/row will they always get the latest updated data/row ? (clients
are using committed read and we are not using clustered environment, we
have just one instance of postgres serving local clients running on the
same machine).
For example if client1 updates a row then the updated value is available to
client2 immediately after the commit or there is a delay as commit is now
asynchronous ?

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Fabio Pardi 2019-01-15 11:15:45 Re: Read consistency when using synchronous_commit=off
Previous Message Pavel Stehule 2019-01-15 10:56:15 Re: Oracke BLOB to Postgres BYTEA using ora2pg