Re: Vacuum problem - Mailing list pgsql-general

From S H
Subject Re: Vacuum problem
Date
Msg-id BAY155-W5F9C278A7C93C1D8EAD0FFDA10@phx.gbl
Whole thread Raw
In response to Re: Vacuum problem  (Scott Marlowe <scott.marlowe@gmail.com>)
Responses Re: Vacuum problem
List pgsql-general
> 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 ?

pgsql-general by date:

Previous
From: sumita
Date:
Subject: Re: FATAL: database "a/system_data" does not exist
Next
From: Ioana Danes
Date:
Subject: Running out of memory on vacuum