Hybrid Hash/Nested Loop joins and caching results from subplans

Edit
ID 2569
Title Hybrid Hash/Nested Loop joins and caching results from subplans
Topic Performance
Created 2020-05-25 06:56:19
Last modified 2021-04-02 22:21:10 (3 years, 8 months ago)
Latest email 2021-04-02 01:15:40 (3 years, 8 months ago)
Status
2021-03: Committed
2021-01: Moved to next CF
2020-11: Moved to next CF
2020-09: Moved to next CF
2020-07: Moved to next CF
Target version 14
Authors David Rowley (davidrowley)
Reviewers Andy Fan (andyf)Become reviewer
Committer David Rowley (davidrowley)
Links CFbot results (CirrusCI) CFbot GitHub
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/2569
git checkout commitfest/cf/2569
Emails
Hybrid Hash/Nested Loop joins and caching results from subplans
First at 2020-05-20 11:44:27 by David Rowley <dgrowleyml at gmail.com>
Latest at 2021-04-02 01:15:40 by David Rowley <dgrowleyml at gmail.com>
Latest attachment (v20-0001-Add-Result-Cache-executor-node.patch) at 2021-04-01 10:23:05 from David Rowley <dgrowleyml at gmail.com>
    Attachment (v20-0001-Add-Result-Cache-executor-node.patch) at 2021-04-01 10:23:05 from David Rowley <dgrowleyml at gmail.com> (Patch: No)
    Attachment (v19-0001-Add-Result-Cache-executor-node.patch) at 2021-03-30 11:42:14 from David Rowley <dgrowleyml at gmail.com> (Patch: No)
    Attachment (v18-0001-Allow-estimate_num_groups-to-pass-back-further-d.patch) at 2021-03-29 02:20:36 from David Rowley <dgrowleyml at gmail.com> (Patch: Yes)
    Attachment (v17-0001-Cache-PathTarget-and-RestrictInfo-s-volatility.patch) at 2021-03-23 11:42:18 from David Rowley <dgrowleyml at gmail.com> (Patch: Yes)
    Attachment (v16-0001-Cache-PathTarget-and-RestrictInfo-s-volatility.patch) at 2021-03-15 10:57:45 from David Rowley <dgrowleyml at gmail.com> (Patch: Yes)
    Attachment (v15-0001-Cache-PathTarget-and-RestrictInfo-s-volatility.patch) at 2021-03-12 01:49:29 from David Rowley <dgrowleyml at gmail.com> (Patch: Yes)
    Attachment (v14-0001-Allow-estimate_num_groups-to-pass-back-further-d.patch) at 2021-03-10 23:17:55 from David Rowley <dgrowleyml at gmail.com> (Patch: Yes)
    Attachment (0001-fix.patch) at 2021-02-21 10:11:39 from Andy Fan <zhihui.fan1213 at gmail.com> (Patch: Yes)
    Attachment (v14-0001-Allow-estimate_num_groups-to-pass-back-further-d.patch) at 2021-02-16 10:15:51 from David Rowley <dgrowleyml at gmail.com> (Patch: Yes)
    Attachment (v13-0001-Allow-estimate_num_groups-to-pass-back-further-d.patch) at 2021-02-03 06:51:53 from David Rowley <dgrowleyml at gmail.com> (Patch: Yes)
    Attachment (0001-Allow-estimate_num_groups-to-pass-back-further-detai.patch) at 2021-01-28 05:43:50 from Justin Pryzby <pryzby at telsasoft.com> (Patch: Yes)
    Attachment (join.sql) at 2020-12-10 16:44:03 from Konstantin Knizhnik <k.knizhnik at postgrespro.ru> (Patch: No)
    Attachment (v12-0001-Allow-estimate_num_groups-to-pass-back-further-d.patch) at 2020-12-08 07:15:52 from David Rowley <dgrowleyml at gmail.com> (Patch: Yes)
    Attachment (v10-0003-Add-Result-Cache-executor-node.patch) at 2020-12-04 14:41:21 from David Rowley <dgrowleyml at gmail.com> (Patch: No)
    Attachment (resultcachebench3.sh.txt) at 2020-11-12 02:36:18 from David Rowley <dgrowleyml at gmail.com> (Patch: No)
    Attachment (resultcache_master_v8_vs_v9_big.txt) at 2020-11-09 21:38:41 from David Rowley <dgrowleyml at gmail.com> (Patch: No)
    Attachment (resultcachebench2.sh.txt) at 2020-11-09 02:07:34 from David Rowley <dgrowleyml at gmail.com> (Patch: No)
    Attachment (resultcache_basic_deforming.png) at 2020-11-02 07:43:54 from David Rowley <dgrowleyml at gmail.com> (Patch: No)
    Attachment (v9-0001-Allow-estimate_num_groups-to-pass-back-further-de.patch) at 2020-10-20 09:30:55 from David Rowley <dgrowleyml at gmail.com> (Patch: Yes)
    Attachment (v8-0001-Allow-estimate_num_groups-to-pass-back-further-de.patch) at 2020-09-15 00:58:40 from David Rowley <dgrowleyml at gmail.com> (Patch: Yes)
    Attachment (resultcache_in_nestloop_hacks_v3.patch.txt) at 2020-09-02 04:02:54 from David Rowley <dgrowleyml at gmail.com> (Patch: Yes)
    Attachment (resultcache_in_nestloop_hacks.patch.txt) at 2020-08-28 14:54:58 from David Rowley <dgrowleyml at gmail.com> (Patch: Yes)
    Attachment (v7-0001-Allow-estimate_num_groups-to-pass-back-further-de.patch) at 2020-08-19 02:45:55 from David Rowley <dgrowleyml at gmail.com> (Patch: Yes)
    Attachment (v6-0002-Allow-users-of-simplehash.h-to-perform-direct-del.patch) at 2020-08-03 22:05:25 from David Rowley <dgrowleyml at gmail.com> (Patch: Yes)
    Attachment (v5-0001-Allow-estimate_num_groups-to-pass-back-further-de.patch) at 2020-07-08 03:37:09 from David Rowley <dgrowleyml at gmail.com> (Patch: Yes)
    Attachment (resultcachebench.txt) at 2020-07-07 12:32:22 from David Rowley <dgrowleyml at gmail.com> (Patch: No)
    Attachment (v2-0001-Allow-estimate_num_groups-to-pass-back-further-de.patch) at 2020-07-02 10:57:44 from David Rowley <dgrowleyml at gmail.com> (Patch: Yes)
    Attachment (patched.log) at 2020-06-02 09:04:50 from Andy Fan <zhihui.fan1213 at gmail.com> (Patch: No)
    Attachment (resultcache_2020-05-20.patch.bz2) at 2020-05-20 11:44:27 from David Rowley <dgrowleyml at gmail.com> (Patch: No)
