Re: Autovacuum and Autoanalyze

On Tue, Sep 16, 2008 at 08:59:08PM -0400, Alvaro Herrera wrote:
> Simon Riggs wrote:
> > Disabling autovacuum can have catastrophic effects, since it disables
> > the ANALYZing of tables.
> > 
> > Can we have a mode where we disable autoVACUUM yet enable autoANALYZE?
> 
> You mean something like
> autovacuum = on / off / analyze ?
> 
> We can certainly do that, but is there buy-in?

+1

Having autovacuum on during bulk loads can really tank performance,
but having autoanalyze on is good :)

Cheers,
David.
-- 
David Fetter <david@fetter.org> http://fetter.org/
Phone: +1 415 235 3778  AIM: dfetter666  Yahoo!: dfetter
Skype: davidfetter      XMPP: david.fetter@gmail.com

Remember to vote!
Consider donating to Postgres: http://www.postgresql.org/about/donate