Re: Patch to mention cost-based delay in vacuum reference - Mailing list pgsql-patches

From Bruce Momjian
Subject Re: Patch to mention cost-based delay in vacuum reference
Date
Msg-id 200507301546.j6UFkbl20315@candle.pha.pa.us
Whole thread Raw
In response to Patch to mention cost-based delay in vacuum reference  (Alvaro Herrera <alvherre@alvh.no-ip.org>)
Responses Re: P.tch to mention cost-based delay in vacuum reference  (Alvaro Herrera <alvherre@alvh.no-ip.org>)
List pgsql-patches
Updated patch applied.  Thanks.

---------------------------------------------------------------------------

Alvaro Herrera wrote:
> Hackers,
>
> Subject says it all.  Please review the grammar ...
>
> --
> Alvaro Herrera (<alvherre[a]alvh.no-ip.org>)
> "Et put se mouve" (Galileo Galilei)

--
  Bruce Momjian                        |  http://candle.pha.pa.us
  pgman@candle.pha.pa.us               |  (610) 359-1001
  +  If your life is a hard drive,     |  13 Roberts Road
  +  Christ can be your backup.        |  Newtown Square, Pennsylvania 19073
Index: ref/vacuum.sgml
===================================================================
RCS file: /home/alvherre/cvs/pgsql/doc/src/sgml/ref/vacuum.sgml,v
retrieving revision 1.36
diff -c -r1.36 vacuum.sgml
*** ref/vacuum.sgml    2 Dec 2004 19:28:48 -0000    1.36
--- ref/vacuum.sgml    29 Jul 2005 17:03:36 -0000
***************
*** 174,179 ****
--- 174,188 ----
      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,234 ****
--- 238,244 ----

    <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>

pgsql-patches by date:

Previous
From: Bruce Momjian
Date:
Subject: Re: Updated instrumentation patch
Next
From: "Magnus Hagander"
Date:
Subject: Re: Updated instrumentation patch