Re: postmaster(s) have high load average - Mailing list pgsql-general

From Claudio Lapidus
Subject Re: postmaster(s) have high load average
Date
Msg-id BAY7-DAV44o4yjuOxjZ0001505a@hotmail.com
Whole thread Raw
In response to postmaster(s) have high load average  (Chris Webster <cjw@ucar.edu>)
Responses Re: postmaster(s) have high load average  (Martijn van Oosterhout <kleptog@svana.org>)
List pgsql-general
> 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?

thx
cl.

pgsql-general by date:

Previous
From: Christopher Browne
Date:
Subject: Re: postmaster(s) have high load average
Next
From: Phil Howard
Date:
Subject: Continued mail server problems for all PGSQL mailing lists I'm on