Postgres Pro
Downloads
Home   >   mailing lists

Does "vacuum analyze" contain "vacuum"? - Mailing list pgsql-general

From Holger Marzen
Subject Does "vacuum analyze" contain "vacuum"?
Date
Msg-id Pine.LNX.4.50.0309071402430.22535-100000@bluebell.marzen.de
Whole thread Raw
Responses Re: Does "vacuum analyze" contain "vacuum"?  (Manfred Koizar <mkoi-pg@aon.at>)
Re: Does "vacuum analyze" contain "vacuum"?  (Peter Eisentraut <peter_e@gmx.net>)
Re: Does "vacuum analyze" contain "vacuum"?  ("Matthew T. O'Connor" <matthew@zeut.net>)
List pgsql-general
Tree view 
Hi all,

the docs are not clear for me. If I want (in version 7.1.x, 7.2.x) to
help the analyzer AND free unused space do I have to do a

vacuum
vacuum analyze

or is a

vacuum analyze

enough? I am not sure if "vacuum analyze" contains a "vacuum".

Regards
Holger

--
PGP/GPG Key-ID:
http://blackhole.pca.dfn.de:11371/pks/lookup?op=get&search=0xB5A1AFE1

pgsql-general by date:

Previous
From: Adrian Phillips
Date:
Subject: Re: NFS performance tuning
Next
From: Manfred Koizar
Date:
Subject: Re: Does "vacuum analyze" contain "vacuum"?