Re: Priorities for users or queries?

Поиск
Список
Период
Сортировка
От José Orlando Pereira
Тема Re: Priorities for users or queries?
Дата
Msg-id 200702211614.35799.jop@lsd.di.uminho.pt
обсуждение исходный текст
Ответы Re: Priorities for users or queries?  ("Jim C. Nasby" <jim@nasby.net>)
Список pgsql-hackers
Benjamin Arai wrote:
> Is there a way to give priorities to queries or users? Something similar to 
> NICE in Linux. My goal is to give the updating (backend) application a very 
> low priority and give the web application a high priority to avoid
> disturbing the user experience.  
>
> Thanks in advance!

You might want to look at the following, as they mention a PostgreSQL 
prototype:

http://www.cs.cmu.edu/~natassa/aapubs/conference/priority mechanisms.pdf

Regards,

-- 
Jose Orlando Pereira


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

Предыдущее
От: José Orlando Pereira
Дата:
Сообщение: Re: Proposal: Change of pg_trigger.tg_enabled and adding
Следующее
От: Andrew Dunstan
Дата:
Сообщение: Re: Column storage positions