X-Original-To: pgsql-www-postgresql.org@localhost.postgresql.org
Received: from localhost (unknown [200.46.204.144])
	by svr1.postgresql.org (Postfix) with ESMTP id 2BADF3A46C2
	for <pgsql-www-postgresql.org@localhost.postgresql.org>;
	Wed,  3 Nov 2004 22:29:49 +0000 (GMT)
Received: from svr1.postgresql.org ([200.46.204.71])
	by localhost (av.hub.org [200.46.204.144]) (amavisd-new, port 10024)
	with ESMTP id 19131-07
	for <pgsql-www-postgresql.org@localhost.postgresql.org>;
	Wed,  3 Nov 2004 22:29:45 +0000 (GMT)
Received: from mail.iinet.net.au (mail-09.iinet.net.au [203.59.3.41])
	by svr1.postgresql.org (Postfix) with SMTP id D02E53A46B8
	for <pgsql-www@postgresql.org>; Wed,  3 Nov 2004 22:29:45 +0000 (GMT)
Received: (qmail 13065 invoked from network); 3 Nov 2004 22:29:44 -0000
Received: from unknown (HELO ?192.168.10.3?) (203.217.57.146)
	by mail.iinet.net.au with SMTP; 3 Nov 2004 22:29:44 -0000
Message-ID: <41895BDA.1090903@postgresql.org>
Date: Thu, 04 Nov 2004 09:29:46 +1100
From: Justin Clift <justin@postgresql.org>
User-Agent: Mozilla Thunderbird 0.8 (Windows/20040913)
X-Accept-Language: en-us, en
MIME-Version: 1.0
To: "Marc G. Fournier" <scrappy@postgresql.org>
Cc: pgsql-www@postgresql.org
Subject: Re: pg_autovacuum is nice ... but ...
References: <20041103155855.O82047@ganymede.hub.org>
In-Reply-To: <20041103155855.O82047@ganymede.hub.org>
Content-Type: text/plain; charset=ISO-8859-1; format=flowed
Content-Transfer-Encoding: 7bit
X-Virus-Scanned: by amavisd-new at hub.org
X-Spam-Status: No, hits=0.0 tagged_above=0.0 required=5.0 tests=
X-Spam-Level: 
X-Archive-Number: 200411/62
X-Sequence-Number: 5793

Marc G. Fournier wrote:
<snip>
> Do a vacuum full analyze on the two databases being called, and load 
> time went from 2.4sec to .46sec:

Hmmmm, is there any chance your Free Space Map settings aren't high enough?

Regards and best wishes,

Justin Clift