Re: Renice on Postgresql process

<div class="socmaildefaultfont" dir="ltr" style="font-family:Arial, Helvetica, sans-serif;font-size:10.5pt" ><div dir="ltr" >We are doing "renice" on the main Postgresql process to give higher scheduling priority because other critical operations depends on the database.</div>
<div dir="ltr" >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 ?</div>
<div dir="ltr" >&nbsp;</div>
<div dir="ltr" >Thanks</div>
<div dir="ltr" >Ayappan P</div>
<div dir="ltr" >&nbsp;</div>
<blockquote data-history-content-modified="1" dir="ltr" style="border-left:solid #aaaaaa 2px; margin-left:5px; padding-left:5px; direction:ltr; margin-right:0px" >----- Original message -----<br>From: Ben Chobot &lt;bench(at)silentmedia(dot)com&gt;<br>To: Ayappan P2 &lt;ayappap2(at)in(dot)ibm(dot)com&gt;<br>Cc: pgsql-general(at)lists(dot)postgresql(dot)org<br>Subject: Re: Renice on Postgresql process<br>Date: Mon, May 7, 2018 11:35 PM<br>&nbsp;<br><!--Notes ACF
<meta http-equiv="Content-Type" content="text/html; charset=utf8" >-->On May 7, 2018, at 7:46 AM, Ayappan P2 &lt;<a href="mailto:ayappap2(at)in(dot)ibm(dot)com" target="_blank" >ayappap2(at)in(dot)ibm(dot)com</a>&gt; wrote:

<div><blockquote type="cite" >&nbsp;
<div><div><p><font size="2" >Hi All,</font><br><br><font size="2" >We are using Postgresql in AIX. Unlike some other databases, Postgresql has lot of other process running in the background along with the main process. </font><br><br><font size="2" >We do "renice" only on the Postgres main process. Is it sufficient to have higher priority only for the main process or we have to do "renice" for all the Postgresql related process ( like wal writer, logger , checkpointer etc.,) ? </font></p></div></div></blockquote></div>&nbsp;

<div>What do you hope to achieve with your renicing? There is a compelling school of thought which holds that nice database processes take longer to relinquish their resources, which doesn't end up helping anything at all.</div></blockquote>
<div dir="ltr" >&nbsp;</div></div><BR>