If anybody has additional advice on this problem, I would really, really appreciate it...

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,

---------------------------(end of broadcast)--------------------------- TIP 7: don't forget to increase your free space map settings

Reply via email to