Received: from maia.hub.org (unknown [200.46.204.183])
	by mail.postgresql.org (Postfix) with ESMTP id E783E643E8A
	for <pgsql-performance-postgresql.org@mail.postgresql.org>;
	Mon,  1 Mar 2010 04:23:13 -0400 (AST)
Received: from mail.postgresql.org ([200.46.204.86])
	by maia.hub.org (mx1.hub.org [200.46.204.183]) (amavisd-maia,
	port 10024) with ESMTP id 82189-03-2
	for <pgsql-performance-postgresql.org@mail.postgresql.org>;
	Mon,  1 Mar 2010 08:23:03 +0000 (UTC)
X-Greylist: domain auto-whitelisted by SQLgrey-1.7.6
Received: from web46102.mail.sp1.yahoo.com (web46102.mail.sp1.yahoo.com
	[68.180.199.119])
	by mail.postgresql.org (Postfix) with SMTP id 3CFEE658CF9
	for <pgsql-performance@postgresql.org>;
	Mon,  1 Mar 2010 03:08:04 -0400 (AST)
Received: (qmail 16676 invoked by uid 60001); 1 Mar 2010 07:08:02 -0000
DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=yahoo.com; s=s1024;
	t=1267427282; bh=38fH530I3VxQgo6B/ACXxYnghZ7dss7crJz8vWnd2Zo=;
	h=Message-ID:X-YMail-OSG:Received:X-Mailer:References:Date:From:Subject:To:In-Reply-To:MIME-Version:Content-Type;
	b=M7hhdJGRVI3Ne7OTVofDXNegT5KrBJuX95P/crdT+pwACNGJM4sO8H8xwZd9r4sMs8XXa9yVwDekcbk9DFeYl2m5AKoeCC6VUldPmGwH4xT6BLkk21lVVYaKhcbqTRL+y0omgjjAOumiuDAi2kmy7O/nKFu3OukpIRc8S7KgB4o=
DomainKey-Signature: a=rsa-sha1; q=dns; c=nofws; s=s1024; d=yahoo.com;
	h=Message-ID:X-YMail-OSG:Received:X-Mailer:References:Date:From:Subject:To:In-Reply-To:MIME-Version:Content-Type;
	b=unNbqohhGRwfWuXRL12wh4tTFGGqvRYpDOuiLngmcpWP2F2ahTd2GslspIpxMofJiTp+vmP17uoPhrWAc/YbCpL8Acajoi6zIaG0oMe1sXsGgVhNC/06wIPn34VMJOwqsVIOvr9H26HdGNbgVP4vLkFIrbv0NAHYNraCyXdr0FM=;
Message-ID: <841727.16396.qm@web46102.mail.sp1.yahoo.com>
X-YMail-OSG: 
 Do4Lj2MVM1mhW1Gmj9bJw3bgrct1IPXhBW4aIB2OCxazV_mFJ02s4YxHbuIGJULVbjJq1teH6SsAG..nSqQEBEPcLU9_FxdHl8TbfouKtvxYdPtTvln6_zqYmwG7o0kh8tNdphHYvgl0cuEUQNF3Z_rRQ9wkp5eQgbAtyz6rKFjfR_KM4zjBx9I6btknlPO5joS5nUhJp.77IKotzgYqMZNEUpq0HS_npGpvpLtPcA3imakQR8NasUWj_7yCk_Fnc3vTtg1yj2martvzt0LG5g--
Received: from [98.207.60.66] by web46102.mail.sp1.yahoo.com via HTTP;
	Sun, 28 Feb 2010 23:08:02 PST
X-Mailer: YahooMailRC/300.3 YahooMailWebService/0.8.100.260964
References: <4AB8D9AA.6050007@ummon.com>, <4AB8E145.4040901@squeakycode.net>
	<E2160D87-855A-49E9-8704-D6389A76C2F3@mimectl>
Date: Sun, 28 Feb 2010 23:08:02 -0800 (PST)
From: Greg Williamson <gwilliamson39@yahoo.com>
Subject: Re: Autovacuum Tuning advice
To: "pgsql-performance@postgresql.org" <pgsql-performance@postgresql.org>
In-Reply-To: <E2160D87-855A-49E9-8704-D6389A76C2F3@mimectl>
MIME-Version: 1.0
Content-Type: text/plain; charset=us-ascii
X-Virus-Scanned: Maia Mailguard 1.0.1
X-Spam-Status: No, hits=-1.11 tagged_above=-10 required=5 tests=BAYES_05=-1.11
X-Spam-Level: 
X-Archive-Number: 201003/3
X-Sequence-Number: 37828

Joe wrote:


> I have a very busy system that takes about 9 million inserts per day and each record gets
> updated at least once after the insert (all for the one same table), there are other tables that
> get hit but not as severely.  As suspected I am having a problem with table bloat.  Any advice
> on how to be more aggressive with autovacuum?  I am using 8.4.1.  My machine has 4 Intel
>  Xeon  3000 MHz Processors with 8 GB of Ram.
> 
> Currently I am using only defaults for autovac.
> 
> shared_buffers = 768MB                  # min 128kB
> work_mem = 1MB                          # min 64kB
> maintenance_work_mem = 384MB

<snip of default config settings>


Operating system ?

Any messages in logs ?

Greg W.