Re: [GENERAL] synchronous_commit and mvcc

2009-08-12 Thread Andy Colson
Kelly Burkhart wrote: Hello, We have synchronous_commit=off in our postgresql.conf file. Does this setting affect mvcc? For instance if I have two connections from processes on different machines that do the following: c1 begins transaction c1 inserts rows into table c1 commits transaction

Re: [GENERAL] synchronous_commit and mvcc

2009-08-12 Thread Greg Stark
On Wed, Aug 12, 2009 at 8:28 PM, Kelly Burkhart 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 y

[GENERAL] synchronous_commit and mvcc

2009-08-12 Thread Kelly Burkhart
Hello, We have synchronous_commit=off in our postgresql.conf file. Does this setting affect mvcc? For instance if I have two connections from processes on different machines that do the following: c1 begins transaction c1 inserts rows into table c1 commits transaction c2 begins transaction c2 q