Re: Using multiple extended statistics for estimates - Mailing list pgsql-hackers

From Mark Dilger
Subject Re: Using multiple extended statistics for estimates
Date
Msg-id 0ff3bd5d-33a7-6283-1a80-91d1df5c988c@gmail.com
Whole thread Raw
In response to Re: Using multiple extended statistics for estimates  (Tomas Vondra <tomas.vondra@2ndquadrant.com>)
Responses Re: Using multiple extended statistics for estimates  (Tomas Vondra <tomas.vondra@2ndquadrant.com>)
List pgsql-hackers

On 12/9/19 2:00 PM, Tomas Vondra wrote:
>>
>> These look good to me.  I added extra tests (not included in this email)
>> to verify the code on more interesting test cases, such as partitioned
>> tables and within joins.  Your test cases are pretty trivial, just being
>> selects from a single table.
>>
> 
> Adding such more complex tests seem like a good idea, maybe you'd like
> to share them?

You can find them attached.  I did not include them in my earlier email
because they seem a bit unrefined, taking too many lines of code for the
amount of coverage they provide.  But you can prune them down and add
them to the patch if you like.

These only test the functional dependencies.  If you want to include
something like them in your commit, you might create similar tests for
the mcv statistics, too.

-- 
Mark Dilger

Attachment

pgsql-hackers by date:

Previous
From: Kyotaro Horiguchi
Date:
Subject: Re: xact_start for walsender & logical decoding not updated
Next
From: Andres Freund
Date:
Subject: A varint implementation for PG?