aboutsummaryrefslogtreecommitdiff
diff options
context:
space:
mode:
authorBruce Momjian <bruce@momjian.us>2007-11-05 17:35:38 +0000
committerBruce Momjian <bruce@momjian.us>2007-11-05 17:35:38 +0000
commitc00055ea809fbc805fffcd372f3a6f12f46f6790 (patch)
treeaba16840aae16d3772733a6b7eda10d34ee1a645
parent049f6b9baac3d0d1a164e058b216ff168b692e2f (diff)
downloadpostgresql-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.sgml6
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>