Thread: Re: Priorities for users or queries?
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
On Wed, Feb 21, 2007 at 04:14:35PM +0000, Jos?? Orlando Pereira wrote: > 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 That URL should be... http://www.cs.cmu.edu/~natassa/aapubs/conference/priority%20mechanisms.pdf There has been extensive discussion on the bizgres list about ways to implement priorities, and I believe that paper was mentioned. You should look at the archives. -- Jim Nasby jim@nasby.net EnterpriseDB http://enterprisedb.com 512.569.9461 (cell)