aboutsummaryrefslogtreecommitdiff
diff options
context:
space:
mode:
authorTom Lane <tgl@sss.pgh.pa.us>2008-02-02 23:29:12 +0000
committerTom Lane <tgl@sss.pgh.pa.us>2008-02-02 23:29:12 +0000
commit19c40492f03803e9f9f8911cbc1b9b174d0ffd1c (patch)
treee9282b136f069c46c1e13d071871070df615fbf0
parent6f906905b1d3bc6896a929e1b407e1a9d48fcd42 (diff)
downloadpostgresql-19c40492f03803e9f9f8911cbc1b9b174d0ffd1c.tar.gz
postgresql-19c40492f03803e9f9f8911cbc1b9b174d0ffd1c.zip
Move example of turning off synchronous_commit to a more logical place,
to wit in the description of that variable rather than some other one.
-rw-r--r--doc/src/sgml/config.sgml9
1 files changed, 5 insertions, 4 deletions
diff --git a/doc/src/sgml/config.sgml b/doc/src/sgml/config.sgml
index 05996b49108..e910706a313 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.163 2008/01/30 18:35:55 tgl Exp $ -->
+<!-- $PostgreSQL: pgsql/doc/src/sgml/config.sgml,v 1.164 2008/02/02 23:29:12 tgl Exp $ -->
<chapter Id="runtime-config">
<title>Server Configuration</title>
@@ -1343,9 +1343,7 @@ 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. It can even be turned
- off in a single multi-statement transaction using <command>SET
- LOCAL synchronous_commit TO OFF;</>.
+ the attendant risks of data corruption.
</para>
<para>
@@ -1385,6 +1383,9 @@ SET ENABLE_SEQSCAN TO OFF;
one transaction is determined by the setting in effect when it
commits. It is therefore possible, and useful, to have some
transactions commit synchronously and others asynchronously.
+ For example, to make a single multi-statement transaction commit
+ asynchronously when the default is the opposite, issue <command>SET
+ LOCAL synchronous_commit TO OFF</> within the transaction.
</para>
</listitem>
</varlistentry>