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

Latest email 2023-04-09 23:33:30 (1 year, 7 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