From 2ab9997ec2ad1def54f6e0fe846f1838581fe8d3 Mon Sep 17 00:00:00 2001 From: Bruce Momjian Date: Sat, 30 Jul 2005 15:45:49 +0000 Subject: [PATCH] Patch to mention cost-based delay in vacuum reference Alvaro Herrera --- doc/src/sgml/ref/vacuum.sgml | 12 +++++++++++- 1 file changed, 11 insertions(+), 1 deletion(-) diff --git a/doc/src/sgml/ref/vacuum.sgml b/doc/src/sgml/ref/vacuum.sgml index e020c9a9ac..1c90fe4ef1 100644 --- a/doc/src/sgml/ref/vacuum.sgml +++ b/doc/src/sgml/ref/vacuum.sgml @@ -1,5 +1,5 @@ @@ -174,6 +174,15 @@ VACUUM [ FULL | FREEZE ] [ VERBOSE ] ANALYZE [ ta to occupy less disk space. VACUUM FULL will usually shrink the table more than a plain VACUUM would. + + + During VACUUM 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 for more + details. + @@ -229,6 +238,7 @@ VACUUM + -- 2.40.0