On Jul 8, 2008, at 3:24 PM, Bill Moran wrote:
If you don't handle this, that table will continue to grow in size on
the disk, taking up space unnecessarily and probably negatively
impacting performance.
s/probably/definitely/
Also, if it was #3 on Bill's list, one thing to do is look for index
bloat. Reindex followed by vacuum might help as well.
As for running VACUUM FULL, I find it sometimes faster to just do a
dump + reload. A FULL vacuum is really, really, really, extremely,
slow.
--
Sent via pgsql-performance mailing list (pgsql-performance@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-performance
