Horton

Re: Avoiding roundoff error in pg_sleep()

David G. Johnston <david.g.johnston@gmail.com>

View thread
From: "David G. Johnston" <david.g.johnston@gmail.com>
To: Vladlen Popolitov <v.popolitov@postgrespro.ru>
Cc: Tom Lane <tgl@sss.pgh.pa.us>, "pgsql-hackers@lists.postgresql.org" <pgsql-hackers@lists.postgresql.org>
Date: 2025-09-26T15:08:10Z
Lists: pgsql-hackers 
On Friday, September 26, 2025, Vladlen Popolitov <v.popolitov@postgrespro.ru>
wrote:

>
> It looks like sleep has the wrong place in a function. It should be
> an utility command, that does not start a transaction.
>

Then write that command.  We’re not going to change pg_sleep.  It’s works
just as advertised.  True, it probably should never be used in production.

I can see a pipeline sequence tossing a wait command into the flow so
having the server accept a wait instruction has at least some immediate
merit.

David J.