| From: | "Claudio Lapidus" <clapidus(at)hotmail(dot)com> |
|---|---|
| To: | <pgsql-general(at)postgresql(dot)org> |
| Subject: | Re: postmaster(s) have high load average |
| Date: | 2003-08-09 20:45:59 |
| Message-ID: | BAY7-DAV44o4yjuOxjZ0001505a@hotmail.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general pgsql-hackers |
> 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.
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Phil Howard | 2003-08-09 22:07:32 | Continued mail server problems for all PGSQL mailing lists I'm on |
| Previous Message | Roger Ackroyd | 2003-08-09 20:44:03 | Re: [GENERAL] FATAL: The database system is in recovery mode |
| From | Date | Subject | |
|---|---|---|---|
| Next Message | ohp | 2003-08-09 22:25:07 | Re: 7.4beta1 build problem on unixware |
| Previous Message | Larry Rosenman | 2003-08-09 20:26:40 | Re: 7.4beta1 build problem on unixware |