X-Original-To: pgsql-performance-postgresql.org@localhost.postgresql.org Received: from localhost (mx1.hub.org [200.46.208.251]) by postgresql.org (Postfix) with ESMTP id A01209F9B01 for ; Thu, 25 May 2006 13:55:15 -0300 (ADT) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.208.251]) (amavisd-new, port 10024) with ESMTP id 90934-09 for ; Thu, 25 May 2006 13:55:06 -0300 (ADT) X-Greylist: from auto-whitelisted by SQLgrey- Received: from tigger.fuhr.org (tigger.fuhr.org [63.214.45.158]) by postgresql.org (Postfix) with ESMTP id 33F799F94EA for ; Thu, 25 May 2006 13:55:05 -0300 (ADT) Received: from winnie.fuhr.org (winnie.fuhr.org [10.1.0.1]) by tigger.fuhr.org (8.13.3/8.13.3) with ESMTP id k4PGsu56016456 (version=TLSv1/SSLv3 cipher=DHE-RSA-AES256-SHA bits=256 verify=OK); Thu, 25 May 2006 10:54:59 -0600 (MDT) (envelope-from mfuhr@winnie.fuhr.org) Received: from winnie.fuhr.org (localhost [127.0.0.1]) by winnie.fuhr.org (8.13.6/8.13.6) with ESMTP id k4PGsuJv070356; Thu, 25 May 2006 10:54:56 -0600 (MDT) (envelope-from mfuhr@winnie.fuhr.org) Received: (from mfuhr@localhost) by winnie.fuhr.org (8.13.6/8.13.6/Submit) id k4PGsuJk070355; Thu, 25 May 2006 10:54:56 -0600 (MDT) (envelope-from mfuhr) Date: Thu, 25 May 2006 10:54:56 -0600 From: Michael Fuhr To: Chris Mair Cc: pgsql-performance@postgresql.org Subject: Re: lowering priority automatically at connection Message-ID: <20060525165456.GA70276@winnie.fuhr.org> References: <1148573784.6017.26.camel@dell.home.lan> Mime-Version: 1.0 Content-Type: text/plain; charset=us-ascii Content-Disposition: inline In-Reply-To: <1148573784.6017.26.camel@dell.home.lan> X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200605/468 X-Sequence-Number: 19255 On Thu, May 25, 2006 at 06:16:24PM +0200, Chris Mair wrote: > I find this very helpful: > > Lowering the priority of a PostgreSQL query > http://weblog.bignerdranch.com/?p=11 > > Now I was wondering whether one could have a > SELECT pg_setpriority(10); > executed automatically each time a certain user > connects (not necessarily using psql)? Beware that setting priorities can have unintended, adverse effects. Use a search engine to find information about "priority inversion" before deciding that query priorities are a good idea. -- Michael Fuhr