Re: Renice on Postgresql process

Поиск
Список
Период
Сортировка
От Ben Chobot
Тема Re: Renice on Postgresql process
Дата
Msg-id 4BE5BF0B-0404-4307-BD14-19DD92468262@silentmedia.com
обсуждение исходный текст
Ответ на Renice on Postgresql process  ("Ayappan P2" <ayappap2@in.ibm.com>)
Ответы Re: Renice on Postgresql process  ("Joshua D. Drake" <jd@commandprompt.com>)
Список 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 по дате отправления:

Предыдущее
От: Alvaro Herrera
Дата:
Сообщение: Re: pg_multixact/members growing
Следующее
От: "Joshua D. Drake"
Дата:
Сообщение: Re: Renice on Postgresql process