Re: Side effect of synchronous_commit = off - Mailing list pgsql-general

From Guillaume Lelarge
Subject Re: Side effect of synchronous_commit = off
Date
Msg-id 4BAB199A.7060400@lelarge.info
Whole thread Raw
In response to Side effect of synchronous_commit = off  (Yan Cheng CHEOK <yccheok@yahoo.com>)
List pgsql-general
Le 25/03/2010 08:49, Yan Cheng CHEOK a écrit :
> I was wondering whether setting synchronous_commit = off will have the following side effect.
>
> (1) Process A issues UPDATE command on row x, from false to true.
> (2) After that, Process B READ from row x.
>
> Is it possible that when Process B start to read row x, the "true" value is not being "flushed" to the table. Hence,
processB will read the row x as false? 
>

No, it's not possible.


--
Guillaume.
 http://www.postgresqlfr.org
 http://dalibo.com

pgsql-general by date:

Previous
From: Adrian von Bidder
Date:
Subject: Re: Revoking CREATE TABLE
Next
From: dipti shah
Date:
Subject: Get the list of permissions/privileges on schema