Re: Not Picking Index - Mailing list pgsql-performance

From Brad Nicholson
Subject Re: Not Picking Index
Date
Msg-id 1171650466.25466.10.camel@dba5.int.libertyrms.com
Whole thread Raw
In response to Re: Not Picking Index  ("Gauri Kanekar" <meetgaurikanekar@gmail.com>)
Responses Re: Not Picking Index  ("Steinar H. Gunderson" <sgunderson@bigfoot.com>)
List pgsql-performance
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.


pgsql-performance by date:

Previous
From: Mike Gargano
Date:
Subject: Fwd: Not Picking Index
Next
From: "Guillaume Smet"
Date:
Subject: Re: Proximity query with GIST and row estimation