Re: Sleep functions - Mailing list pgsql-hackers

From Andrew Dunstan
Subject Re: Sleep functions
Date
Msg-id 43090D13.20008@dunslane.net
Whole thread Raw
In response to Sleep functions  (Michael Fuhr <mike@fuhr.org>)
List pgsql-hackers

Michael Fuhr wrote:

>What do people think of exposing pg_usleep() to the user?  It's
>sometimes useful to have a server-side sleep function, and people
>do ask about it occasionally (e.g., Don Drake today in pgsql-admin).
>It's easy enough to do in PL/Perl, PL/Tcl, etc., but since the
>backend already has pg_usleep(), is there any reason not to expose
>it?  I'd propose both sleep() and usleep() functions.
>  
>


Be careful with documentation - IIRC on Windows the granularity of the 
Sleep() function is 1 millisec and pg_usleep rounds to the nearest 
millisec except for very low values where it rounds up.

cheers

andrew


pgsql-hackers by date:

Previous
From: Michael Fuhr
Date:
Subject: Sleep functions
Next
From: "Dave Page"
Date:
Subject: Re: Sleep functions