Re: Vacuum analyze vs just Vacuum - Mailing list pgsql-general

From Bruce Momjian
Subject Re: Vacuum analyze vs just Vacuum
Date
Msg-id 200005281758.NAA23826@candle.pha.pa.us
Whole thread Raw
In response to Vacuum analyze vs just Vacuum  ("Bryan White" <bryan@arcamax.com>)
List pgsql-general
> I would just like to check an assumption.  I "vacuum analyze" regularly.  I
> have always assumed that this did a plain vacuum in addition to gathering
> statistics.  Is this true?  The documentation never states explicitly one
> way or the other but it almost suggests that they are independant
> operations.


Yes, it does a vacuum too.



--
  Bruce Momjian                        |  http://www.op.net/~candle
  pgman@candle.pha.pa.us               |  (610) 853-3000
  +  If your life is a hard drive,     |  830 Blythe Avenue
  +  Christ can be your backup.        |  Drexel Hill, Pennsylvania 19026

pgsql-general by date:

Previous
From: Tom Lane
Date:
Subject: Re: Vacuum analyze vs just Vacuum
Next
From: Peter Eisentraut
Date:
Subject: Re: PostgreSQL7.0 bug? "make install" doesN'T run at all