Re: Change query priority

Поиск
Список
Период
Сортировка
От Michael Fuhr
Тема Re: Change query priority
Дата
Msg-id 20041010164214.GA94296@winnie.fuhr.org
обсуждение исходный текст
Ответ на Re: Change query priority  (Tom Lane <tgl@sss.pgh.pa.us>)
Список pgsql-general
On Sun, Oct 10, 2004 at 12:29:32PM -0400, Tom Lane wrote:
> Michael Fuhr <mike@fuhr.org> writes:
> > I don't know how effective this would be, but you could wrap the
> > system call setpriority() in a user-defined function if your
> > platform supports it.
>
> Every couple of months someone comes along and says "why don't you
> provide a way to renice a backend" ... but in point of fact it's
> somewhere between useless and counterproductive for most query loads.

I wondered if that might be the case; thanks for pointing out the
reasons, which I now recall having read about before.  I withdraw
the suggestion.

--
Michael Fuhr
http://www.fuhr.org/~mfuhr/

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

Предыдущее
От: Tom Lane
Дата:
Сообщение: Re: Change query priority
Следующее
От: Bruno Wolff III
Дата:
Сообщение: Re: OS not good for database