Thanks for everyone input. So let me reply in here to make sure I
understand it
1) If I run "vaccum all" or "vaccum tablename", it will just delete the
expired rows from the file but not free the physical disk space. However,
it will not free the index
2) Vaccumdb will delete the expired rows fromt the file and free the
physical disk space. However, it will not free the index
3) For index, you need to run reindex command to stop the grow
Other than table and index, any object that I should clean up once a while?
Fushan
-----Original Message-----
From: Stephan Szabo [mailto:sszabo@megazone23.bigpanda.com]
Sent: Thursday, November 29, 2001 10:40 AM
To: bangh
Cc: Leong, Fushan; pgsql-admin@postgresql.org
Subject: Re: [ADMIN] Vaccum
On Thu, 29 Nov 2001, bangh wrote:
> HI,
>
> This is not necessary true, but you might feel understandable.
>
> To delete records, just seems as the records are marked as voided. Space
is not
> collected. To run vaccum might do this kind space garbage collection.
>
> To run vacummdb really save the space, but it works at only some extent.
e.g.
> index still goes quickly, it goes bigger and bigger, one day it eats all
your
> space you have, behaves as gets a virus. In this case, my solution is to
use
> pg_dump the original one, create new one and restory, this reaaly save
your
> space, but you cannot do this as frequently as you do "vacuum". It costs
much
> more CPU time to do it if your database is huge.
I think REINDEX or just DROP INDEX/CREATE INDEX should do the same thing
without requiring the dump/restore.