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
Views: Raw Message | Whole Thread | Download mbox | Resend email
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

Browse pgsql-performance by date

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