Re: Priorities for users or queries?

On 2/11/07, Benjamin Arai <benjamin(at)araisoft(dot)com> wrote:
> Hi,
>
> 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!

with all due respect to Josh who has replied to this question already.

i have been thinking about this and would like to make sure i am on
the right track.

yes, there is no way to give priorities to queries or users in the db.
however, please correct me if i'm wrong, if i want something to run
with lower priority, i can use different connection parameters
which would use lower system resources. thus, this connection
would run "slower" that the other "normal" connections to the db.

would that be right?

>
> Benjamin
>
>
> ---------------------------(end of broadcast)---------------------------
> TIP 7: You can help support the PostgreSQL project by donating at
>
> http://www.postgresql.org/about/donate
>

--
edwin eyan moragas
aspiring programmer
garnet:jasmin:beryllium:gluon::90-12264
http://www.eyan.org/