Skip site navigation (1) Skip section navigation (2)

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 (view raw or flat)
Thread:
Lists: pgsql-advocacypgsql-hackerspgsql-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

pgsql-www by date

Next:From: Josh BerkusDate: 2004-04-23 17:26:04
Subject: Re: What can we learn from MySQL?
Previous:From: Bruce MomjianDate: 2004-04-23 17:13:19
Subject: Re: What can we learn from MySQL?

pgsql-hackers by date

Next:From: Josh BerkusDate: 2004-04-23 17:26:04
Subject: Re: What can we learn from MySQL?
Previous:From: Bruce MomjianDate: 2004-04-23 17:13:19
Subject: Re: What can we learn from MySQL?

pgsql-advocacy by date

Next:From: Josh BerkusDate: 2004-04-23 17:26:04
Subject: Re: What can we learn from MySQL?
Previous:From: Bruce MomjianDate: 2004-04-23 17:13:19
Subject: Re: What can we learn from MySQL?

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group