Horton

Re: Additional improvements to extended statistics

Daniel Gustafsson <daniel@yesql.se>

View thread View on postgr.es
From: Daniel Gustafsson <daniel@yesql.se>
To: Tomas Vondra <tomas.vondra@2ndquadrant.com>
Cc: Dean Rasheed <dean.a.rasheed@gmail.com>, PostgreSQL Hackers <pgsql-hackers@postgresql.org>
Date: 2020-07-01T11:19:40Z
Lists: pgsql-hackers 
> On 24 Mar 2020, at 15:33, Tomas Vondra <tomas.vondra@2ndquadrant.com> wrote:
> 
> On Tue, Mar 24, 2020 at 01:20:07PM +0000, Dean Rasheed wrote:

>> Sounds like a reasonable approach, but I think it would be better to
>> preserve the current public API by having clauselist_selectivity()
>> become a thin wrapper around  a new function that optionally applies
>> extended stats.
>> 
> 
> OK, makes sense. I'll take a stab at it.

Have you had time to hack on this?  The proposed patch no longer applies, so
I've marked the entry Waiting on Author.

cheers ./daniel

Commits

  1. Improve estimation of ANDs under ORs using extended statistics.

  2. Improve estimation of OR clauses using multiple extended statistics.

  3. Improve estimation of OR clauses using extended statistics.

  4. Prevent functional dependency estimates from exceeding column estimates.

  5. Fix wording of several extended stats comments

  6. Improve test coverage for multi-column MCV lists

  7. Improve test coverage for functional dependencies