I updated postgres to 8.0.2, am running vacuumdb -faz every 3 hours, and 50 minutes after a vacuum the CPU usage still skyrocketed, and the disk started filling. This time, there is only a single file that is spanning multiple GB, but running oid2name again returns no result on the oid or filenode.
With the increased vacuuming, fixed temp tables, etc., I really am at a loss for what's happening, and could really use some additional help.
Thank you, Richard
---------------------------(end of broadcast)--------------------------- TIP 7: don't forget to increase your free space map settings
