Skip site navigation (1) Skip section navigation (2)

Re: get/set priority of PostgreSQL backends

From: Scott Marlowe <scott(dot)marlowe(at)gmail(dot)com>
To: Josh Kupershmidt <schmiddy(at)gmail(dot)com>
Cc: pgsql-performance(at)postgresql(dot)org
Subject: Re: get/set priority of PostgreSQL backends
Date: 2012-04-07 18:05:04
Message-ID: CAOR=d=1r8qocoo9Q-3XQW-Os+5ztngcTBrpophLSP1oMeZgkcw@mail.gmail.com (view raw or flat)
Thread:
Lists: pgsql-performance
On Sat, Apr 7, 2012 at 11:06 AM, Josh Kupershmidt <schmiddy(at)gmail(dot)com> wrote:
> The wiki says nice_backend_super() might be able to "renice any
> backend pid and set any priority, but is usable only by the [database]
> superuser", hinting that it would be feasible to lower a backend's
> priority value (i.e. increase the scheduling priority). Unfortunately
> this is not possible on at least OS X and Linux, where one must be
> root to lower priority values. I haven't checked whether this module
> works on Windows, would appreciate if someone could give it a shot
> there.

I thought you were limited to only settings above 0 and your own
processes in linux.

In response to

Responses

pgsql-performance by date

Next:From: Josh KupershmidtDate: 2012-04-07 18:31:16
Subject: Re: get/set priority of PostgreSQL backends
Previous:From: Josh KupershmidtDate: 2012-04-07 17:06:28
Subject: get/set priority of PostgreSQL backends

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group