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