Re: Sleep functions - Mailing list pgsql-hackers

From Tom Lane
Subject Re: Sleep functions
Date
Msg-id 5404.1124673200@sss.pgh.pa.us
Whole thread Raw
In response to Sleep functions  (Michael Fuhr <mike@fuhr.org>)
Responses Re: Sleep functions  ("Greg Sabino Mullane" <greg@turnstep.com>)
Re: Sleep functions  (Michael Fuhr <mike@fuhr.org>)
Re: Sleep functions  (Michael Adler <adler@pobox.com>)
List pgsql-hackers
Michael Fuhr <mike@fuhr.org> writes:
> What do people think of exposing pg_usleep() to the user?

I'm not real enthused about it.  Generally speaking, a sleep() on the
database side means you are idling while holding locks, and that does
not seem like something we want to encourage people to do.

As other responders noted, it's trivial to program this in any of the
untrusted PL languages,  So what you're really proposing is that we give
sleep() to non-superusers, and that seems like a bit of a hard sell.
Let's see a use-case or three.
        regards, tom lane


pgsql-hackers by date:

Previous
From: Tom Lane
Date:
Subject: Re: data on devel code perf dip
Next
From: "Greg Sabino Mullane"
Date:
Subject: Re: Sleep functions