Tom Lane wrote:
> Alvaro Herrera <alvherre(at)commandprompt(dot)com> writes:
> > Also if autovacuum is eating all your I/O you may want to look into
> > throttling it back a bit by setting autovacuum_vacuum_cost_delay to a
> > non-zero value.
> BTW, why is it that autovacuum_cost_delay isn't enabled by default?
> I can hardly believe that anyone will want to run it without that.
> *Especially* not with multiple workers configured by default.
Just because we haven't agreed a value. Default autovacuum parameters
is something we should definitely discuss for 8.3.
Alvaro Herrera http://www.CommandPrompt.com/
PostgreSQL Replication, Consulting, Custom Development, 24x7 support
In response to
pgsql-performance by date
|Next:||From: choksi||Date: 2007-06-08 08:22:14|
|Subject: Database size|
|Previous:||From: Tom Lane||Date: 2007-06-08 01:46:13|
|Subject: Re: Getting Slow |