Re: Columns correlation and adaptive query optimization

From: Konstantin Knizhnik <k(dot)knizhnik(at)postgrespro(dot)ru>
To: David Steele <david(at)pgmasters(dot)net>, pgsql-hackers(at)postgresql(dot)org
Subject: Re: Columns correlation and adaptive query optimization
Date: 2020-03-25 13:28:34
Views: Raw Message | Whole Thread | Download mbox | Resend email
Lists: pgsql-hackers

On 25.03.2020 16:00, David Steele wrote:
> On 3/25/20 6:57 AM, Konstantin Knizhnik wrote:
>> On 24.03.2020 20:12, David Steele wrote:
>>> On 12/24/19 3:15 AM, Konstantin Knizhnik wrote:
>>>> New version of patch implicitly adding multicolumn statistic in
>>>> auto_explain extension and using it in optimizer for more precise
>>>> estimation of join selectivity.
>>>> This patch fixes race condition while adding statistics and
>>>> restricts generated statistic name to fit in 64 bytes (NameData).
>>> This patch no longer applies:
>>> The CF entry has been updated to Waiting on Autho
>> Rebased patch is attached.
> The patch applies now but there are error on Windows and Linux:
> Regards,

Sorry, yet another patch is attached.

Konstantin Knizhnik
Postgres Professional:
The Russian Postgres Company

Attachment Content-Type Size
auto_explain_create_statistic-5.patch text/x-patch 18.2 KB

In response to


Browse pgsql-hackers by date

  From Date Subject
Next Message Stephen Frost 2020-03-25 13:31:06 Re: backup manifests
Previous Message Fujii Masao 2020-03-25 13:09:37 Re: Planning counters in pg_stat_statements (using pgss_store)