[HACKERS] index selection by query planner

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

[HACKERS] query plan ignoring check constraints

Hi   I have created a base table with a column id of type int. This table is inherited by a few subtables each of which have rows which satisfy a range of ids. The ranges are mutually exclusive. For example:   0<=id<1 subtable1 1<=id<2 subtable2 2<=id<3 subtable3 3<=i