Received: from localhost (maia-2.hub.org [200.46.204.187]) by postgresql.org (Postfix) with ESMTP id 646A49FB473; Sun, 11 Feb 2007 04:35:12 -0400 (AST) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.187]) (amavisd-new, port 10024) with ESMTP id 05267-04; Sun, 11 Feb 2007 04:34:57 -0400 (AST) X-Greylist: from auto-whitelisted by SQLgrey-1.7.4 X-Greylist: from auto-whitelisted by SQLgrey-1.7.4 Received: from sumo.dreamhost.com (sumo.dreamhost.com [66.33.216.29]) by postgresql.org (Postfix) with ESMTP id B7E979FB447; Sun, 11 Feb 2007 04:34:59 -0400 (AST) Received: from spunkymail-a14.g.dreamhost.com (sd-green-bigip-177.dreamhost.com [208.97.132.177]) by sumo.dreamhost.com (Postfix) with ESMTP id 9469F2752E2; Sun, 11 Feb 2007 00:34:57 -0800 (PST) Received: from benjamin-arais-computer.local (adsl-75-36-67-4.dsl.irvnca.sbcglobal.net [75.36.67.4]) by spunkymail-a14.g.dreamhost.com (Postfix) with ESMTP id DCDCE190E36; Sun, 11 Feb 2007 00:34:51 -0800 (PST) Message-ID: <45CED52B.3070107@araisoft.com> Date: Sun, 11 Feb 2007 00:34:51 -0800 From: Benjamin Arai Organization: Araisoft User-Agent: Thunderbird 2.0b2 (Macintosh/20070116) MIME-Version: 1.0 To: Edwin Eyan Moragas Cc: pgsql-general@postgresql.org, pgsql-admin@postgresql.org Subject: Re: Priorities for users or queries? References: <45CE69B5.40204@araisoft.com> <376dd1950702110031i40d41133n85c6010d3f81d903@mail.gmail.com> In-Reply-To: <376dd1950702110031i40d41133n85c6010d3f81d903@mail.gmail.com> Content-Type: text/plain; charset=ISO-8859-1; format=flowed Content-Transfer-Encoding: 7bit X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=0.16 tagged_above=0 required=5 tests=AWL X-Spam-Level: X-Archive-Number: 200702/150 X-Sequence-Number: 24615 Hi Edwin, Which connection parameters effect system resources? 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 >> > >