From: | Christopher Browne <cbbrowne(at)acm(dot)org> |
---|---|
To: | pgsql-general(at)postgresql(dot)org |
Subject: | Re: postmaster(s) have high load average |
Date: | 2003-08-10 01:25:23 |
Message-ID: | m3k79m718c.fsf@chvatal.cbbrowne.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general pgsql-hackers |
In an attempt to throw the authorities off his trail, clapidus(at)hotmail(dot)com ("Claudio Lapidus") transmitted:
>> 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 some 7.2 systems I work with, a smattering of system tables are
vacuumed hourly along with applications that are known to be good
"fodder" for the purpose.
In 7.3 and 7.4, the "contrib" application, pg_autovacuum can do the
trick, vacuuming anything that reaches thresholds of
inserts/deletes/updates, and do so more or less as often as necessary.
If you haven't got a cron job looking something like:
0 0 * * * * vacuumdb -a -z > /dev/null 2> /dev/null
then you should probably add that, at least.
--
wm(X,Y):-write(X),write('@'),write(Y). wm('aa454','freenet.carleton.ca').
http://cbbrowne.com/info/multiplexor.html
"A hack is a terrible thing to waste, please give to the
implementation of your choice..." -- GJC
From | Date | Subject | |
---|---|---|---|
Next Message | Joshua D. Drake | 2003-08-10 02:28:28 | Re: Continued mail server problems for all PGSQL mailing |
Previous Message | Martijn van Oosterhout | 2003-08-10 01:08:42 | Re: Continued mail server problems for all PGSQL mailing |
From | Date | Subject | |
---|---|---|---|
Next Message | Robert Creager | 2003-08-10 01:37:30 | Re: 7.4Beta1 hang? |
Previous Message | Tom Lane | 2003-08-10 01:17:05 | Re: 7.4Beta1 hang? |