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

Fwd: Not Picking Index

From: Mike Gargano <mrg(at)infoplusonline(dot)com>
To: pgsql-performance(at)postgresql(dot)org
Subject: Fwd: Not Picking Index
Date: 2007-02-16 16:06:57
Message-ID: 5460DD6A-032C-46EA-AC21-034B6FE02353@infoplusonline.com (view raw or flat)
Thread:
Lists: pgsql-performance
> 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
>>
>


pgsql-performance by date

Next:From: Brad NicholsonDate: 2007-02-16 18:27:46
Subject: Re: Not Picking Index
Previous:From: Tom LaneDate: 2007-02-16 14:53:45
Subject: Re: Not Picking Index

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