| From: | Alvaro Herrera <alvherre(at)commandprompt(dot)com> |
|---|---|
| To: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> |
| Cc: | Joe Lester <joe_lester(at)sweetwater(dot)com>, pgsql-performance(at)postgresql(dot)org |
| Subject: | Re: Getting Slow |
| Date: | 2007-06-08 02:24:28 |
| Message-ID: | 20070608022428.GE20828@alvh.no-ip.org |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-performance |
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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | choksi | 2007-06-08 08:22:14 | Database size |
| Previous Message | Tom Lane | 2007-06-08 01:46:13 | Re: Getting Slow |