Re: Fix var_eq_const: sum selectivity of all matching MCV entries instead of stopping at first match

[Ilia Evdokimov]

Even with statistics_target set to its maximum 10 000, merging the two 
loops would not bring  much benefit. So I agree with that from the start 
- my earlier change does not really add much value.

The examples so far only show a single Seq Scan, where the more accurate 
estimate does not change the plan. Could we see a case where the 
corrected MCV sum actually changes the chosen plan rather than just the 
row estimate?

--
Best regards,
Ilia Evdokimov,
Tantor Labs LLC,
https://tantorlabs.com/