Florian Weimer wrote: > The documentation doesn't really tell how to disable synchronous > commits for a single commit. I believe the correct command is > > SET LOCAL synchronous_commit TO OFF; > > just before the COMMIT statement.
Nice. I made the following documentation change, attached. -- Bruce Momjian <[EMAIL PROTECTED]> http://momjian.us EnterpriseDB http://postgres.enterprisedb.com + If your life is a hard drive, Christ can be your backup. +
Index: doc/src/sgml/config.sgml =================================================================== RCS file: /cvsroot/pgsql/doc/src/sgml/config.sgml,v retrieving revision 1.152 diff -c -c -r1.152 config.sgml *** doc/src/sgml/config.sgml 1 Nov 2007 17:06:30 -0000 1.152 --- doc/src/sgml/config.sgml 5 Nov 2007 17:34:36 -0000 *************** *** 1318,1324 **** In many situations, turning off <xref linkend="guc-synchronous-commit"> for noncritical transactions can provide much of the potential performance benefit of turning off <varname>fsync</varname>, without ! the attendant risks of data corruption. </para> <para> --- 1318,1326 ---- In many situations, turning off <xref linkend="guc-synchronous-commit"> for noncritical transactions can provide much of the potential performance benefit of turning off <varname>fsync</varname>, without ! the attendant risks of data corruption. It can even be turned ! off in a single multi-statement transaction using <command>SET ! LOCAL synchronous_commit TO OFF;</>. </para> <para>
---------------------------(end of broadcast)--------------------------- TIP 2: Don't 'kill -9' the postmaster