Re: Renice on Postgresql process

[Ben Chobot <bench@xxxxxxxxxxxxxxx>]

On May 7, 2018, at 11:50 PM, Ayappan P2 <ayappap2@xxxxxxxxxx> 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.