From: | "Ayappan P2" <ayappap2(at)in(dot)ibm(dot)com> |
---|---|
To: | bench(at)silentmedia(dot)com |
Cc: | pgsql-general(at)lists(dot)postgresql(dot)org |
Subject: | Re: Renice on Postgresql process |
Date: | 2018-05-08 06:50:51 |
Message-ID: | OF439AB107.F97B3191-ON00258287.0024E18F-00258287.00259D51@notes.na.collabserv.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
<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" > </div>
<div dir="ltr" >Thanks</div>
<div dir="ltr" >Ayappan P</div>
<div dir="ltr" > </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 <bench(at)silentmedia(dot)com><br>To: Ayappan P2 <ayappap2(at)in(dot)ibm(dot)com><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> <br><!--Notes ACF
<meta http-equiv="Content-Type" content="text/html; charset=utf8" >-->On May 7, 2018, at 7:46 AM, Ayappan P2 <<a href="mailto:ayappap2(at)in(dot)ibm(dot)com" target="_blank" >ayappap2(at)in(dot)ibm(dot)com</a>> wrote:
<div><blockquote type="cite" >
<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>
<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" > </div></div><BR>
Attachment | Content-Type | Size |
---|---|---|
unknown_filename | text/html | 2.1 KB |
From | Date | Subject | |
---|---|---|---|
Next Message | Philipp Kraus | 2018-05-08 12:39:26 | cursor empty |
Previous Message | tango ward | 2018-05-08 05:00:58 | Re: KeyError: self._index[x] |