We are doing "renice" on the main Postgresql process to give higher scheduling priority because other critical operations depends on the database.

You are saying that the database processes take longer to relinquish their resources and we won't achieve anything out of renice, So i assume renice of the database processes is not at all required ?

Thanks

Ayappan P

----- Original message -----
From: Ben Chobot <bench@silentmedia.com>
To: Ayappan P2 <ayappap2@in.ibm.com>
Cc: pgsql-general@lists.postgresql.org
Subject: Re: Renice on Postgresql process
Date: Mon, May 7, 2018 11:35 PM

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.