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
---------------------------(end of broadcast)---------------------------
TIP 9: In versions below 8.0, the planner will ignore your desire to
choose an index scan if your joining column's datatypes do not
match
