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@xxxxxxxxxxxxxx [mailto:pgsql-admin-owner@xxxxxxxxxxxxxx] 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@xxxxxxxxxxxxxx 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@xxxxxxxxxxxxxxxx | (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
