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/aapub...rence/priority mechanisms.pdf

Regards,

--
Jose Orlando Pereira

---------------------------(end of broadcast)---------------------------
TIP 3: Have you checked our extensive FAQ?

http://www.postgresql.org/docs/faq

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/aapub...rence/priority mechanisms.pdf

That URL should be...
http://www.cs.cmu.edu/~natassa/aapub...mechanisms.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)

---------------------------(end of broadcast)---------------------------
TIP 3: Have you checked our extensive FAQ?

http://www.postgresql.org/docs/faq