From: | Tomas Vondra <tomas(dot)vondra(at)2ndquadrant(dot)com> |
---|---|
To: | Mark Dilger <hornschnorter(at)gmail(dot)com> |
Cc: | PostgreSQL Hackers <pgsql-hackers(at)postgresql(dot)org> |
Subject: | Re: Using multiple extended statistics for estimates |
Date: | 2019-12-05 17:51:45 |
Message-ID: | 20191205175145.vlqw6c6h2ztiimy2@development |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-hackers |
On Thu, Dec 05, 2019 at 06:15:54PM +0100, Tomas Vondra wrote:
>On Sun, Dec 01, 2019 at 08:08:58PM +0100, Tomas Vondra wrote:
>>On Sat, Nov 30, 2019 at 03:01:31PM -0800, Mark Dilger wrote:
>>>
>>>Are you planning to submit a revised patch for this?
>>>
>>
>>Yes, I'll submit a rebased version of this patch shortly. I got broken
>>because of the recent fix in choose_best_statistics, shouldn't take long
>>to update the patch. I do have a couple more related patches in the
>>queue, so I want to submit them all at once.
>>
>
>OK, here we go - these two patched allow applying multiple extended
>statistics, both for MCV and functional dependencies. Functional
>dependencies are simply merged and then applied at once (so withouth
>choose_best_statistics), statistics are considered in greedy manner by
>calling choose_best_statistics in a loop.
>
OK, this time with the patches actually attached ;-)
regards
--
Tomas Vondra http://www.2ndQuadrant.com
PostgreSQL Development, 24x7 Support, Remote DBA, Training & Services
Attachment | Content-Type | Size |
---|---|---|
0001-Apply-multiple-multivariate-MCV-lists-when--20191205.patch | text/plain | 11.5 KB |
0002-Apply-all-available-functional-dependencies-20191205.patch | text/plain | 10.5 KB |
From | Date | Subject | |
---|---|---|---|
Next Message | Andres Freund | 2019-12-05 18:03:25 | Re: log bind parameter values on error |
Previous Message | Alvaro Herrera | 2019-12-05 17:19:45 | Re: log bind parameter values on error |