From: Bruce Momjian <pgman@candle.pha.pa.us>
Message-Id: <200404231708.i3NH8UM19188@candle.pha.pa.us>
Subject: Re: [HACKERS] What can we learn from MySQL?
In-Reply-To: <20040423124716.521420c2.darcy@druid.net>
To: "D'Arcy J.M. Cain" <darcy@druid.net>
Date: Fri, 23 Apr 2004 13:08:30 -0400 (EDT)
Cc: pg@fastcrypt.com, matthew@zeut.net, coelho@cri.ensmp.fr,
	pgsql-hackers@postgresql.org, pgsql-advocacy@postgresql.org
MIME-Version: 1.0
Content-Transfer-Encoding: 7bit
Content-Type: text/plain; charset=US-ASCII

D'Arcy J.M. Cain wrote:
> On Fri, 23 Apr 2004 11:07:20 -0400
> Dave Cramer <pg@fastcrypt.com> wrote:
> > Does the current implementation of pg_autovacuum have a way of setting
> > windows where it is allowed to vacuum? Many large 24/7 will only allow
> > vacuumming at certain times of the day.
> 
> It seems to me that the point of pg_autovacuum would be to run 24/7 so
> that there is never big hit on the system.  Perhaps it could be designed
> to throttle itself based on current system usage though.

Or the number of connected backends, or both?

-- 
  Bruce Momjian                        |  http://candle.pha.pa.us
  pgman@candle.pha.pa.us               |  (610) 359-1001
  +  If your life is a hard drive,     |  13 Roberts Road
  +  Christ can be your backup.        |  Newtown Square, Pennsylvania 19073