Amitabh Kant wrote:
You need to do VACUUM FULL ANALYZE to claim the disk space, but this creates a exclusive lock on the tables.See http://www.postgresql.org/docs/8.3/static/sql-vacuum.html
Aha!OK but why did the performance degrade so much? The same reason -- lack of autovacuuming/vacuum full?
Regards, mk -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
