Hybrid Hash/Nested Loop joins and caching results from subplans

Edit
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 (2 years, 11 months ago)
Latest email 2021-04-02 01:15:40 (2 years, 11 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
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