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.
