| From: | lz ma <ma100(at)hotmail(dot)com> |
|---|---|
| To: | "pgsql-general(at)postgresql(dot)org" <pgsql-general(at)postgresql(dot)org> |
| Subject: | Would postgresql add a pg_sleep_backend() method |
| Date: | 2022-11-03 11:43:44 |
| Message-ID: | TYWP286MB3002665D92D54B7EB10F42EBF2389@TYWP286MB3002.JPNP286.PROD.OUTLOOK.COM |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
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>发送
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Abdul Sayeed | 2022-11-03 13:04:46 | Re: Postgres to edb AS, need conversion? |
| Previous Message | milist ujang | 2022-11-03 09:44:52 | Postgres to edb AS, need conversion? |