On Sun, Apr 1, 2018 at 06:07:55PM +0200, Tomas Vondra wrote:
> Hi,
>
> The attached patch version modifies how the non-MCV selectivity is
> computed, along the lines explained in the previous message.
>
> The comments in statext_clauselist_selectivity() explain it in far more
> detail, but we this:
Uh, where are we on this patch? It isn't going to make it into PG 11?
Feature development for this has been going on for years. I thought
when Dean Rasheed got involved that it would be applied for this
release.
I realize this is a complex feature, but I think it will solve 80-90% of
optimizer complaints, and I don't see any other way to fix them than
this. This seems like the right way to fix optimizer problems, instead
of optimizer hints.
--
Bruce Momjian <bruce@momjian.us> http://momjian.us
EnterpriseDB http://enterprisedb.com
+ As you are, so once was I. As I am, so you will be. +
+ Ancient Roman grave inscription +