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 <[EMAIL PROTECTED]> http://fetter.org/ Phone: +1 415 235 3778 AIM: dfetter666 Yahoo!: dfetter Skype: davidfetter XMPP: [EMAIL PROTECTED] Remember to vote! Consider donating to Postgres: http://www.postgresql.org/about/donate -- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-hackers
