Re: [PATCH] Partial indicies almost working (I think)

Martijn van Oosterhout <kleptog@svana.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.