This is very similar to the problem I posted to this list
yesterday. Apparently, if you append an empty string to the column
data in your WHERE clause it will force the planer to treat it as a
filter and not an index cond. It's extremely ugly, but this method
doesn't seem to be anymore elegant.
-Mike
On Feb 16, 2007, at 9:46 AM, Alvaro Herrera wrote:
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.
---------------------------(end of
broadcast)---------------------------
TIP 6: explain analyze is your friend
