Received: from localhost (maia-4.hub.org [200.46.204.183]) by postgresql.org (Postfix) with ESMTP id DA1E09FA4BB for ; Sun, 11 Feb 2007 04:31:39 -0400 (AST) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.183]) (amavisd-new, port 10024) with ESMTP id 12339-07 for ; Sun, 11 Feb 2007 04:31:37 -0400 (AST) X-Greylist: domain auto-whitelisted by SQLgrey-1.7.4 Received: from nz-out-0506.google.com (nz-out-0506.google.com [64.233.162.231]) by postgresql.org (Postfix) with ESMTP id 45C879FB2FE for ; Sun, 11 Feb 2007 04:31:35 -0400 (AST) Received: by nz-out-0506.google.com with SMTP id i11so1355487nzh for ; Sun, 11 Feb 2007 00:31:34 -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=rG3c6Xv647fVE3CqWTzNI3RqTZCNlwCmRUQ/arB4qzI/KSzPH6U5AgYHRNKTGXJRz+GZnyPzub2zya5DLtZDJ202xrYG3b5CHyIiBAQaHTOY48Qfq37RGYWJPIPRIY3dJjUKatIKT9QNG3j8MizC0zBeLSuoaZuOPXf4yhlJRvQ= Received: by 10.114.169.2 with SMTP id r2mr6520943wae.1171182693254; Sun, 11 Feb 2007 00:31:33 -0800 (PST) Received: by 10.114.46.3 with HTTP; Sun, 11 Feb 2007 00:31:33 -0800 (PST) Message-ID: <376dd1950702110031i40d41133n85c6010d3f81d903@mail.gmail.com> Date: Sun, 11 Feb 2007 16:31:33 +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: <45CE69B5.40204@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> X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200702/149 X-Sequence-Number: 24614 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/