Re: [PERFORM] partial indexes and inference

I suspect you've found an issue with how the planner evaluates indexes for bitmap scans. My guess is that that section of the planner needs to be taught to look for partial indexes. You should also try cast(value as bigint) = 1009 The planner may be getting confused by the '1009'. On Mon, Mar 2

[PERFORM] partial indexes and inference

I have a case where it seems the planner should be able to infer more from its partial indexes than it is doing. Observe: px=# select version(); version PostgreSQL 8.1.3 on i686-pc-linux-gnu