Received: from localhost (maia-2.hub.org [200.46.204.187])
	by postgresql.org (Postfix) with ESMTP id F06709FBC59
	for <pgsql-performance-postgresql.org@postgresql.org>;
	Wed, 21 Feb 2007 16:29:14 -0400 (AST)
Received: from postgresql.org ([200.46.204.71])
	by localhost (mx1.hub.org [200.46.204.187]) (amavisd-new, port 10024)
	with ESMTP id 61488-02 for
	<pgsql-performance-postgresql.org@postgresql.org>;
	Wed, 21 Feb 2007 16:29:04 -0400 (AST)
X-Greylist: from auto-whitelisted by SQLgrey-1.7.4
Received: from floppy.pyrenet.fr (floppy.pyrenet.fr [194.116.145.2])
	by postgresql.org (Postfix) with ESMTP id AC86F9FB83B
	for <pgsql-performance@postgresql.org>;
	Wed, 21 Feb 2007 16:29:06 -0400 (AST)
Received: by floppy.pyrenet.fr (Postfix, from userid 106)
	id 95DC630DF5; Wed, 21 Feb 2007 21:29:04 +0100 (MET)
From: Mark Stosberg <mark@summersault.com>
X-Newsgroups: pgsql.performance
Subject: Re: Auto-Vacuum in 8.1 was ineffective for me. 8.2 may work better?
Date: Wed, 21 Feb 2007 15:28:34 -0500
Organization: Hub.Org Networking Services
Lines: 30
Message-ID: <eria2f$2ut7$1@news.hub.org>
References: <eri3hk$2dss$1@news.hub.org>
	<20070221185544.GX25424@alvh.no-ip.org>
Mime-Version: 1.0
Content-Type: text/plain; charset=ISO-8859-1
Content-Transfer-Encoding: 7bit
X-Complaints-To: usenet@news.hub.org
User-Agent: Thunderbird 1.5.0.8 (X11/20061109)
In-Reply-To: <20070221185544.GX25424@alvh.no-ip.org>
To: pgsql-performance@postgresql.org
X-Virus-Scanned: Maia Mailguard 1.0.1
X-Spam-Status: No, hits=0.255 tagged_above=0 required=5 tests=AWL, BAYES_50
X-Spam-Level: 
X-Archive-Number: 200702/221
X-Sequence-Number: 23275

Alvaro Herrera wrote:
> Mark Stosberg wrote:
>> When I upgraded a busy database system to PostgreSQL 8.1, I was excited
>> about AutoVacuum, and promptly enabled it, and turned off the daily
>> vacuum process.
>>
>> (
>> I set the following, as well as the option to enable auto vacuuming
>> stats_start_collector = true
>> stats_row_level = true
>> )
>>
>> I could see in the logs that related activity was happening, but within
>> a few days, the performance became horrible, and enabling the regular
>> vacuum fixed it.
>>
>> Eventually autovacuum was completely disabled.
> 
> This has been tracked down to a bug in 8.1's Windows port.  See
> http://people.planetpostgresql.org/mha/index.php?/archives/134-8.1-on-win32-pgstat-and-autovacuum.html

Thanks for the response Alvaro. This would have been on FreeBSD.

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?

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

  Mark