Re: Getting Slow - Mailing list pgsql-performance

From Tom Lane
Subject Re: Getting Slow
Date
Msg-id 11936.1181267173@sss.pgh.pa.us
Whole thread Raw
In response to Re: Getting Slow  (Alvaro Herrera <alvherre@commandprompt.com>)
Responses Re: Getting Slow
List pgsql-performance
Alvaro Herrera <alvherre@commandprompt.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

pgsql-performance by date:

Previous
From: Tom Lane
Date:
Subject: Re: performance drop on 8.2.4, reverting to 8.1.4
Next
From: Alvaro Herrera
Date:
Subject: Re: Getting Slow