On May 7, 2018, at 7:46 AM, Ayappan P2 <
ayappap2@in.ibm.com> wrote:
Hi All,
We are using Postgresql in AIX. Unlike some other databases, Postgresql has lot of other process running in the background along with the main process.
We do "renice" only on the Postgres main process. Is it sufficient to have higher priority only for the main process or we have to do "renice" for all the Postgresql related process ( like wal writer, logger , checkpointer etc.,) ?
What do you hope to achieve with your renicing? There is a compelling school of thought which holds that nice database processes take longer to relinquish their resources, which doesn't end up helping anything at all.