Received: from localhost (maia-4.hub.org [200.46.204.183]) by postgresql.org (Postfix) with ESMTP id DC1B99FB308; Sat, 10 Feb 2007 20:56:25 -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 32840-05; Sat, 10 Feb 2007 20:56:23 -0400 (AST) X-Greylist: delayed 00:07:13.291191 by SQLgrey-1.7.4 X-Greylist: from auto-whitelisted by SQLgrey-1.7.4 Received: from spunkymail-a5.g.dreamhost.com (sd-green-bigip-119.dreamhost.com [208.97.132.119]) by postgresql.org (Postfix) with ESMTP id 2CB3D9FA250; Sat, 10 Feb 2007 20:56:23 -0400 (AST) Received: from benjamin-arais-computer.local (adsl-75-36-67-4.dsl.irvnca.sbcglobal.net [75.36.67.4]) by spunkymail-a5.g.dreamhost.com (Postfix) with ESMTP id 2D4E714D6AA; Sat, 10 Feb 2007 16:56:22 -0800 (PST) Message-ID: <45CE69B5.40204@araisoft.com> Date: Sat, 10 Feb 2007 16:56:21 -0800 From: Benjamin Arai Organization: Araisoft User-Agent: Thunderbird 2.0b2 (Macintosh/20070116) MIME-Version: 1.0 To: pgsql-general@postgresql.org, pgsql-admin@postgresql.org Subject: Priorities for users or queries? 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 tagged_above=0 required=5 tests= X-Spam-Level: X-Archive-Number: 200702/143 X-Sequence-Number: 24608 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