Received: from localhost (maia-5.hub.org [200.46.204.182]) by postgresql.org (Postfix) with ESMTP id BA75B9FB540 for ; Mon, 12 Feb 2007 05:42:31 -0400 (AST) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.182]) (amavisd-new, port 10024) with ESMTP id 77300-02 for ; Mon, 12 Feb 2007 05:42:24 -0400 (AST) X-Greylist: domain auto-whitelisted by SQLgrey-1.7.4 Received: from wr-out-0506.google.com (wr-out-0506.google.com [64.233.184.238]) by postgresql.org (Postfix) with ESMTP id 83A789FB526 for ; Mon, 12 Feb 2007 05:42:27 -0400 (AST) Received: by wr-out-0506.google.com with SMTP id i21so1651404wra for ; Mon, 12 Feb 2007 01:42:26 -0800 (PST) DomainKey-Signature: a=rsa-sha1; c=nofws; d=gmail.com; s=beta; h=received:message-id:date:from:to:subject:cc:in-reply-to:mime-version:content-type:content-transfer-encoding:content-disposition:references; b=KZ9qcFT27df4rTip/nadROUzsdwU8L1Z12rl9HxrEbAJLXkmee6FuCtkirjnRg4JKd86nMmToc5gAQvsdH1MuVpJCuBqGWhgVmvBjyendmQVc1cGBj8okJXL46ZJZmne7X+x/Sf4H5x6MANEPI5NzoaqP1Nht7lzo1Z3G/Pm2yE= Received: by 10.114.152.17 with SMTP id z17mr6624632wad.1171273345537; Mon, 12 Feb 2007 01:42:25 -0800 (PST) Received: by 10.114.46.3 with HTTP; Mon, 12 Feb 2007 01:42:25 -0800 (PST) Message-ID: <376dd1950702120142r3069d43r4b464d1feb619844@mail.gmail.com> Date: Mon, 12 Feb 2007 17:42:25 +0800 From: "Edwin Eyan Moragas" To: "Benjamin Arai" Subject: Re: Priorities for users or queries? Cc: pgsql-general@postgresql.org, pgsql-admin@postgresql.org In-Reply-To: <45CED52B.3070107@araisoft.com> MIME-Version: 1.0 Content-Type: text/plain; charset=ISO-8859-1; format=flowed Content-Transfer-Encoding: 7bit Content-Disposition: inline References: <45CE69B5.40204@araisoft.com> <376dd1950702110031i40d41133n85c6010d3f81d903@mail.gmail.com> <45CED52B.3070107@araisoft.com> X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=0.119 tagged_above=0 required=5 tests=AWL, SPF_PASS X-Spam-Level: X-Archive-Number: 200702/151 X-Sequence-Number: 24616 On 2/11/07, Benjamin Arai 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 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/