Martijn van Oosterhout <kleptog(at)svana(dot)org> writes:
> So, as far as I can tell, partial indecies would be completely usable, *if*
> I could get the planner to use them. I'm pretty sure it goes wrong in
> create_index_paths. The pred_test works fine but somewhere in the lines
> below it doesn't realise it can use the index.
Offhand I don't see why the existence of a predicate would matter. If
you set enable_seqscan to FALSE, does it start using the index?
regards, tom lane
PS: please don't use // comments in Postgres code. They're unportable.