>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
