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 533F99F9B01 for ; Thu, 25 May 2006 13:35:40 -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 91664-06 for ; Thu, 25 May 2006 13:35:32 -0300 (ADT) X-Greylist: from auto-whitelisted by SQLgrey- Received: from my.endian.it (unknown [62.146.87.34]) by postgresql.org (Postfix) with ESMTP id 90A349F94EA for ; Thu, 25 May 2006 13:35:30 -0300 (ADT) Received: from dell.home.lan (host45-104.pool875.interbusiness.it [87.5.104.45]) (authenticated (0 bits)) by my.endian.it (8.11.6/8.11.6) with ESMTP id k4PGeCc32685 for ; Thu, 25 May 2006 18:40:12 +0200 Subject: Re: lowering priority automatically at connection From: Chris Mair To: pgsql-performance@postgresql.org In-Reply-To: <13758.1148574403@sss.pgh.pa.us> References: <1148573784.6017.26.camel@dell.home.lan> <13758.1148574403@sss.pgh.pa.us> Content-Type: text/plain Date: Thu, 25 May 2006 18:35:28 +0200 Message-Id: <1148574928.6017.36.camel@dell.home.lan> Mime-Version: 1.0 X-Mailer: Evolution 2.0.2 (2.0.2-27) Content-Transfer-Encoding: 7bit X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200605/466 X-Sequence-Number: 19253 > > I find this very helpful: > > Lowering the priority of a PostgreSQL query > > http://weblog.bignerdranch.com/?p=11 > > That guy doesn't actually have the foggiest idea what he's doing. > The reason there is no built-in capability to do that is that it *does > not work well*. Search the list archives for "priority inversion" to > find out why not. > > regards, tom lane Ok, I've learned something new (*). I'll drop that idea :) Bye, Chris. (*) http://en.wikipedia.org/wiki/Priority_inversion