X-Original-To: pgsql-performance-postgresql.org@localhost.postgresql.org
Received: from localhost (av.hub.org [200.46.204.144])
	by postgresql.org (Postfix) with ESMTP id EE4669DC97A
	for <pgsql-performance-postgresql.org@localhost.postgresql.org>;
	Tue, 17 Jan 2006 13:17:02 -0400 (AST)
Received: from postgresql.org ([200.46.204.71])
	by localhost (av.hub.org [200.46.204.144]) (amavisd-new, port 10024)
	with ESMTP id 08140-10
	for <pgsql-performance-postgresql.org@localhost.postgresql.org>;
	Tue, 17 Jan 2006 13:17:01 -0400 (AST)
X-Greylist: from auto-whitelisted by SQLgrey-
Received: from r1.mycybernet.net (r1.mycybernet.net [209.5.206.8])
	by postgresql.org (Postfix) with ESMTP id B9CB39DC95C
	for <pgsql-performance@postgresql.org>;
	Tue, 17 Jan 2006 13:17:00 -0400 (AST)
Received: from 227-54-222-209.mycybernet.net ([209.222.54.227]:34831
	helo=phlogiston.dydns.org)
	by r1.mycybernet.net with esmtp (Exim 4.50 (FreeBSD))
	id 1EyuS4-000K1r-5H
	for pgsql-performance@postgresql.org; Tue, 17 Jan 2006 12:17:00 -0500
Received: by phlogiston.dydns.org (Postfix, from userid 1000)
	id 42F4F406B; Tue, 17 Jan 2006 12:16:56 -0500 (EST)
Date: Tue, 17 Jan 2006 12:16:56 -0500
From: Andrew Sullivan <ajs@crankycanuck.ca>
To: pgsql-performance@postgresql.org
Subject: Re: Autovacuum / full vacuum
Message-ID: <20060117171656.GL21092@phlogiston.dyndns.org>
References: <dqigaf$1b98$1@news.hub.org> <43CCC711.504@familyhealth.com.au>
	<dqih4p$1clg$1@news.hub.org>
	<m3zmlvq7c9.fsf@mobile.int.cbbrowne.com>
	<dqj07o$2tl4$1@news.hub.org>
	<20060117150800.GF21092@phlogiston.dyndns.org>
	<1137513565.25500.4.camel@state.g2switchworks.com>
Mime-Version: 1.0
Content-Type: text/plain; charset=us-ascii
Content-Disposition: inline
In-Reply-To: <1137513565.25500.4.camel@state.g2switchworks.com>
User-Agent: Mutt/1.5.9i
X-Virus-Scanned: by amavisd-new at hub.org
X-Spam-Status: No, score=0.083 required=5 tests=[AWL=0.083]
X-Spam-Score: 0.083
X-Spam-Level: 
X-Archive-Number: 200601/249
X-Sequence-Number: 16727

On Tue, Jan 17, 2006 at 09:59:25AM -0600, Scott Marlowe wrote:
> I have to admit, looking at the documentation, that we really don't
> explain this all that well in the administration section, and I can see
> how easily led astray beginners are.

I understand what you mean, but I suppose my reaction would be that
what we really need is a place to keep these things, with a note in
the docs that the "best practice" settings for these are documented
at <some url>, and evolve over time as people gain expertise with the
new features.

I suspect, for instance, that nobody knows exactly the right settings
for any generic workload yet under 8.1 (although probably people know
them well enough for particular workloads).

A


-- 
Andrew Sullivan  | ajs@crankycanuck.ca
This work was visionary and imaginative, and goes to show that visionary
and imaginative work need not end up well. 
		--Dennis Ritchie