From: | "Jim C(dot) Nasby" <jim(at)nasby(dot)net> |
---|---|
To: | Jos?? Orlando Pereira <jop(at)lsd(dot)di(dot)uminho(dot)pt> |
Cc: | Benjamin Arai <benjamin(at)araisoft(dot)com>, pgsql-hackers(at)postgresql(dot)org |
Subject: | Re: Priorities for users or queries? |
Date: | 2007-02-23 16:33:31 |
Message-ID: | 20070223163331.GK19527@nasby.net |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-hackers |
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(at)nasby(dot)net
EnterpriseDB http://enterprisedb.com 512.569.9461 (cell)
From | Date | Subject | |
---|---|---|---|
Next Message | Florian G. Pflug | 2007-02-23 16:34:37 | Proposal for Implenting read-only queries during wal replay (SoC 2007) |
Previous Message | Joshua D. Drake | 2007-02-23 16:32:34 | Re: SCMS question |