Received: from localhost (wm.hub.org [200.46.204.128])
	by postgresql.org (Postfix) with ESMTP id 0A1489FB36B;
	Wed, 27 Sep 2006 14:00:38 -0300 (ADT)
Received: from postgresql.org ([200.46.204.71])
	by localhost (mx1.hub.org [200.46.204.128]) (amavisd-new, port 10024)
	with ESMTP id 61406-06; Wed, 27 Sep 2006 17:00:31 +0000 (UTC)
X-Greylist: delayed 00:28:23.507643 by SQLgrey-
X-Greylist: from auto-whitelisted by SQLgrey-
Received: from svr4.postgresql.org (svr4.postgresql.org [66.98.251.159])
	by postgresql.org (Postfix) with ESMTP id 1A8F39FB334;
	Wed, 27 Sep 2006 14:00:30 -0300 (ADT)
X-Greylist: domain auto-whitelisted by SQLgrey-1.7.3
X-Greylist: domain auto-whitelisted by SQLgrey-1.7.3
Received: from gatekeeper.look.ca (gamma1.look.ca [207.136.80.8])
	by svr4.postgresql.org (Postfix) with ESMTP id 191495AF02D;
	Wed, 27 Sep 2006 16:32:04 +0000 (GMT)
Received: from [216.154.22.132] (helo=216-154-22-132.dsl.look.ca)
	by gatekeeper.look.ca with esmtp (Exim 4.20)
	id 1GScK8-0002DE-Gp; Wed, 27 Sep 2006 16:31:52 +0000
From: Rod Taylor <pg@rbt.ca>
To: Edoardo Ceccarelli <eddy@axa.it>
Cc: pgsql-performance@postgresql.org, pgsql-admin@postgresql.org
In-Reply-To: <451AA1FE.9050704@axa.it>
References: <451AA1FE.9050704@axa.it>
Date: Wed, 27 Sep 2006 12:31:52 -0400
Message-Id: <1159374712.46586.47.camel@home>
Mime-Version: 1.0
X-Mailer: Evolution 2.6.3 FreeBSD GNOME Team Port 
X-SA-Exim-Mail-From: pg@rbt.ca
Subject: Re: [PERFORM] autovacuum on a -mostly- r/o table
Content-Type: text/plain
Content-Transfer-Encoding: 7bit
X-SA-Exim-Version: 3.1 (built Tue Feb 24 05:09:27 GMT 2004)
X-SA-Exim-Scanned: Yes
X-Virus-Scanned: Maia Mailguard 1.0.1
X-Spam-Status: No, hits=0.135 tagged_above=0 required=5 tests=FORGED_RCVD_HELO
X-Spam-Level: 
X-Archive-Number: 200609/331
X-Sequence-Number: 23245

On Wed, 2006-09-27 at 18:08 +0200, Edoardo Ceccarelli wrote:
> 
> I have read that autovacuum cannot check to see pg load before
> launching 
> vacuum but is there any patch about it? that would sort out the
> problem 
> in a good and simple way. 

In some cases the solution to high load is to vacuum the tables being
hit the heaviest -- meaning that simply checking machine load isn't
enough to make that decision.

In fact, that high load problem is exactly why autovacuum was created in
the first place.
--