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
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
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