Re: Columns correlation and adaptive query optimization
Konstantin Knizhnik <k.knizhnik@postgrespro.ru>
From: Konstantin Knizhnik <k.knizhnik@postgrespro.ru>
To: David Steele <david@pgmasters.net>, pgsql-hackers@postgresql.org
Date: 2020-03-25T13:28:34Z
Lists: pgsql-hackers
Attachments
- auto_explain_create_statistic-5.patch (text/x-patch) patch
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: >>> https://commitfest.postgresql.org/27/2386/ >>> >>> 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: > https://ci.appveyor.com/project/postgresql-cfbot/postgresql/build/1.0.85481 > > https://travis-ci.org/postgresql-cfbot/postgresql/builds/666729979 > > Regards, Sorry, yet another patch is attached. -- Konstantin Knizhnik Postgres Professional: http://www.postgrespro.com The Russian Postgres Company