History
When Who What
2021-04-02 22:21:10 David Rowley (davidrowley) Closed in commitfest 2021-03 with status: Committed
2021-04-01 08:12:24 David Rowley (davidrowley) New status: Ready for Committer
2021-03-31 23:35:01 David Rowley (davidrowley) Closed in commitfest 2021-03 with status: Committed
2021-03-31 23:35:01 David Rowley (davidrowley) Changed committer to davidrowley
2021-03-24 07:01:12 Justin Pryzby (justinpryzby) New status: Ready for Committer
2021-03-23 20:22:45 David Rowley (davidrowley) New status: Needs review
2021-03-04 11:29:32 Ibrar Ahmed (ibrar) New status: Waiting on Author
2021-02-01 12:54:06 Masahiko Sawada (masahikosawada) Closed in commitfest 2021-01 with status: Moved to next CF
2021-01-14 07:30:17 Andy Fan (andyf) New status: Ready for Committer
2020-12-01 11:01:02 Anastasia Lubennikova (lubennikovaav) Closed in commitfest 2020-11 with status: Moved to next CF
2020-10-01 04:27:36 Michael Paquier (michael-kun) Closed in commitfest 2020-09 with status: Moved to next CF
2020-08-02 21:14:58 David Rowley (davidrowley) Closed in commitfest 2020-07 with status: Moved to next CF
2020-06-12 01:05:37 Andy Fan (andyf) Added andyf as reviewer
2020-05-25 06:56:38 David Rowley (davidrowley) Changed authors to David Rowley (davidrowley)
2020-05-25 06:56:38 David Rowley (davidrowley) Changed targetversion to 14
2020-05-25 06:56:19 David Rowley (davidrowley) Attached mail thread CAApHDvrPcQyQdWERGYWx8J+2DLUNgXu+fOSbQ1UscxrunyXyrQ@mail.gmail.com
2020-05-25 06:56:19 David Rowley (davidrowley) Created patch record
Edit