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, 7 months ago)

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