Re: Renice on Postgresql process

From: Ben Chobot <bench(at)silentmedia(dot)com>
To: Ayappan P2 <ayappap2(at)in(dot)ibm(dot)com>
Cc: pgsql-general(at)lists(dot)postgresql(dot)org
Subject: Re: Renice on Postgresql process
Date: 2018-05-23 23:36:37
Message-ID: 4BE5BF0B-0404-4307-BD14-19DD92468262@silentmedia.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

> On May 7, 2018, at 11:50 PM, Ayappan P2 <ayappap2(at)in(dot)ibm(dot)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.

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Joshua D. Drake 2018-05-23 23:45:29 Re: Renice on Postgresql process
Previous Message Alvaro Herrera 2018-05-23 22:37:38 Re: pg_multixact/members growing