Re: Index non-usage problem in 8.2.9

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