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

Peripheral Links

Header And Logo

PostgreSQL
| The world's most advanced open source database.

Site Navigation

Search archives
  Advanced Search

Re: vacuumdb clarification


  • From: Bruce Momjian <bruce(at)momjian(dot)us>
  • To: Peter Eisentraut <peter_e(at)gmx(dot)net>
  • Cc: PostgreSQL-documentation <pgsql-docs(at)postgresql(dot)org>
  • Subject: Re: vacuumdb clarification
  • Date: Fri, 27 Nov 2009 12:41:37 -0500 (EST)
  • Message-id: <200911271741.nARHfb220108@momjian.us> <text/plain>

Peter Eisentraut wrote:
> 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.

I agree with your analysis.  I have applied a simpler wording
improvement that just adds the word "Also".

-- 
  Bruce Momjian  <bruce(at)momjian(dot)us>        http://momjian.us
  EnterpriseDB                             http://enterprisedb.com

  + If your life is a hard drive, Christ can be your backup. +
Index: doc/src/sgml/ref/vacuumdb.sgml
===================================================================
RCS file: /cvsroot/pgsql/doc/src/sgml/ref/vacuumdb.sgml,v
retrieving revision 1.44
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	27 Nov 2009 17:40:12 -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>
!         Also calculate statistics for use by the optimizer.
         </para>
        </listitem>
       </varlistentry>


Home | Main Index | Thread Index

Privacy Policy | About PostgreSQL
Copyright © 1996 – 2012 PostgreSQL Global Development Group