diff options
author | Bruce Momjian <bruce@momjian.us> | 2007-11-05 17:35:38 +0000 |
---|---|---|
committer | Bruce Momjian <bruce@momjian.us> | 2007-11-05 17:35:38 +0000 |
commit | c00055ea809fbc805fffcd372f3a6f12f46f6790 (patch) | |
tree | aba16840aae16d3772733a6b7eda10d34ee1a645 | |
parent | 049f6b9baac3d0d1a164e058b216ff168b692e2f (diff) | |
download | postgresql-c00055ea809fbc805fffcd372f3a6f12f46f6790.tar.gz postgresql-c00055ea809fbc805fffcd372f3a6f12f46f6790.zip |
Document that syncronhous commit can be turned off in a single
multi-statement transaction.
-rw-r--r-- | doc/src/sgml/config.sgml | 6 |
1 files changed, 4 insertions, 2 deletions
diff --git a/doc/src/sgml/config.sgml b/doc/src/sgml/config.sgml index 0d11754905d..f070290f483 100644 --- a/doc/src/sgml/config.sgml +++ b/doc/src/sgml/config.sgml @@ -1,4 +1,4 @@ -<!-- $PostgreSQL: pgsql/doc/src/sgml/config.sgml,v 1.152 2007/11/01 17:06:30 momjian Exp $ --> +<!-- $PostgreSQL: pgsql/doc/src/sgml/config.sgml,v 1.153 2007/11/05 17:35:38 momjian Exp $ --> <chapter Id="runtime-config"> <title>Server Configuration</title> @@ -1318,7 +1318,9 @@ SET ENABLE_SEQSCAN TO OFF; 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. + 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> |