Re: Priorities for users or queries? - Mailing list pgsql-hackers

From José Orlando Pereira
Subject Re: Priorities for users or queries?
Date
Msg-id 200702211614.35799.jop@lsd.di.uminho.pt
Whole thread Raw
Responses Re: Priorities for users or queries?  ("Jim C. Nasby" <jim@nasby.net>)
List 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 by date:

Previous
From: José Orlando Pereira
Date:
Subject: Re: Proposal: Change of pg_trigger.tg_enabled and adding
Next
From: Andrew Dunstan
Date:
Subject: Re: Column storage positions