Re: [INTERFACES] table very big !!!!! - Mailing list pgsql-interfaces

On Mon, 22 Nov 1999, Tom Lane wrote:

> Peter Mount <peter@retep.org.uk> writes:
> > Ah, try running first vacuum; then vacuum analyze. The first one will
> > truncate the table removing the wasted space. The second simply rebuilds
> > some statistics about the table.
> 
> This is not right --- AFAICT, vacuum *always* runs the compaction phase.
> You can allow or skip the stats-gathering phase by specifying "analyze"
> or not, but "vacuum analyze" implies "vacuum".

Thanks for the correction. I've always run both myself, hence the answer.

Peter

--      Peter T Mount peter@retep.org.uk     Main Homepage: http://www.retep.org.uk
PostgreSQL JDBC Faq: http://www.retep.org.uk/postgresJava PDF Generator: http://www.retep.org.uk/pdf