Skip site navigation (1) Skip section navigation (2)

Re: Getting Slow

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 (view raw or flat)
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

In response to

pgsql-performance by date

Next:From: choksiDate: 2007-06-08 08:22:14
Subject: Database size
Previous:From: Tom LaneDate: 2007-06-08 01:46:13
Subject: Re: Getting Slow

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group