Hi Vick,

> Can you run arbitrary queries via your Qt wrapper?  If so, then run a
> "SET SESSION" disable of the synchronous commit, not per-transaction.
> Then you get the benefit of it for that whole session without having
> to enable it globally.

Yes, I can. I wasn't aware it could be set on a session basis. I see that I can:

SET synchronous_commit = false;

from within my application. This seems far more sensible than forcing
asynchronous commit on Slony and other remote clients of my slave dbs,
of which there are several.

Thanks,
Peter Geoghegan
_______________________________________________
Slony1-general mailing list
[email protected]
http://lists.slony.info/mailman/listinfo/slony1-general

Reply via email to