Re: [HACKERS] index selection by query planner

2005-06-20 Thread 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 orde

[HACKERS] index selection by query planner

2005-06-20 Thread 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 fo