Hashjoin fall back to block nested hashloop join

Edit
Title Hashjoin fall back to block nested hashloop join
Topic Performance
Created 2020-06-09 20:37:18
Last modified 2020-06-09 20:39:03 (1 month ago)
Latest email 2020-06-26 00:22:32 (2 weeks, 4 days ago)
Status
2020-07: Needs review
Target version 14
Authors Melanie Plageman (melanieplageman), Jesse Zhang (essej), David Kimura (dgkimura)
Reviewers Thomas Munro (macdice)Become reviewer
Committer
Links Wiki Git
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-06-26 00:22:32 by Tomas Vondra <tomas.vondra at 2ndquadrant.com>
Latest attachment (v10-0001-Implement-Adaptive-Hashjoin.patch) at 2020-06-25 22:09:44 from Melanie Plageman <melanieplageman at gmail.com>
    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-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