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
