Horton

Re: [HACKERS] What can we learn from MySQL?

Bruce Momjian <pgman@candle.pha.pa.us>

View thread
From: Bruce Momjian <pgman@candle.pha.pa.us>
To: "D'Arcy J.M. Cain" <darcy@druid.net>
Cc: pg@fastcrypt.com, matthew@zeut.net, coelho@cri.ensmp.fr, pgsql-hackers@postgresql.org, pgsql-advocacy@postgresql.org
Date: 2004-04-23T17:08:30Z
Lists: pgsql-hackers 
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