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.