Received: from localhost (maia-5.hub.org [200.46.204.182]) by postgresql.org (Postfix) with ESMTP id 797459FA34A for ; Sun, 11 Feb 2007 02:04:13 -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 82567-07 for ; Sun, 11 Feb 2007 02:04:07 -0400 (AST) X-Greylist: domain auto-whitelisted by SQLgrey-1.7.4 Received: from smtp107.sbc.mail.re2.yahoo.com (smtp107.sbc.mail.re2.yahoo.com [68.142.229.98]) by postgresql.org (Postfix) with SMTP id 66D309FB1C4 for ; Sun, 11 Feb 2007 02:04:08 -0400 (AST) Received: (qmail 21751 invoked from network); 11 Feb 2007 06:04:07 -0000 DomainKey-Signature: a=rsa-sha1; q=dns; c=nofws; s=s1024; d=sbcglobal.net; h=Received:X-YMail-OSG:From:To:Subject:Date:Message-ID:MIME-Version:Content-Type:Content-Transfer-Encoding:X-Priority:X-MSMail-Priority:X-Mailer:Importance:In-Reply-To:X-MimeOLE; b=vQafMomSEYY/wzuCGoEnytqT+nN71R/dpGr6RYfBDmHx0PPsQ2kFjJOFBzbQ4+xmddUEV8D4oo3FfTrF5fKrlqIu0eteu6a8vNkDowBhw9ZnmbWjng3IXarB4YpE+ndc+QTjRRcrhbZl024GbSI9wPRrXRoS6x+fKm/mGHVbLvs= ; Received: from unknown (HELO dualcore) (adam.r@sbcglobal.net@75.2.66.252 with login) by smtp107.sbc.mail.re2.yahoo.com with SMTP; 11 Feb 2007 06:04:07 -0000 X-YMail-OSG: S8b__dQVM1lgTD6J.69u5tleY99WY3Yif0ruwpelkhnMknN31jcdifvGetGkv9JR43E5Wj6dYc0snrsew1y137vq0TBpJP3I65voE2UZflSJNEBoRRcsdU6Les8nauvSjs_0ACCL_KrdBC4- From: "Adam Rich" To: "'Benjamin Arai'" , Subject: Re: Priorities for users or queries? Date: Sun, 11 Feb 2007 00:05:42 -0600 Message-ID: <000001c74da2$a9a4a990$6400a8c0@dualcore> MIME-Version: 1.0 Content-Type: text/plain; charset="us-ascii" Content-Transfer-Encoding: 7bit X-Priority: 3 (Normal) X-MSMail-Priority: Normal X-Mailer: Microsoft Outlook, Build 10.0.2627 Importance: Normal In-Reply-To: <45CE69B5.40204@araisoft.com> X-MimeOLE: Produced By Microsoft MimeOLE V6.00.3790.2826 X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=1.919 tagged_above=0 required=5 tests=DNS_FROM_RFC_ABUSE, DNS_FROM_RFC_POST X-Spam-Level: * X-Archive-Number: 200702/502 X-Sequence-Number: 108992 There is a function pg_backend_pid() that will return the PID for the current session. You could call this from your updating app to get a pid to feed to the NICE command. -----Original Message----- From: pgsql-general-owner@postgresql.org [mailto:pgsql-general-owner@postgresql.org] On Behalf Of Benjamin Arai Sent: Saturday, February 10, 2007 6:56 PM To: pgsql-general@postgresql.org; pgsql-admin@postgresql.org Subject: [GENERAL] Priorities for users or queries? 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! Benjamin ---------------------------(end of broadcast)--------------------------- TIP 4: Have you searched our list archives? http://archives.postgresql.org/