Renice on Postgresql process

2018-05-07 Thread Ayappan P2 


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.,) ?

Thanks
Ayappan P

Re: Renice on Postgresql process

2018-05-07 Thread Ayappan P2 
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 To: Ayappan P2 Cc: pgsql-general@lists.postgresql.orgSubject: Re: Renice on Postgresql processDate: Mon, May 7, 2018 11:35 PM On May 7, 2018, at 7:46 AM, Ayappan P2 <ayapp...@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.