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