Joseph S <jks@selectacast.net> writes:
> Tom Lane wrote:
>> Can you force it to use the partial index by dropping the other index?
>> (Use begin; drop index ...; explain ...; rollback; to avoid dropping
>> the index for real.) It's quite unclear at this point whether it
> I tried, and it ends up using a seqscan.
Just to be sure, what if you set enable_seqscan = off?
If still not, then there must be something about the table or index
declaration that you didn't tell us. In the past, issues like use of
a domain instead of a bare datatype have been relevant ...
regards, tom lane