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

From: Bruce Momjian <pgman(at)candle(dot)pha(dot)pa(dot)us>
To: "D'Arcy J(dot)M(dot) Cain" <darcy(at)druid(dot)net>
Cc: pg(at)fastcrypt(dot)com, matthew(at)zeut(dot)net, coelho(at)cri(dot)ensmp(dot)fr, pgsql-hackers(at)postgresql(dot)org, pgsql-advocacy(at)postgresql(dot)org
Subject: Re: [HACKERS] What can we learn from MySQL?
Date: 2004-04-23 17:08:30
Message-ID: 200404231708.i3NH8UM19188@candle.pha.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-advocacy pgsql-hackers pgsql-www

D'Arcy J.M. Cain wrote:
> On Fri, 23 Apr 2004 11:07:20 -0400
> Dave Cramer <pg(at)fastcrypt(dot)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(at)candle(dot)pha(dot)pa(dot)us | (610) 359-1001
+ If your life is a hard drive, | 13 Roberts Road
+ Christ can be your backup. | Newtown Square, Pennsylvania 19073

In response to

Responses

Browse pgsql-advocacy by date

  From Date Subject
Next Message Andrew Dunstan 2004-04-23 17:11:54 Re: [HACKERS] What can we learn from MySQL?
Previous Message Josh Berkus 2004-04-23 17:03:17 Re: What can we learn from MySQL?

Browse pgsql-hackers by date

  From Date Subject
Next Message Andrew Dunstan 2004-04-23 17:11:54 Re: [HACKERS] What can we learn from MySQL?
Previous Message Josh Berkus 2004-04-23 17:03:17 Re: What can we learn from MySQL?

Browse pgsql-www by date

  From Date Subject
Next Message Andrew Dunstan 2004-04-23 17:11:54 Re: [HACKERS] What can we learn from MySQL?
Previous Message Josh Berkus 2004-04-23 17:03:17 Re: What can we learn from MySQL?