Received: from localhost (maia-3.hub.org [200.46.204.184]) by postgresql.org (Postfix) with ESMTP id 4DDCF9FB376; Sun, 11 Feb 2007 01:41:09 -0400 (AST) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.184]) (amavisd-new, port 10024) with ESMTP id 77362-01; Sun, 11 Feb 2007 01:41:04 -0400 (AST) X-Greylist: from auto-whitelisted by SQLgrey-1.7.4 X-Greylist: from auto-whitelisted by SQLgrey-1.7.4 Received: from spunkymail-a10.g.dreamhost.com (sd-green-bigip-119.dreamhost.com [208.97.132.119]) by postgresql.org (Postfix) with ESMTP id 78DC19FA147; Sun, 11 Feb 2007 01:41:05 -0400 (AST) Received: from benjamin-arais-computer.local (adsl-75-36-67-4.dsl.irvnca.sbcglobal.net [75.36.67.4]) by spunkymail-a10.g.dreamhost.com (Postfix) with ESMTP id 4146C1632D7; Sat, 10 Feb 2007 21:41:04 -0800 (PST) Message-ID: <45CEAC6F.8040801@araisoft.com> Date: Sat, 10 Feb 2007 21:41:03 -0800 From: Benjamin Arai Organization: Araisoft User-Agent: Thunderbird 2.0b2 (Macintosh/20070116) MIME-Version: 1.0 To: "Joshua D. Drake" Cc: pgsql-general@postgresql.org, pgsql-admin@postgresql.org Subject: Re: Priorities for users or queries? References: <45CE69B5.40204@araisoft.com> <45CE8822.6040407@commandprompt.com> In-Reply-To: <45CE8822.6040407@commandprompt.com> Content-Type: multipart/alternative; boundary="------------090701050609080700080801" X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=0.16 tagged_above=0 required=5 tests=AWL, HTML_MESSAGE X-Spam-Level: X-Archive-Number: 200702/146 X-Sequence-Number: 24611 This is a multi-part message in MIME format. --------------090701050609080700080801 Content-Type: text/plain; charset=ISO-8859-1; format=flowed Content-Transfer-Encoding: 7bit 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 >> >> > > > --------------090701050609080700080801 Content-Type: text/html; charset=ISO-8859-1 Content-Transfer-Encoding: 7bit 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

    


  
--------------090701050609080700080801--