greigwise <greigwise@xxxxxxxxxxx> writes: > Granted it cannot skip the condition, but that doesn't mean that it has to > use that second index. It's doing a recheck on the conditions anyway, > right? I'm afraid you're out of luck on that for now. In principle, the presence of extended stats on the column combination might allow the planner to figure out that the second IN condition adds little selectivity. But I'm not sure how hard it would be, and I am sure that the extended-stats logic hasn't been built out in that direction yet. regards, tom lane
