Re: Priorities for users or queries?

From: José Orlando Pereira <jop(at)lsd(dot)di(dot)uminho(dot)pt>
To: Benjamin Arai <benjamin(at)araisoft(dot)com>
Cc: pgsql-hackers(at)postgresql(dot)org
Subject: Re: Priorities for users or queries?
Date: 2007-02-21 16:14:35
Message-ID: 200702211614.35799.jop@lsd.di.uminho.pt
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Andrew Dunstan 2007-02-21 16:22:26 Re: Column storage positions
Previous Message José Orlando Pereira 2007-02-21 16:09:56 Re: Proposal: Change of pg_trigger.tg_enabled and adding