The logfile stop upgrade after a vim write

2023-05-04 Thread lz ma
1. pg_ctl -D data -l MyLog 2. vim MyLog : add some words, save and exit 3. after vim operation, MyLog will never upgrade except restart server I know it caused by file descripter only open once at the start by postgres, and vim operation rename the file to MyLog~, so postgres can't up

Would postgresql add a pg_sleep_backend() method

2022-11-03 Thread lz ma
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 m