Message-ID: <45DCAD50.8080104@zeut.net>
Date: Wed, 21 Feb 2007 15:36:32 -0500
From: "Matthew T. O'Connor" <matthew@zeut.net>
User-Agent: Thunderbird 2.0b2 (Windows/20070116)
MIME-Version: 1.0
To: Mark Stosberg <mark@summersault.com>
CC: pgsql-performance@postgresql.org
Subject: Re: Auto-Vacuum in 8.1 was ineffective for me. 8.2 may
 work better?
References: <eri3hk$2dss$1@news.hub.org>
	<20070221185544.GX25424@alvh.no-ip.org>
	<eria2f$2ut7$1@news.hub.org>
In-Reply-To: <eria2f$2ut7$1@news.hub.org>
Content-Type: text/plain; charset=ISO-8859-1; format=flowed
Content-Transfer-Encoding: 7bit

Mark Stosberg wrote:
> Let me ask the question a different way: Is simply setting the two
> values plus enabling autovacuuming generally enough, or is further
> tweaking common place?

No, most people in addition to setting those two GUC settings also lower 
the threshold values (there is a fair amount of discussion on this in 
the lists) the defaults are not aggressive enough, so you tables 
probably aren't getting vacuumed often enough to keep up with the load.

Some work loads also require that you do cron based vacuuming of 
specific highly active tables.

> Perhaps I'll give it another tree when we upgrade to 8.2.

Autovacuum is still somewhat new, and there were some significant 
improvements in 8.2 so yes you should give it another try.