Re: BitmapAnd on correlated column?

greigwise <greigwise@comcast.net> 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