Re: Not Picking Index - Mailing list pgsql-performance

From Alvaro Herrera
Subject Re: Not Picking Index
Date
Msg-id 20070216144639.GG13241@alvh.no-ip.org
Whole thread Raw
In response to Re: Not Picking Index  ("Gauri Kanekar" <meetgaurikanekar@gmail.com>)
List pgsql-performance
Gauri Kanekar escribió:
> 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.

Sure:

BEGIN
DROP INDEX foo
SELECT ....
ROLLBACK

--
Alvaro Herrera                                http://www.CommandPrompt.com/
The PostgreSQL Company - Command Prompt, Inc.

pgsql-performance by date:

Previous
From: "Gauri Kanekar"
Date:
Subject: Re: Not Picking Index
Next
From: Tom Lane
Date:
Subject: Re: Not Picking Index