Re: [HACKERS] Asynchronous commit documentation gap
От | Bruce Momjian |
---|---|
Тема | Re: [HACKERS] Asynchronous commit documentation gap |
Дата | |
Msg-id | 200711051735.lA5HZoo12517@momjian.us обсуждение исходный текст |
Список | pgsql-docs |
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 <bruce@momjian.us> 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>
В списке pgsql-docs по дате отправления: