Re: Renice on Postgresql process

2018-05-24 Thread Peter J. Holzer
On 2018-05-07 11:04:31 -0700, Ben Chobot wrote: > On May 7, 2018, at 7:46 AM, Ayappan P2 wrote: > 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. > > We do "renice" only on

Re: Renice on Postgresql process

2018-05-23 Thread Joshua D. Drake
On 05/23/2018 04:36 PM, Ben Chobot wrote: On May 7, 2018, at 11:50 PM, Ayappan P2 > 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 d

Re: Renice on Postgresql process

2018-05-23 Thread Ben Chobot
> On May 7, 2018, at 11:50 PM, Ayappan P2 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 an

Re: Renice on Postgresql process

2018-05-07 Thread Ayappan P2
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

Re: Renice on Postgresql process

2018-05-07 Thread Ben Chobot
On May 7, 2018, at 7:46 AM, Ayappan P2 wrote: > > Hi All, > > 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. > > We do "renice" only on the Postgres main process. Is it sufficient to hav

Renice on Postgresql process

2018-05-07 Thread Ayappan P2
Hi All, 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. 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 "