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

From: "D'Arcy J(dot)M(dot) Cain" <darcy(at)druid(dot)net>
To: Bruce Momjian <pgman(at)candle(dot)pha(dot)pa(dot)us>
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:13:54
Message-ID: 20040423131354.30f126da.darcy@druid.net
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-advocacy pgsql-hackers pgsql-www

On Fri, 23 Apr 2004 13:08:30 -0400 (EDT)
Bruce Momjian <pgman(at)candle(dot)pha(dot)pa(dot)us> wrote:
> D'Arcy J.M. Cain wrote:
> > 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?

I am sure that there are lots of ways to guage. Not sure which is best
but I am sure that the smart people here will figure it out. The
important thing, I think, is to let the engine make the decision
dynamically. Personally I don't have a "quiet time" per se but there
are random quiet periods. Something that jumps into the fray at those
points would be really nicwe.

--
D'Arcy J.M. Cain <darcy(at){druid|vex}.net> | Democracy is three wolves
http://www.druid.net/darcy/ | and a sheep voting on
+1 416 425 1212 (DoD#0082) (eNTP) | what's for dinner.

In response to

Browse pgsql-advocacy by date

  From Date Subject
Next Message Josh Berkus 2004-04-23 17:26:04 Re: What can we learn from MySQL?
Previous Message Bruce Momjian 2004-04-23 17:13:19 Re: What can we learn from MySQL?

Browse pgsql-hackers by date

  From Date Subject
Next Message Josh Berkus 2004-04-23 17:26:04 Re: What can we learn from MySQL?
Previous Message Bruce Momjian 2004-04-23 17:13:19 Re: What can we learn from MySQL?

Browse pgsql-www by date

  From Date Subject
Next Message Josh Berkus 2004-04-23 17:26:04 Re: What can we learn from MySQL?
Previous Message Bruce Momjian 2004-04-23 17:13:19 Re: What can we learn from MySQL?