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:[EMAIL PROTECTED]] Sent: Thursday, November 29, 2001 10:40 AM To: bangh Cc: Leong, Fushan; [EMAIL PROTECTED] 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. ---------------------------(end of broadcast)--------------------------- TIP 4: Don't 'kill -9' the postmaster