Received: from localhost (maia-1.hub.org [200.46.204.191]) by postgresql.org (Postfix) with ESMTP id 0BB819FB971 for ; Fri, 16 Feb 2007 14:27:54 -0400 (AST) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.191]) (amavisd-new, port 10024) with ESMTP id 51134-04 for ; Fri, 16 Feb 2007 14:27:50 -0400 (AST) X-Greylist: from auto-whitelisted by SQLgrey-1.7.4 Received: from mail.libertyrms.com (vgateway.libertyrms.info [207.219.45.62]) by postgresql.org (Postfix) with ESMTP id 6CF359FB91D for ; Fri, 16 Feb 2007 14:27:48 -0400 (AST) Received: from dba5.int.libertyrms.com ([10.1.3.44]) by mail.libertyrms.com with esmtp (Exim 4.22) id 1HI7oA-0002dy-Lt; Fri, 16 Feb 2007 13:27:46 -0500 Subject: Re: Not Picking Index From: Brad Nicholson To: Gauri Kanekar Cc: Michael Fuhr , pgsql-performance@postgresql.org In-Reply-To: <7e4ba9550702160631j5b428addr199bd87bd0704dc3@mail.gmail.com> References: <7e4ba9550702160456m6e86e809oc35dd68620348c80@mail.gmail.com> <20070216142804.GA44536@winnie.fuhr.org> <7e4ba9550702160631j5b428addr199bd87bd0704dc3@mail.gmail.com> Content-Type: text/plain Date: Fri, 16 Feb 2007 13:27:46 -0500 Message-Id: <1171650466.25466.10.camel@dba5.int.libertyrms.com> Mime-Version: 1.0 X-Mailer: Evolution 2.8.1 Content-Transfer-Encoding: 7bit X-SA-Exim-Mail-From: bnichols@ca.afilias.info X-SA-Exim-Scanned: No; SAEximRunCond expanded to false X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=0.839 tagged_above=0 required=5 tests=AWL, BAYES_50, FORGED_RCVD_HELO X-Spam-Level: X-Archive-Number: 200702/186 X-Sequence-Number: 23240 On Fri, 2007-02-16 at 20:01 +0530, Gauri Kanekar wrote: > > I want the planner to ignore a specific index. > I am testing some query output. For that purpose i dont want the > index. > I that possible to ignore a index by the planner. If the indexed field is an intger, add 0 to it. -- Brad Nicholson 416-673-4106 Database Administrator, Afilias Canada Corp.