Skip site navigation (1) Skip section navigation (2)

Re: Priorities for users or queries?

From: "Joshua D(dot) Drake" <jd(at)commandprompt(dot)com>
To: Benjamin Arai <benjamin(at)araisoft(dot)com>
Cc: pgsql-general(at)postgresql(dot)org, pgsql-admin(at)postgresql(dot)org
Subject: Re: Priorities for users or queries?
Date: 2007-02-11 06:45:53
Message-ID: 45CEBBA1.2070100@commandprompt.com (view raw or flat)
Thread:
Lists: pgsql-adminpgsql-generalpgsql-hackers
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/


In response to

pgsql-hackers by date

Next:From: David FetterDate: 2007-02-11 06:59:22
Subject: Re: XML export
Previous:From: Joshua D. DrakeDate: 2007-02-11 06:39:03
Subject: Re: Acclerating INSERT/UPDATE using UPS

pgsql-admin by date

Next:From: Edwin Eyan MoragasDate: 2007-02-11 08:31:33
Subject: Re: Priorities for users or queries?
Previous:From: Adam RichDate: 2007-02-11 06:05:42
Subject: Re: Priorities for users or queries?

pgsql-general by date

Next:From: Edwin Eyan MoragasDate: 2007-02-11 08:31:33
Subject: Re: Priorities for users or queries?
Previous:From: Adam RichDate: 2007-02-11 06:05:42
Subject: Re: Priorities for users or queries?

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group