Re: Renice on Postgresql process - Mailing list pgsql-general

From Ben Chobot
Subject Re: Renice on Postgresql process
Date
Msg-id 4BE5BF0B-0404-4307-BD14-19DD92468262@silentmedia.com
Whole thread Raw
In response to Renice on Postgresql process  ("Ayappan P2" <ayappap2@in.ibm.com>)
Responses Re: Renice on Postgresql process  ("Joshua D. Drake" <jd@commandprompt.com>)
List pgsql-general


On May 7, 2018, at 11:50 PM, Ayappan P2 <ayappap2@in.ibm.com> wrote:

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
 

Yes, if you make a db process nicer than the db takes longer to answer your queries. If the goal is to keep the load down on the db, that is usually going to be counterproductive.

pgsql-general by date:

Previous
From: Alvaro Herrera
Date:
Subject: Re: pg_multixact/members growing
Next
From: "Joshua D. Drake"
Date:
Subject: Re: Renice on Postgresql process