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

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?



> Regards and best wishes,
>
> Justin Clift
>
> ---------------------------(end of broadcast)---------------------------
> TIP 9: the planner will ignore your desire to choose an index scan if your
>      joining column's datatypes do not match


--
Command Prompt, Inc., home of PostgreSQL Replication, and plPHP.
Postgresql support, programming shared hosting and dedicated hosting.
+1-503-667-4564 - jd@commandprompt.com - http://www.commandprompt.com
Mammoth PostgreSQL Replicator. Integrated Replication for PostgreSQL