Re: [HACKERS] index selection by query planner

[Josh Berkus]

Rohit,

> I have a table with two indices on the same column, one of which is a
> partial index. I would like the query planner to use the partial index
> whenever the query condition lies in the range of the partial index as it
> would yield better performance. Is there any way to enforce the ordering
> for the indices? How does the query planner decide which index to use when
> a particular query is fired?  'Explain Analyze' showed the total index
> being used in a situation that could be fulfiled by the partial index.

Please post the query, the table and index definitions, and the EXPLAIN 
ANALYZE to the PGSQL-PERFORMANCE mailing list.  Thanks!

-- 
Josh Berkus
Aglio Database Solutions
San Francisco

---(end of broadcast)---
TIP 4: Don't 'kill -9' the postmaster

[HACKERS] index selection by query planner

[Rohit Gaddi]

Hi,
 
I have a table with two indices on the same column, one of which is a partial index. I would like the query planner to use the partial index whenever the query condition lies in the range of the partial index as it would yield better performance. Is there any way to enforce the ordering for the indices? How does the query planner decide which index to use when a particular query is fired?  'Explain Analyze' showed the total index being used in a situation that could be fulfiled by the partial index.
 
Thanks,
Rohit
		 
Free antispam, antivirus and 1GB to save all your messages 
Only in Yahoo! Mail: http://in.mail.yahoo.com