| From: | David Fetter <david(at)fetter(dot)org> |
|---|---|
| To: | Alvaro Herrera <alvherre(at)commandprompt(dot)com> |
| Cc: | Simon Riggs <simon(at)2ndQuadrant(dot)com>, pgsql-hackers <pgsql-hackers(at)postgresql(dot)org> |
| Subject: | Re: Autovacuum and Autoanalyze |
| Date: | 2008-09-17 06:14:38 |
| Message-ID: | 20080917061438.GD6334@fetter.org |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-hackers |
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(at)fetter(dot)org> http://fetter.org/
Phone: +1 415 235 3778 AIM: dfetter666 Yahoo!: dfetter
Skype: davidfetter XMPP: david(dot)fetter(at)gmail(dot)com
Remember to vote!
Consider donating to Postgres: http://www.postgresql.org/about/donate
| From | Date | Subject | |
|---|---|---|---|
| Next Message | KaiGai Kohei | 2008-09-17 06:28:05 | Re: Proposal of SE-PostgreSQL patches (for CommitFest:Sep) |
| Previous Message | Oleg Bartunov | 2008-09-17 05:46:41 | Re: postgres adoption in india suffers setback |