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