Re: Not Picking Index

From: Brad Nicholson <bnichols(at)ca(dot)afilias(dot)info>
To: Gauri Kanekar <meetgaurikanekar(at)gmail(dot)com>
Cc: Michael Fuhr <mike(at)fuhr(dot)org>, pgsql-performance(at)postgresql(dot)org
Subject: Re: Not Picking Index
Date: 2007-02-16 18:27:46
Message-ID: 1171650466.25466.10.camel@dba5.int.libertyrms.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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.

In response to

Responses

Browse pgsql-performance by date

  From Date Subject
Next Message Guillaume Smet 2007-02-16 18:31:45 Re: Proximity query with GIST and row estimation
Previous Message Mike Gargano 2007-02-16 16:06:57 Fwd: Not Picking Index