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

Re: Priorities for users or queries?

From: Benjamin Arai <benjamin(at)araisoft(dot)com>
To: "Joshua D(dot) Drake" <jd(at)commandprompt(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 05:41:03
Message-ID: 45CEAC6F.8040801@araisoft.com (view raw or flat)
Thread:
Lists: pgsql-adminpgsql-generalpgsql-hackers
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
>>
>>     
>
>
>   

In response to

Responses

pgsql-hackers by date

Next:From: Hideyuki KawashimaDate: 2007-02-11 06:04:43
Subject: Re: Acclerating INSERT/UPDATE using UPS
Previous:From: Christopher BrowneDate: 2007-02-11 05:37:18
Subject: Re: Acclerating INSERT/UPDATE using UPS

pgsql-admin by date

Next:From: Adam RichDate: 2007-02-11 06:05:42
Subject: Re: Priorities for users or queries?
Previous:From: Christopher BrowneDate: 2007-02-11 05:18:23
Subject: Re: Password Policy

pgsql-general by date

Next:From: Adam RichDate: 2007-02-11 06:05:42
Subject: Re: Priorities for users or queries?
Previous:From: Christopher BrowneDate: 2007-02-11 05:18:23
Subject: Re: Password Policy

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