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:
At this point, is it possible that c2 is not able to see the rows from connection 1 that were inserted and committed prior to the c2 transaction starting?