public inbox for [email protected]
help / color / mirror / Atom feedFrom: Marc G. Fournier <[email protected]>
To: Joshua D. Drake <[email protected]>
Cc: Justin Clift <[email protected]>
Cc: Marc G. Fournier <[email protected]>
Cc: [email protected]
Subject: Re: pg_autovacuum is nice ... but ...
Date: Wed, 3 Nov 2004 20:21:59 -0400 (AST)
Message-ID: <[email protected]> (raw)
In-Reply-To: <[email protected]>
References: <[email protected]>
<[email protected]>
<[email protected]>
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: [email protected] Yahoo!: yscrappy ICQ: 7615664
view thread (24+ messages) latest in thread
reply
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: [email protected]
Cc: [email protected], [email protected], [email protected]
Subject: Re: pg_autovacuum is nice ... but ...
In-Reply-To: <[email protected]>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by agora; see mirroring instructions
for how to clone and mirror all data and code used for this inbox