Re: Change query priority

Поиск
Список
Период
Сортировка
От Michael Fuhr
Тема Re: Change query priority
Дата
Msg-id 20041010160555.GA94113@winnie.fuhr.org
обсуждение исходный текст
Ответ на Change query priority  ("Eugeny Balakhonov" <c0ff75@mail.ru>)
Ответы Re: Change query priority  (Tom Lane <tgl@sss.pgh.pa.us>)
Список pgsql-general
On Sun, Oct 10, 2004 at 07:12:51PM +0400, Eugeny Balakhonov wrote:
>
> I want to change priority for database queries of this background program to
> "low" and change priority for web site database queries to "high".

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.  This would set the "nice" value of the
backend process, which might serve as a crude prioritization
mechanism.

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

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

Предыдущее
От: "Kiarash Bodouhi"
Дата:
Сообщение: Re: Rule problem
Следующее
От: Tom Lane
Дата:
Сообщение: Re: Change query priority