aboutsummaryrefslogtreecommitdiff
diff options
context:
space:
mode:
authorBruce Momjian <bruce@momjian.us>2005-07-30 15:45:49 +0000
committerBruce Momjian <bruce@momjian.us>2005-07-30 15:45:49 +0000
commit2ab9997ec2ad1def54f6e0fe846f1838581fe8d3 (patch)
treecfe86d1e0892459c23d7e4cf7f49eb1634106413
parent1f54d43075d8c457935cd9fe8adfea949104995d (diff)
downloadpostgresql-2ab9997ec2ad1def54f6e0fe846f1838581fe8d3.tar.gz
postgresql-2ab9997ec2ad1def54f6e0fe846f1838581fe8d3.zip
Patch to mention cost-based delay in vacuum reference
Alvaro Herrera
-rw-r--r--doc/src/sgml/ref/vacuum.sgml12
1 files changed, 11 insertions, 1 deletions
diff --git a/doc/src/sgml/ref/vacuum.sgml b/doc/src/sgml/ref/vacuum.sgml
index e020c9a9acd..1c90fe4ef1b 100644
--- a/doc/src/sgml/ref/vacuum.sgml
+++ b/doc/src/sgml/ref/vacuum.sgml
@@ -1,5 +1,5 @@
<!--
-$PostgreSQL: pgsql/doc/src/sgml/ref/vacuum.sgml,v 1.36 2004/12/02 19:28:48 tgl Exp $
+$PostgreSQL: pgsql/doc/src/sgml/ref/vacuum.sgml,v 1.37 2005/07/30 15:45:49 momjian Exp $
PostgreSQL documentation
-->
@@ -174,6 +174,15 @@ VACUUM [ FULL | FREEZE ] [ VERBOSE ] ANALYZE [ <replaceable class="PARAMETER">ta
to occupy less disk space. <command>VACUUM FULL</command> will usually
shrink the table more than a plain <command>VACUUM</command> would.
</para>
+
+ <para>
+ During <command>VACUUM</command> execution, there can be a substantial
+ increase in I/O traffic, which cause poor performance for other active
+ sessions. Therefore, it is sometimes advisable to use
+ the cost-based vacuum delay feature. See <xref
+ linkend="runtime" endterm="runtime-config-resource-vacuum-cost"> for more
+ details.
+ </para>
</refsect1>
<refsect1>
@@ -229,6 +238,7 @@ VACUUM
<simplelist type="inline">
<member><xref linkend="app-vacuumdb" endterm="app-vacuumdb-title"></member>
+ <member><xref linkend="runtime" endterm="runtime-config-resource-vacuum-cost"></member>
</simplelist>
</refsect1>
</refentry>