Using multicolumn statistics for more precise join selectivity estimatation

Edit
Comment/Review
Change Status
ID 2386
Title Using multicolumn statistics for more precise join selectivity estimatation
Topic Performance
Created 2019-12-24 08:17:49
Last modified 2021-10-01 07:13:26 (3 years, 1 month ago)
Latest email 2021-11-04 09:56:54 (3 years ago)
Status
2021-09: Returned with feedback
2021-07: Moved to next CF
2021-03: Moved to next CF
2021-01: Moved to next CF
2020-11: Moved to next CF
2020-09: Moved to next CF
2020-07: Moved to next CF
2020-03: Moved to next CF
2020-01: Moved to next CF
Target version
Authors Konstantin Knizhnik (knizhnik)
Reviewers Yugo Nagata (yugo.nagata)Become reviewer
Committer
Links CFbot results (CirrusCI) CFbot GitHub Git
Checkout latest CFbot patchset Go to your local checkout of the PostgreSQL repository and run: 
git remote add commitfest https://github.com/postgresql-cfbot/postgresql.git
git fetch commitfest cf/2386
git checkout commitfest/cf/2386
Emails
Columns correlation and adaptive query optimization
First at 2019-10-14 16:43:10 by Konstantin Knizhnik <k.knizhnik at postgrespro.ru>
Latest at 2021-11-04 09:56:54 by Daniel Gustafsson <daniel at yesql.se>
Latest attachment (auto_explain_create_statistic-9.patch) at 2021-03-19 16:58:27 from Konstantin Knizhnik <k.knizhnik at postgrespro.ru>
    Attachment (auto_explain_create_statistic-9.patch) at 2021-03-19 16:58:27 from Konstantin Knizhnik <k.knizhnik at postgrespro.ru> (Patch: Yes)
    Attachment (auto_explain_create_statistic-8.patch) at 2021-01-27 16:39:00 from Konstantin Knizhnik <k.knizhnik at postgrespro.ru> (Patch: Yes)
    Attachment (auto_explain_create_statistic-7.patch) at 2021-01-25 13:27:25 from Konstantin Knizhnik <k.knizhnik at postgrespro.ru> (Patch: Yes)
    Attachment (auto_explain_create_statistic-6.patch) at 2020-03-26 15:49:51 from Konstantin Knizhnik <k.knizhnik at postgrespro.ru> (Patch: Yes)
    Attachment (auto_explain_create_statistic-5.patch) at 2020-03-25 13:28:34 from Konstantin Knizhnik <k.knizhnik at postgrespro.ru> (Patch: Yes)
    Attachment (auto_explain_create_statistic-4.patch) at 2020-03-25 10:57:53 from Konstantin Knizhnik <k.knizhnik at postgrespro.ru> (Patch: Yes)
    Attachment (auto_explain_create_statistic-3.patch) at 2019-12-24 08:15:40 from Konstantin Knizhnik <k.knizhnik at postgrespro.ru> (Patch: Yes)
    Attachment (auto_explain_create_statistics.patch) at 2019-10-18 16:53:23 from Konstantin Knizhnik <k.knizhnik at postgrespro.ru> (Patch: Yes)
    Attachment (join_selectivity.patch) at 2019-10-15 07:46:38 from Konstantin Knizhnik <k.knizhnik at postgrespro.ru> (Patch: Yes)
    Attachment (join_selectivity.patch) at 2019-10-14 16:43:10 from Konstantin Knizhnik <k.knizhnik at postgrespro.ru> (Patch: Yes)
History
When Who What
2021-10-01 07:13:26 Michael Paquier (michael-kun) Closed in commitfest 2021-09 with status: Returned with feedback
2021-08-03 02:26:51 Masahiko Sawada (masahikosawada) Closed in commitfest 2021-07 with status: Moved to next CF
2021-04-08 15:41:35 David Steele (dsteele) Closed in commitfest 2021-03 with status: Moved to next CF
2021-02-01 12:33:11 Masahiko Sawada (masahikosawada) Closed in commitfest 2021-01 with status: Moved to next CF
2021-01-28 09:38:42 Yugo Nagata (yugo.nagata) New status: Needs review
2021-01-21 14:41:52 Yugo Nagata (yugo.nagata) New status: Waiting on Author
2021-01-21 14:41:34 Yugo Nagata (yugo.nagata) Added yugo.nagata as reviewer
2020-11-30 14:03:07 Anastasia Lubennikova (lubennikovaav) Closed in commitfest 2020-11 with status: Moved to next CF
2020-10-01 04:32:55 Michael Paquier (michael-kun) Closed in commitfest 2020-09 with status: Moved to next CF
2020-08-03 09:14:36 Daniel Gustafsson (d_gustafsson) Closed in commitfest 2020-07 with status: Moved to next CF
2020-04-08 15:31:11 David Steele (dsteele) Closed in commitfest 2020-03 with status: Moved to next CF
2020-03-25 18:08:51 David Steele (dsteele) New status: Needs review
2020-03-24 17:12:59 David Steele (dsteele) New status: Waiting on Author
2020-02-01 12:51:52 Tomas Vondra (fuzzycz) Closed in commitfest 2020-01 with status: Moved to next CF
2019-12-24 08:19:53 Konstantin Knizhnik (knizhnik) Changed authors to Konstantin Knizhnik (knizhnik)
2019-12-24 08:19:53 Konstantin Knizhnik (knizhnik) Changed gitlink to https://github.com/postgrespro/postgresql.builtin_pool/tree/auto_explain_extended_stats
2019-12-24 08:17:49 Konstantin Knizhnik (knizhnik) Attached mail thread 196f1e1a-5464-ed07-ab3c-0c9920564af7@postgrespro.ru
2019-12-24 08:17:49 Konstantin Knizhnik (knizhnik) Created patch record
Edit
Comment/Review
Change Status