Re: postmaster(s) have high load average

On Sat, Aug 09, 2003 at 05:45:59PM -0300, Claudio Lapidus wrote:
> > Run VACUUM VERBOSE on it; you'll no doubt see that some internal
> > tables such as pg_activity, pg_statistic, and such have a lot of dead
> > tuples. Establishing a connection leads to _some_ DB activity, and
> > probably a dead tuple or two; every time you ANALYZE, you create a
> > bunch of dead tuples since old statistics are "killed off."
>
> What? Does this mean that it is needed to routinely vacuum system tables
> too? If so, which is the recommended procedure?

On our system we do a vacuum analyze every night to cleanup what happened
during the day. Vacuum without a table name does all tables so you don't
explicitly need to list them.

--
Martijn van Oosterhout <kleptog(at)svana(dot)org> http://svana.org/kleptog/
> "All that is needed for the forces of evil to triumph is for enough good
> men to do nothing." - Edmond Burke
> "The penalty good people pay for not being interested in politics is to be
> governed by people worse than themselves." - Plato