Skip site navigation (1) Skip section navigation (2)

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: (view raw, whole thread or download thread mbox)
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


pgsql-performance by date

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

Privacy Policy | About PostgreSQL
Copyright © 1996-2017 The PostgreSQL Global Development Group