> I wonder if you've got a bloated pg catalog then. Certainly sounds
> like it's a possibility. > So other than vacuuming when you recreate this, is the server working > hard? What is vacuum vacuuming when this happens (pg_stat_activity > should show that) Does vacuum full is required to avoid bloating, i am running vacuum analyze regularly but not vacuum full. Could it be cause of bloating ? |