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.
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? |
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? |
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? |