Re: Is VACUUM ANALYZE a superset of VACUUM? - Mailing list pgsql-general

From Dustin Sallings
Subject Re: Is VACUUM ANALYZE a superset of VACUUM?
Date
Msg-id Pine.SGI.3.95.1001013161404.21383C-100000@bleu.west.spy.net
Whole thread Raw
In response to Is VACUUM ANALYZE a superset of VACUUM?  (Forest Wilkinson <fspam@home.com>)
Responses Re: Is VACUUM ANALYZE a superset of VACUUM?
List pgsql-general
On Fri, 13 Oct 2000, Forest Wilkinson wrote:

# Does running "VACUUM ANALYZE" incorporate the effects of a plain old
# "VACUUM"?  Or, must I run both "VACUUM" and "VACUUM ANALYZE" to have old
# rows removed *and* statistics gathered?  The docs aren't clear about
# this.

    I'm quite sure ``vacuum analyze'' does both.  Is there a reason
there's no ``analyze?''  I guess it doesn't make too much of a difference
without time travel.

--
SA, beyond.com           My girlfriend asked me which one I like better.
pub  1024/3CAE01D5 1994/11/03 Dustin Sallings <dustin@spy.net>
|    Key fingerprint =  87 02 57 08 02 D0 DA D6  C8 0F 3E 65 51 98 D8 BE
L_______________________ I hope the answer won't upset her. ____________


pgsql-general by date:

Previous
From: Forest Wilkinson
Date:
Subject: Is VACUUM ANALYZE a superset of VACUUM?
Next
From: Tom Lane
Date:
Subject: Re: How does TOAST compare to other databases' mechanisms?