>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