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
|
| Список | 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 ?ThanksAyappan 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 по дате отправления: