Hybrid Hash/Nested Loop joins and caching results from subplans

Edit

Title

Topic

Performance

Created

2020-05-25 06:56:19

Last modified

2021-04-02 22:21:10 (3 years, 5 months ago)

Latest email

2021-04-02 01:15:40 (3 years, 5 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

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