Parallel Hash Full Join

Edit
ID 2903
Title Parallel Hash Full Join
Topic Performance
Created 2020-12-29 02:29:20
Last modified 2023-03-30 23:01:35 (1 year, 8 months ago)
Latest email 2023-04-09 23:33:30 (1 year, 8 months ago)
Status
2023-03: Committed
2023-01: Moved to next CF
2022-11: Moved to next CF
2022-09: Moved to next CF
2022-07: Moved to next CF
2022-03: Moved to next CF
2022-01: Moved to next CF
2021-11: Moved to next CF
2021-09: Moved to next CF
2021-07: Moved to next CF
2021-03: Moved to next CF
2021-01: Moved to next CF
Target version 16
Authors Melanie Plageman (melanieplageman)
Reviewers Thomas Munro (macdice)Become reviewer
Committer Thomas Munro (macdice)
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/2903
git checkout commitfest/cf/2903
Emails
Parallel Full Hash Join
First at 2019-09-12 05:56:00 by Thomas Munro <thomas.munro at gmail.com>
Latest at 2023-04-09 23:33:30 by Michael Paquier <michael at paquier.xyz>
Latest attachment (more-parallel.png) at 2023-03-30 22:55:53 from Thomas Munro <thomas.munro at gmail.com>
    Attachment (more-parallel.png) at 2023-03-30 22:55:53 from Thomas Munro <thomas.munro at gmail.com> (Patch: No)
    Attachment (Add-multi-batch-parallel-full-hash-join-test.patch) at 2023-03-30 19:23:15 from Melanie Plageman <melanieplageman at gmail.com> (Patch: Yes)
    Attachment (g.pdf) at 2023-03-27 23:03:42 from Thomas Munro <thomas.munro at gmail.com> (Patch: No)
    Attachment (v12-0001-Scan-for-unmatched-hash-join-tuples-in-memory-or.patch) at 2023-03-24 20:21:34 from Thomas Munro <thomas.munro at gmail.com> (Patch: Yes)
    Attachment (v11-0001-Fix-race-condition-in-parallel-hash-join-batch-c.patch) at 2022-04-08 11:29:32 from Thomas Munro <thomas.munro at gmail.com> (Patch: Yes)
    Attachment (v10-0002-Improve-the-naming-of-Parallel-Hash-Join-phases.patch) at 2022-01-11 21:30:37 from Melanie Plageman <melanieplageman at gmail.com> (Patch: Yes)
    Attachment (v9-0002-Improve-the-naming-of-Parallel-Hash-Join-phases.patch) at 2021-11-17 21:03:13 from Melanie Plageman <melanieplageman at gmail.com> (Patch: Yes)
    Attachment (v8-0003-Parallel-Hash-Full-Right-Outer-Join.patch) at 2021-11-17 18:45:06 from Melanie Plageman <melanieplageman at gmail.com> (Patch: Yes)
    Attachment (v7-0003-Parallel-Hash-Full-Right-Outer-Join.patch) at 2021-07-30 20:34:34 from Melanie Plageman <melanieplageman at gmail.com> (Patch: Yes)
    Attachment (phj-phases-with-full-scan.png) at 2021-03-06 01:30:33 from Thomas Munro <thomas.munro at gmail.com> (Patch: No)
    Attachment (v5-0001-Parallel-Hash-Full-Right-Outer-Join.patch) at 2021-03-02 10:27:19 from Thomas Munro <thomas.munro at gmail.com> (Patch: Yes)
    Attachment (v4-0002-Update-comments-and-phase-naming.patch) at 2021-02-11 22:02:18 from Melanie Plageman <melanieplageman at gmail.com> (Patch: Yes)
    Attachment (v4-0001-Parallel-Hash-Full-Right-Join.patch) at 2020-12-29 02:28:12 from Thomas Munro <thomas.munro at gmail.com> (Patch: Yes)
    Attachment (v3-0001-Support-Parallel-FOJ-and-ROJ.patch) at 2020-11-04 22:33:58 from Melanie Plageman <melanieplageman at gmail.com> (Patch: Yes)
    Attachment (v2-0001-Support-Parallel-FOJ-and-ROJ.patch) at 2020-09-30 00:45:23 from Melanie Plageman <melanieplageman at gmail.com> (Patch: Yes)
    Attachment (v1-0001-Parallel-FOJ-ROJ-single-worker-scan-chunks.patch) at 2020-09-21 20:49:17 from Melanie Plageman <melanieplageman at gmail.com> (Patch: Yes)
    Attachment (0001-WIP-Add-support-for-Parallel-Full-Hash-Join.patch) at 2019-09-12 05:56:00 from Thomas Munro <thomas.munro at gmail.com> (Patch: Yes)
History
When Who What
2023-03-30 23:01:35 Thomas Munro (macdice) Closed in commitfest 2023-03 with status: Committed
2023-01-31 16:26:53 vigneshwaran C (vignesh.postgres) Closed in commitfest 2023-01 with status: Moved to next CF
2022-12-02 05:13:15 Michael Paquier (michael-kun) Closed in commitfest 2022-11 with status: Moved to next CF
2022-10-12 06:08:09 Michael Paquier (michael-kun) Closed in commitfest 2022-09 with status: Moved to next CF
2022-08-01 17:16:35 Jacob Champion (jchampion) Closed in commitfest 2022-07 with status: Moved to next CF
2022-04-09 02:17:07 Justin Pryzby (justinpryzby) New status: Ready for Committer
2022-04-09 02:17:00 Justin Pryzby (justinpryzby) Changed committer to macdice
2022-04-09 02:17:00 Justin Pryzby (justinpryzby) Changed targetversion to 16
2022-04-08 11:30:23 Thomas Munro (macdice) Closed in commitfest 2022-03 with status: Moved to next CF
2022-02-02 16:29:58 Julien Rouhaud (rjuju) Closed in commitfest 2022-01 with status: Moved to next CF
2022-01-09 18:54:02 Justin Pryzby (justinpryzby) New status: Needs review
2021-12-02 11:27:42 Daniel Gustafsson (d_gustafsson) Closed in commitfest 2021-11 with status: Moved to next CF
2021-11-26 22:08:22 Justin Pryzby (justinpryzby) New status: Waiting on Author
2021-10-05 17:39:37 Jaime Casanova (jcasanov) Closed in commitfest 2021-09 with status: Moved to next CF
2021-08-03 02:17:00 Masahiko Sawada (masahikosawada) Closed in commitfest 2021-07 with status: Moved to next CF
2021-07-30 20:36:07 Melanie Plageman (melanieplageman) New status: Ready for Committer
2021-07-10 13:13:33 vigneshwaran C (vignesh.postgres) New status: Waiting on Author
2021-04-08 15:42:45 David Steele (dsteele) Closed in commitfest 2021-03 with status: Moved to next CF
2021-03-15 18:50:06 Justin Pryzby (justinpryzby) New status: Ready for Committer
2021-02-01 12:39:34 Masahiko Sawada (masahikosawada) Closed in commitfest 2021-01 with status: Moved to next CF
2020-12-29 02:29:38 Thomas Munro (macdice) Changed reviewers to Thomas Munro (macdice)
2020-12-29 02:29:38 Thomas Munro (macdice) Changed authors to Melanie Plageman (melanieplageman)
2020-12-29 02:29:20 Thomas Munro (macdice) Attached mail thread CA+hUKG+A6ftXPz4oe92+x8Er+xpGZqto70-Q_ERwRaSyA=afNg@mail.gmail.com
2020-12-29 02:29:20 Thomas Munro (macdice) Created patch record
Edit