"Shridhar Polas" <shridharpolas@xxxxxxxxx> wrote: > In my test setup I found that the disk space consumed by Postgers > is not getting declined even after deleting records from tables, > if I do not perform VACUUM FULL and REINDEX. True, but if you expect the tables to grow again it's generally better to leave the space allocated to PostgreSQL than to make it give it back up to the OS for the moment and have to go ask for it again later. If you don't expect PostgreSQL to need the space again and you want to release it back to the OS, prior to release 9.0 it is usually better to use CLUSTER than to use VACUUM FULL and REINDEX. -Kevin -- Sent via pgsql-admin mailing list (pgsql-admin@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-admin
