Bruce,
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.
-----Original Message-----
From: pgsql-admin-owner@postgresql.org
[mailto:pgsql-admin-owner@postgresql.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@postgresql.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
should be
> > built in.
>
> It's being discussed in pgsql-hackers:
>
> http://archives.postgresql.org/pgsql-hackers/2005-08/msg00633.php
>
> 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@candle.pha.pa.us | (610) 359-1001
+ If your life is a hard drive, | 13 Roberts Road
+ Christ can be your backup. | Newtown Square, Pennsylvania
19073
---------------------------(end of broadcast)---------------------------
TIP 6: explain analyze is your friend