aboutsummaryrefslogtreecommitdiff
diff options
context:
space:
mode:
authorTom Lane <tgl@sss.pgh.pa.us>2001-05-04 23:11:37 +0000
committerTom Lane <tgl@sss.pgh.pa.us>2001-05-04 23:11:37 +0000
commite669b8d751c8cf00386c78bb548e505648d00994 (patch)
tree7b031de5252ecaf7b5222bd66b00dee7a889b539
parent8d2fe903b07483ade00dfddd62efb65fc6eccba8 (diff)
downloadpostgresql-e669b8d751c8cf00386c78bb548e505648d00994.tar.gz
postgresql-e669b8d751c8cf00386c78bb548e505648d00994.zip
COMMIT_DELAY and COMMIT_SIBLINGS were missing from the list of WAL
configuration parameters in chapter 3.
-rw-r--r--doc/src/sgml/runtime.sgml31
1 files changed, 30 insertions, 1 deletions
diff --git a/doc/src/sgml/runtime.sgml b/doc/src/sgml/runtime.sgml
index f51585692a5..f046f1f820d 100644
--- a/doc/src/sgml/runtime.sgml
+++ b/doc/src/sgml/runtime.sgml
@@ -1,5 +1,5 @@
<!--
-$Header: /cvsroot/pgsql/doc/src/sgml/runtime.sgml,v 1.62 2001/05/04 02:54:33 momjian Exp $
+$Header: /cvsroot/pgsql/doc/src/sgml/runtime.sgml,v 1.63 2001/05/04 23:11:37 tgl Exp $
-->
<Chapter Id="runtime">
@@ -1230,6 +1230,35 @@ env PGOPTIONS='-c geqo=off' psql
</varlistentry>
<varlistentry>
+ <term>COMMIT_DELAY (<type>integer</type>)</term>
+ <listitem>
+ <para>
+ Time delay between writing a commit record to the WAL buffer and
+ flushing the buffer out to disk, in microseconds. A nonzero delay
+ allows multiple transactions to be committed with only one fsync,
+ if system load is high enough that additional transactions become
+ ready to commit within the given interval. But the delay is just
+ wasted time if no other transactions become ready to commit.
+ Therefore, the delay is only performed if at least COMMIT_SIBLINGS
+ other transactions are active at the instant that a backend has
+ written its commit record.
+ </para>
+ </listitem>
+ </varlistentry>
+
+ <varlistentry>
+ <term>COMMIT_SIBLINGS (<type>integer</type>)</term>
+ <listitem>
+ <para>
+ Minimum number of concurrent open transactions to require before
+ performing the COMMIT_DELAY delay. A larger value makes it more
+ probable that at least one other transaction will become ready to
+ commit during the delay interval.
+ </para>
+ </listitem>
+ </varlistentry>
+
+ <varlistentry>
<term>WAL_BUFFERS (<type>integer</type>)</term>
<listitem>
<para>