Horton

Re: pg_autovacuum is nice ... but ...

Marc Fournier <scrappy@postgresql.org>

View thread View on postgr.es
From: "Marc G. Fournier" <scrappy@postgresql.org>
To: "Joshua D. Drake" <jd@commandprompt.com>
Cc: Justin Clift <justin@postgresql.org>, "Marc G. Fournier" <scrappy@postgresql.org>, pgsql-www@postgresql.org
Date: 2004-11-04T00:21:59Z
Lists: pgsql-hackers 
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