Skip site navigation (1) Skip section navigation (2)

Re: vacuumdb clarification

From: Peter Eisentraut <peter_e(at)gmx(dot)net>
To: Bruce Momjian <bruce(at)momjian(dot)us>
Cc: PostgreSQL-documentation <pgsql-docs(at)postgresql(dot)org>
Subject: Re: vacuumdb clarification
Date: 2009-11-20 13:58:09
Message-ID: 1258725489.28720.12.camel@fsopti579.F-Secure.com (view raw or flat)
Thread:
Lists: pgsql-docs
On fre, 2009-11-13 at 14:49 -0500, Bruce Momjian wrote:
> Here is a documentation patch I have applied to clarify that --analyze
> does analyze during vacuum, not instead of vacuum.

I don't see this committed, but I would vote against it, because the
wording makes it sound like the statistics are for use by the optimizer
during vacuum.

diff -c -c -r1.44 vacuumdb.sgml
*** doc/src/sgml/ref/vacuumdb.sgml      26 Feb 2009 16:02:37 -0000
1.44
--- doc/src/sgml/ref/vacuumdb.sgml      13 Nov 2009 19:46:37 -0000
***************
*** 159,165 ****
        <term><option>--analyze</option></term>
        <listitem>
         <para>
!         Calculate statistics for use by the optimizer.
         </para>
        </listitem>
       </varlistentry>
--- 159,165 ----
        <term><option>--analyze</option></term>
        <listitem>
         <para>
!         Calculate statistics for use by the optimizer during vacuum.
         </para>
        </listitem>
       </varlistentry>



In response to

Responses

pgsql-docs by date

Next:From: Tom LaneDate: 2009-11-21 22:05:08
Subject: Possible to display Unicode symbols in our SGML docs?
Previous:From: shohorab hossainDate: 2009-11-18 08:41:09
Subject: Re: Postgresql Database Lock Problem

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group