Re: get/set priority of PostgreSQL backends

Поиск
Список
Период
Сортировка
От Scott Marlowe
Тема Re: get/set priority of PostgreSQL backends
Дата
Msg-id CAOR=d=1r8qocoo9Q-3XQW-Os+5ztngcTBrpophLSP1oMeZgkcw@mail.gmail.com
обсуждение исходный текст
Ответ на get/set priority of PostgreSQL backends  (Josh Kupershmidt <schmiddy@gmail.com>)
Ответы Re: get/set priority of PostgreSQL backends  (Josh Kupershmidt <schmiddy@gmail.com>)
Список pgsql-performance
On Sat, Apr 7, 2012 at 11:06 AM, Josh Kupershmidt <schmiddy@gmail.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.

В списке pgsql-performance по дате отправления:

Предыдущее
От: Josh Kupershmidt
Дата:
Сообщение: get/set priority of PostgreSQL backends
Следующее
От: Josh Kupershmidt
Дата:
Сообщение: Re: get/set priority of PostgreSQL backends