Hashjoin fall back to block nested hashloop join

Edit

ID 2588

Title Hashjoin fall back to block nested hashloop join

Topic Performance

Created 2020-06-09 20:37:18

Last modified 2020-11-10 21:44:17 (4 years ago)

Latest email 2020-09-24 03:39:46 (4 years, 1 month ago)

Status

2020-11: Withdrawn

2020-09: Moved to next CF

2020-07: Moved to next CF

Target version 14

Authors Melanie Plageman (melanieplageman), Soumyadeep Chakraborty (soumyadeep2007), Jesse Zhang (essej), David Kimura (dgkimura)

Reviewers Thomas Munro (macdice)Become reviewer

Committer

Links CFbot results (CirrusCI) CFbot GitHub Wiki 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/2588
git checkout commitfest/cf/2588

Emails

Avoiding hash join batch explosions with extreme skew and weird stats: First at 2019-05-16 01:22:31 by Thomas Munro <thomas.munro at gmail.com>
Latest at 2020-09-24 03:39:46 by Michael Paquier <michael at paquier.xyz>
Latest attachment (v11-0001-Implement-Adaptive-Hashjoin.patch) at 2020-08-31 22:13:06 from Melanie Plageman <melanieplageman at gmail.com>
    Attachment (v11-0001-Implement-Adaptive-Hashjoin.patch) at 2020-08-31 22:13:06 from Melanie Plageman <melanieplageman at gmail.com> (Patch: No)
    Attachment (v10-0001-Implement-Adaptive-Hashjoin.patch) at 2020-06-25 22:09:44 from Melanie Plageman <melanieplageman at gmail.com> (Patch: No)
    Attachment (v9-0001-Implement-Adaptive-Hashjoin.patch) at 2020-06-09 00:12:25 from Melanie Plageman <melanieplageman at gmail.com> (Patch: No)
    Attachment (v8-0001-Implement-Adaptive-Hashjoin.patch) at 2020-05-28 02:25:50 from Melanie Plageman <melanieplageman at gmail.com> (Patch: No)
    Attachment (v7-0002-Provisionally-detach-unless-last-worker.patch) at 2020-05-09 01:58:10 from Melanie Plageman <melanieplageman at gmail.com> (Patch: Yes)
    Attachment (v6-0002-Implement-fallback-of-batch-0-for-serial-adaptive.patch) at 2020-05-04 20:39:36 from David Kimura <david.g.kimura at gmail.com> (Patch: Yes)
    Attachment (v1-0001-Describe-hybrid-hash-join-implementation.patch) at 2020-04-30 14:30:35 from Melanie Plageman <melanieplageman at gmail.com> (Patch: Yes)
    Attachment (v6-0002-Implement-fallback-of-batch-0-for-serial-adaptive.patch) at 2020-04-29 23:44:53 from David Kimura <david.g.kimura at gmail.com> (Patch: Yes)
    Attachment (v6-0001-Implement-Adaptive-Hashjoin.patch) at 2020-04-29 02:03:53 from Melanie Plageman <melanieplageman at gmail.com> (Patch: No)
    Attachment (v5-0002-Fixup-tupleMetadata-struct-issues.patch) at 2020-02-12 00:57:05 from Melanie Plageman <melanieplageman at gmail.com> (Patch: Yes)
    Attachment (v4-0002-Fixup-tupleMetadata-struct-issues.patch) at 2020-01-25 02:22:30 from Melanie Plageman <melanieplageman at gmail.com> (Patch: Yes)
    Attachment (v3-0001-hashloop-fallback.patch) at 2019-12-30 03:34:02 from Melanie Plageman <melanieplageman at gmail.com> (Patch: No)
    Attachment (v3-0001-hashloop-fallback.patch) at 2019-07-30 18:46:59 from Melanie Plageman <melanieplageman at gmail.com> (Patch: Yes)
    Attachment (v2-0001-hashloop-fallback.patch) at 2019-07-03 21:22:09 from Melanie Plageman <melanieplageman at gmail.com> (Patch: Yes)
    Attachment (v1-0001-hashloop-fallback.patch) at 2019-06-18 22:24:08 from Melanie Plageman <melanieplageman at gmail.com> (Patch: Yes)
    Attachment (fix.patch) at 2019-05-16 01:22:31 from Thomas Munro <thomas.munro at gmail.com> (Patch: Yes)

History

When	Who	What
2020-11-10 21:44:17	Melanie Plageman (melanieplageman)	Closed in commitfest 2020-11 with status: Withdrawn
2020-09-30 06:55:35	Michael Paquier (michael-kun)	New status: Waiting on Author
2020-09-30 06:55:27	Michael Paquier (michael-kun)	Closed in commitfest 2020-09 with status: Moved to next CF
2020-09-30 06:55:23	Michael Paquier (michael-kun)	New status: Needs review
2020-09-24 03:38:27	Michael Paquier (michael-kun)	New status: Waiting on Author
2020-08-31 22:55:13	Melanie Plageman (melanieplageman)	Changed authors to Melanie Plageman (melanieplageman), Soumyadeep Chakraborty (soumyadeep2007), Jesse Zhang (essej), David Kimura (dgkimura)
2020-08-31 22:55:13	Melanie Plageman (melanieplageman)	Changed gitlink to https://github.com/melanieplageman/postgres/tree/AHJ_v11
2020-08-02 22:45:05	Daniel Gustafsson (d_gustafsson)	Closed in commitfest 2020-07 with status: Moved to next CF
2020-06-29 01:55:12	Thomas Munro (macdice)	Added macdice as reviewer
2020-06-09 20:39:03	Melanie Plageman (melanieplageman)	Changed authors to Melanie Plageman (melanieplageman), Jesse Zhang (essej), David Kimura (dgkimura)
2020-06-09 20:39:03	Melanie Plageman (melanieplageman)	Changed targetversion to 14
2020-06-09 20:39:03	Melanie Plageman (melanieplageman)	Changed gitlink to https://github.com/melanieplageman/postgres/tree/alternative_AHJ
2020-06-09 20:39:03	Melanie Plageman (melanieplageman)	Changed wikilink to https://wiki.postgresql.org/wiki/Hash_Join
2020-06-09 20:37:19	Melanie Plageman (melanieplageman)	Attached mail thread CA+hUKGKWWmf=WELLG=aUGbcugRaSQbtm0tKYiBut-B2rVKX63g@mail.gmail.com
2020-06-09 20:37:18	Melanie Plageman (melanieplageman)	Created patch record

Edit