Re: BitmapAnd on correlated column?

>Extended statistics will tell PostgreSQL that it is very unlikely
>that the first condition will contribute significantly, but that
>is no proof that the condition can be omitted, so the optimizer
>cannot just skip the condition.

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?

Thanks.
Greig



--
Sent from: https://www.postgresql-archive.org/PostgreSQL-general-f1843780.html