Agree that pausing or sleeping is not really a database
function, more of a programming function. But Oracle and I understand
though I can't find it at the moment SQL*Server do offer this
functionality within their DB's just because people do store functions
and procedures that are executed as internal database jobs and
consequently need this functionality. Not sure about DB2, been too
long, but I seem to remember it being there for other reasons though.
[mailto:pgsql-admin-owner(at)postgresql(dot)org] On Behalf Of Bruce Momjian
Sent: Monday, August 22, 2005 10:25 AM
To: Michael Fuhr
Cc: Don Drake; John DeSoi; Guido Barosio; pgsql-admin(at)postgresql(dot)org
Subject: Re: [ADMIN] sleep?
Michael Fuhr wrote:
> On Mon, Aug 22, 2005 at 08:34:29AM -0500, Don Drake wrote:
> > I agree that a basic function (non-CPU intensive sleep) like this
> > built in.
> It's being discussed in pgsql-hackers:
> Do you have any use cases in addition to what's already been
> mentioned? Sleeping isn't really a database operation, so there
> needs to be some justification for making it a standard function.
Well, we needed it for our own regression tests, so I assume others
would need it as well.
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
---------------------------(end of broadcast)---------------------------
TIP 6: explain analyze is your friend
pgsql-admin by date
|Next:||From: Alvaro Herrera||Date: 2005-08-22 15:09:28|
|Subject: Re: regenereate data/ locales|
|Previous:||From: Tom Lane||Date: 2005-08-22 15:00:14|
|Subject: Re: Corrupted data, best course of repair? |