Thread: Priorities for users or queries?

Priorities for users or queries?

From
Benjamin Arai
Date:
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!

Benjamin


Re: Priorities for users or queries?

From
"Joshua D. Drake"
Date:
Benjamin Arai 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.\

Nope :)

Joshua D. Drake


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


--

      === The PostgreSQL Company: Command Prompt, Inc. ===
Sales/Support: +1.503.667.4564 || 24x7/Emergency: +1.800.492.2240
Providing the most comprehensive  PostgreSQL solutions since 1997
             http://www.commandprompt.com/

Donate to the PostgreSQL Project: http://www.postgresql.org/about/donate
PostgreSQL Replication: http://www.commandprompt.com/products/


Re: Priorities for users or queries?

From
Benjamin Arai
Date:
Just to clarify, there is no way to throttle specific queries or users in PostgreSQL?

Benjamin

Joshua D. Drake wrote:
Benjamin Arai 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.\   
Nope :)

Joshua D. Drake

 
Thanks in advance!

Benjamin


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

Re: Priorities for users or queries?

From
"Joshua D. Drake"
Date:
Benjamin Arai wrote:
> Just to clarify, there is no way to throttle specific queries or users
> in PostgreSQL?

That is correct.

Sincerely,

Joshua D. Drake



>
> Benjamin
>
> Joshua D. Drake wrote:
>> Benjamin Arai 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.\
>>>
>>
>> Nope :)
>>
>> Joshua D. Drake
>>
>>
>>
>>> Thanks in advance!
>>>
>>> Benjamin
>>>
>>>
>>> ---------------------------(end of broadcast)---------------------------
>>> TIP 7: You can help support the PostgreSQL project by donating at
>>>
>>>                http://www.postgresql.org/about/donate
>>>
>>>
>>
>>
>>
>


--

      === The PostgreSQL Company: Command Prompt, Inc. ===
Sales/Support: +1.503.667.4564 || 24x7/Emergency: +1.800.492.2240
Providing the most comprehensive  PostgreSQL solutions since 1997
             http://www.commandprompt.com/

Donate to the PostgreSQL Project: http://www.postgresql.org/about/donate
PostgreSQL Replication: http://www.commandprompt.com/products/


Re: Priorities for users or queries?

From
"Edwin Eyan Moragas"
Date:
On 2/11/07, Benjamin Arai <benjamin@araisoft.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/

Re: Priorities for users or queries?

From
Benjamin Arai
Date:
Hi Edwin,

Which connection parameters effect system resources?

Benjamin

Edwin Eyan Moragas wrote:
> On 2/11/07, Benjamin Arai <benjamin@araisoft.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
>>
>
>

Re: Priorities for users or queries?

From
"Edwin Eyan Moragas"
Date:
On 2/11/07, Benjamin Arai <benjamin@araisoft.com> wrote:
> Hi Edwin,
>
> Which connection parameters effect system resources?

i remembered wrong. the connection parameters i was thinking of is here:
http://www.postgresql.org/docs/8.2/static/libpq-envars.html

however, looking more closely to the config file, it can be set here:
http://www.postgresql.org/docs/8.2/static/runtime-config-resource.html

but *i am not sure* if it can be set on a per user basis. internet too
slow just now.

>
> Benjamin
>
> Edwin Eyan Moragas wrote:
> > On 2/11/07, Benjamin Arai <benjamin@araisoft.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/