Re: synchronous_commit and mvcc

On Wed, Aug 12, 2009 at 8:28 PM, Kelly Burkhart<kelly.burkhart@gmail.com> wrote:
> Hello,
>
> We have synchronous_commit=off in our postgresql.conf file.  Does this
> setting affect mvcc?

If you don't have a crash then there is absolutely no difference from
the clients' point of view (besides speed).

If you have a crash you could lose the last 200ms of commits but if
that happens you'll lose them in a "consistent" way. You can't find
the results of one transaction committed afterwards but not some other
transaction which came earlier.

--
greg
http://mit.edu/~gsstark/resume.pdf