> 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 ?