On Fri, Jul 29, 2011 at 2:20 AM, Robert Haas <robertmhaas@gmail.com> wrote:
> Well, again, there are three levels:
>
> (A) synchronous_commit=off. No waiting!
> (B) synchronous_commit=local transactions, and synchronous_commit=on
> transactions when sync rep is not in use. Wait for xlog flush.
> (C) synchronous_commit=on transactions when sync rep IS in use. Wait
> for xlog flush and replication.
...
> So basically, you can't be more asynchronous than the guy in front of
> you.
(A) still gives a guarantee - transactions that begin after the commit
returns see
the commited transaction. A weaker variant would say that if the commit
returns, and the server doesn't crash in the meantime, the commit would at
some point become visible. Maybe even that transactions that begin after the
commit returns become visible after that commit.
--
Ants Aasma