Thread: Fwd: Not Picking Index

Fwd: Not Picking Index

From
Mike Gargano
Date:
> 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
>>
>