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

Re: [INTERFACES] table very big !!!!!

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Peter Mount <peter(at)retep(dot)org(dot)uk>
Cc: Pablo Saul Salazar - CESERCOMP <ssalazar(at)goliat(dot)espol(dot)edu(dot)ec>, pgsql-interfaces(at)postgreSQL(dot)org
Subject: Re: [INTERFACES] table very big !!!!!
Date: 1999-11-23 00:06:49
Message-ID: 25736.943315609@sss.pgh.pa.us (view raw or flat)
Thread:
Lists: pgsql-interfaces
Peter Mount <peter(at)retep(dot)org(dot)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".

It sounds like Pablo has a problem with vacuum not doing what it is
supposed to ... has anyone else ever seen that?  It's a new one on me.

			regards, tom lane

Responses

pgsql-interfaces by date

Next:From: Byron NikolaidisDate: 1999-11-23 00:22:10
Subject: Re: [INTERFACES] weird Access problem
Previous:From: Juan ColmenaresDate: 1999-11-22 23:20:40
Subject: A Question about Large Object

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group