Joseph S <jks@xxxxxxxxxxxxxxx> 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
