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 96E303A470A;
	Thu,  4 Nov 2004 00:22:02 +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 49189-02; Thu,  4 Nov 2004 00:21:58 +0000 (GMT)
Received: from hub.org (hub.org [200.46.204.220])
	by svr1.postgresql.org (Postfix) with ESMTP id 311E53A4703;
	Thu,  4 Nov 2004 00:22:01 +0000 (GMT)
Received: from localhost (unknown [200.46.204.144])
	by hub.org (Postfix) with ESMTP id DF80912A741;
	Wed,  3 Nov 2004 20:21:57 -0400 (AST)
Received: from hub.org ([200.46.204.220])
	by localhost (av.hub.org [200.46.204.144]) (amavisd-new, port 10024)
	with ESMTP id 45586-09; Thu,  4 Nov 2004 00:21:56 +0000 (GMT)
Received: from ganymede.hub.org (blk-222-46-91.eastlink.ca [24.222.46.91])
	by hub.org (Postfix) with ESMTP id 3DE9912A73C;
	Wed,  3 Nov 2004 20:21:56 -0400 (AST)
Received: by ganymede.hub.org (Postfix, from userid 1000)
	id AC9563DF18; Wed,  3 Nov 2004 20:21:59 -0400 (AST)
Received: from localhost (localhost [127.0.0.1])
	by ganymede.hub.org (Postfix) with ESMTP id 9F55D3DF17;
	Wed,  3 Nov 2004 20:21:59 -0400 (AST)
Date: Wed, 3 Nov 2004 20:21:59 -0400 (AST)
From: "Marc G. Fournier" <scrappy@postgresql.org>
X-X-Sender: scrappy@ganymede.hub.org
To: "Joshua D. Drake" <jd@commandprompt.com>
Cc: Justin Clift <justin@postgresql.org>,
	"Marc G. Fournier" <scrappy@postgresql.org>, pgsql-www@postgresql.org
Subject: Re: pg_autovacuum is nice ... but ...
In-Reply-To: <41895D72.2060305@commandprompt.com>
Message-ID: <20041103202103.B82047@ganymede.hub.org>
References: <20041103155855.O82047@ganymede.hub.org>
	<41895BDA.1090903@postgresql.org>
	<41895D72.2060305@commandprompt.com>
MIME-Version: 1.0
Content-Type: TEXT/PLAIN; charset=US-ASCII; format=flowed
X-Virus-Scanned: by amavisd-new at hub.org
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/67
X-Sequence-Number: 5798

On Wed, 3 Nov 2004, Joshua D. Drake wrote:

> Justin Clift wrote:
>> 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?
>> 
>
> I could be wrong but my understanding is that pg_autovacuum won't vacuum 
> system tables so eventually you still need to perform a full vacuum (not 
> neccessarily a vacuum full).
>
> Could this be the issue?

I just setup a weekly cron to do a vacuum full ... I didn't realize that 
pg_autovacuum didn't catch it all, except, of course, I should have clued 
in when we had that fun with the banner database, where an index on a 12 
row table was faster then no index :)

----
Marc G. Fournier           Hub.Org Networking Services (http://www.hub.org)
Email: scrappy@hub.org           Yahoo!: yscrappy              ICQ: 7615664