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.
regards, tom lane
In response to
pgsql-performance by date
|Next:||From: Alvaro Herrera||Date: 2007-06-08 02:24:28|
|Subject: Re: Getting Slow|
|Previous:||From: Tom Lane||Date: 2007-06-08 01:31:14|
|Subject: Re: performance drop on 8.2.4, reverting to 8.1.4 |