Thread

Re: Avoiding roundoff error in pg_sleep()

David G. Johnston <david.g.johnston@gmail.com> — 2025-09-26T15:08:10Z

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.