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 5: Have you checked our extensive FAQ? http://www.postgresql.org/users-lounge/docs/faq.html
