Received: from localhost (maia-2.hub.org [200.46.204.187])
	by postgresql.org (Postfix) with ESMTP id 8C0A89FBA1E
	for <pgsql-performance-postgresql.org@postgresql.org>;
	Fri, 16 Feb 2007 10:31:23 -0400 (AST)
Received: from postgresql.org ([200.46.204.71])
	by localhost (mx1.hub.org [200.46.204.187]) (amavisd-new, port 10024)
	with ESMTP id 51094-06 for
	<pgsql-performance-postgresql.org@postgresql.org>;
	Fri, 16 Feb 2007 10:31:14 -0400 (AST)
X-Greylist: domain auto-whitelisted by SQLgrey-1.7.4
Received: from wx-out-0506.google.com (wx-out-0506.google.com [66.249.82.226])
	by postgresql.org (Postfix) with ESMTP id ED72E9FBC88
	for <pgsql-performance@postgresql.org>;
	Fri, 16 Feb 2007 10:31:17 -0400 (AST)
Received: by wx-out-0506.google.com with SMTP id i28so1115274wxd
	for <pgsql-performance@postgresql.org>;
	Fri, 16 Feb 2007 06:31:16 -0800 (PST)
DomainKey-Signature: a=rsa-sha1; c=nofws; d=gmail.com; s=beta;
	h=received:message-id:date:from:to:subject:cc:in-reply-to:mime-version:content-type:references;
	b=hHgX479oisBB13WDA0eYYRVl+rp5inLMTCawzJN94O0ENPGJB6G4snO2FnQEb/bupod44+kwPp00cxefb7rY6hEnc6i4IBxNWHw1X3PzaXsndwZEUZm9Mzi6TD1XFgbxOhWJ8UDS+ABQMKj4KM4e/X6ALUkmEuJ8XMj+szBGkOA=
Received: by 10.90.31.19 with SMTP id e19mr4107618age.1171636276419;
	Fri, 16 Feb 2007 06:31:16 -0800 (PST)
Received: by 10.90.73.13 with HTTP; Fri, 16 Feb 2007 06:31:16 -0800 (PST)
Message-ID: <7e4ba9550702160631j5b428addr199bd87bd0704dc3@mail.gmail.com>
Date: Fri, 16 Feb 2007 20:01:16 +0530
From: "Gauri Kanekar" <meetgaurikanekar@gmail.com>
To: "Michael Fuhr" <mike@fuhr.org>
Subject: Re: Not Picking Index
Cc: pgsql-performance@postgresql.org
In-Reply-To: <20070216142804.GA44536@winnie.fuhr.org>
MIME-Version: 1.0
Content-Type: multipart/alternative;
	boundary="----=_Part_4980_16824683.1171636276379"
References: <7e4ba9550702160456m6e86e809oc35dd68620348c80@mail.gmail.com>
	<20070216142804.GA44536@winnie.fuhr.org>
X-Virus-Scanned: Maia Mailguard 1.0.1
X-Spam-Status: No, hits=0.562 tagged_above=0 required=5 tests=AWL, BAYES_20,
	HTML_40_50, HTML_MESSAGE, SPF_PASS
X-Spam-Level: 
X-Archive-Number: 200702/182
X-Sequence-Number: 23236

------=_Part_4980_16824683.1171636276379
Content-Type: text/plain; charset=ISO-8859-1; format=flowed
Content-Transfer-Encoding: 7bit
Content-Disposition: inline

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.

On 2/16/07, Michael Fuhr <mike@fuhr.org> wrote:

> On Fri, Feb 16, 2007 at 06:26:51PM +0530, Gauri Kanekar wrote:
> > I want to run a Select Query on a table. But i dont want the query to
> pick a
> > index defined on that table.
> >
> > So can i instruct the planner not to pick that index.
>
> Why don't you want the planner to use the index?  Is there a specific
> index you want to ignore or do you want the planner to ignore all
> indexes?  What problem are you trying to solve?
>
> --
> Michael Fuhr
>



-- 
Regards
Gauri

------=_Part_4980_16824683.1171636276379
Content-Type: text/html; charset=ISO-8859-1
Content-Transfer-Encoding: 7bit
Content-Disposition: inline

<div><br>I <span class="gmail_quote">want the planner to ignore a specific index.</span></div>
<div><span class="gmail_quote">I am testing some query output. For that purpose i dont want the index.</span></div>
<div><span class="gmail_quote">I that possible to ignore a index by the planner.</span></div>
<div><span class="gmail_quote"></span>&nbsp;</div>
<div><span class="gmail_quote">On 2/16/07, <b class="gmail_sendername">Michael Fuhr</b> &lt;<a href="mailto:mike@fuhr.org">mike@fuhr.org</a>&gt; wrote:</span></div>
<div>
<blockquote class="gmail_quote" style="PADDING-LEFT: 1ex; MARGIN: 0px 0px 0px 0.8ex; BORDER-LEFT: #ccc 1px solid">On Fri, Feb 16, 2007 at 06:26:51PM +0530, Gauri Kanekar wrote:<br>&gt; I want to run a Select Query on a table. But i dont want the query to pick a
<br>&gt; index defined on that table.<br>&gt;<br>&gt; So can i instruct the planner not to pick that index.<br><br>Why don&#39;t you want the planner to use the index?&nbsp;&nbsp;Is there a specific<br>index you want to ignore or do you want the planner to ignore all
<br>indexes?&nbsp;&nbsp;What problem are you trying to solve?<br><br>--<br>Michael Fuhr<br></blockquote></div><br><br clear="all"><br>-- <br>Regards<br>Gauri 

------=_Part_4980_16824683.1171636276379--