Thread

Would postgresql add a pg_sleep_backend() method

ma lz <ma100@hotmail.com> — 2022-11-03T11:43:44Z

Postgresql already pg_cancel_backend and pg_terminate_backend which will stop a backend.
Sometimes the system is busy (e.g. disk IO) for a long time, but I don’t want to stop each backend
If postgres has a sleep method, I may let some pid just sleep a few times, so disk busy may decend
and the most import backend may  run faster.
Backend1 -----disk busy 99%                                                        Backend1 -----disk busy 99%
Backend2 -----disk bush 99%      pg_sleep_backend(1, 10min)     Backend2 -----disk busy 0%
Backend3 -----disk bush 99%      pg_sleep_backend(1, 11min)     Backend3 -----disk busy 0%
Backend4 -----disk bush 99%      pg_sleep_backend(1, 12min)     Backend4 -----disk busy 0%






从 Windows 版邮件<https://go.microsoft.com/fwlink/?LinkId=550986>发送