Parallelize correlated subqueries that execute within each worker

Edit
Title Parallelize correlated subqueries that execute within each worker
Topic Performance
Created 2021-07-12 16:23:21
Last modified 2024-04-08 14:18:03 (1 week ago)
Latest email 2024-02-01 02:11:54 (2 months, 2 weeks ago)
Status
2024-07: Needs review
2024-03: Moved to next CF
2024-01: Moved to next CF
2023-11: Moved to next CF
2023-09: Moved to next CF
2023-07: Moved to next CF
2023-03: Moved to next CF
2023-01: Moved to next CF
2022-11: 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
Target version
Authors James Coleman (jcole1989)
Reviewers Akshat Jaimini (akshatj)Become reviewer
Committer
Links
Emails
Parallelize correlated subqueries that execute within each worker
First at 2021-05-07 16:30:02 by James Coleman <jtc331 at gmail.com>
Latest at 2024-02-01 02:11:54 by James Coleman <jtc331 at gmail.com>
Latest attachment (v12-0002-Parallelize-correlated-subqueries.patch) at 2024-01-31 02:51:09 from James Coleman <jtc331 at gmail.com>
    Attachment (v12-0002-Parallelize-correlated-subqueries.patch) at 2024-01-31 02:51:09 from James Coleman <jtc331 at gmail.com> (Patch: Yes)
    Attachment (v11-0002-Parallelize-correlated-subqueries.patch) at 2023-07-04 01:26:44 from James Coleman <jtc331 at gmail.com> (Patch: Yes)
    Attachment (backtrace.txt) at 2023-06-12 02:23:45 from James Coleman <jtc331 at gmail.com> (Patch: No)
    Attachment (v9-0001-Add-tests-before-change.patch) at 2023-02-08 13:38:27 from James Coleman <jtc331 at gmail.com> (Patch: Yes)
    Attachment (v8-0001-Add-tests-before-change.patch) at 2023-01-23 14:00:31 from James Coleman <jtc331 at gmail.com> (Patch: Yes)
    Attachment (v7-0004-Warning-messages-for-finding-test-cases.patch) at 2023-01-22 03:07:58 from James Coleman <jtc331 at gmail.com> (Patch: Yes)
    Attachment (0001-Add-tests-before-change-v6.patch) at 2023-01-18 19:09:21 from Tomas Vondra <tomas.vondra at enterprisedb.com> (Patch: Yes)
    Attachment (v5-0002-Parallelize-correlated-subqueries.patch) at 2022-09-27 02:56:11 from James Coleman <jtc331 at gmail.com> (Patch: Yes)
    Attachment (v4-0001-Allow-parallel-LATERAL-subqueries-with-LIMIT-OFFS.patch) at 2022-01-23 01:25:19 from James Coleman <jtc331 at gmail.com> (Patch: Yes)
    Attachment (v4-0001-Allow-parallel-LATERAL-subqueries-with-LIMIT-OFFS.patch) at 2022-01-14 19:15:40 from James Coleman <jtc331 at gmail.com> (Patch: Yes)
    Attachment (v3-0001-Allow-parallel-LATERAL-subqueries-with-LIMIT-OFFS.patch) at 2021-09-08 12:47:35 from James Coleman <jtc331 at gmail.com> (Patch: Yes)
    Attachment (v2-0001-Allow-parallel-LATERAL-subqueries-with-LIMIT-OFFS.patch) at 2021-09-07 13:16:49 from James Coleman <jtc331 at gmail.com> (Patch: Yes)
    Attachment (v1-0003-Other-places-to-consider-for-completeness.patch) at 2021-05-07 16:30:02 from James Coleman <jtc331 at gmail.com> (Patch: Yes)
History
When Who What
2024-04-08 14:18:03 Andrey Borodin (x4m) Closed in commitfest 2024-03 with status: Moved to next CF
2024-02-01 17:37:29 vigneshwaran C (vignesh.postgres) Closed in commitfest 2024-01 with status: Moved to next CF
2024-01-31 02:57:09 James Coleman (jcole1989) New status: Needs review
2024-01-30 16:16:20 Akshat Jaimini (akshatj) Posted comment with messageid <170663138007.1131.9149309283833230346.pgcf@coridan.postgresql.org>
2024-01-27 01:51:29 vigneshwaran C (vignesh.postgres) New status: Waiting on Author
2024-01-23 14:33:22 Akshat Jaimini (akshatj) Posted comment with messageid <170602040264.1131.559115411627868529.pgcf@coridan.postgresql.org>
2024-01-03 11:14:20 Akshat Jaimini (akshatj) Added akshatj as reviewer
2023-12-04 09:16:32 John Naylor (john.naylor) Closed in commitfest 2023-11 with status: Moved to next CF
2023-10-02 14:22:23 Peter Eisentraut (petere) Changed reviewers to
2023-10-02 14:21:35 Peter Eisentraut (petere) Closed in commitfest 2023-09 with status: Moved to next CF
2023-08-01 20:13:22 Daniel Gustafsson (d_gustafsson) Closed in commitfest 2023-07 with status: Moved to next CF
2023-07-04 01:27:03 James Coleman (jcole1989) New status: Needs review
2023-06-21 12:56:19 James Coleman (jcole1989) New status: Waiting on Author
2023-04-09 02:55:54 Greg Stark (stark) Closed in commitfest 2023-03 with status: Moved to next CF
2023-03-08 18:05:14 Antonin Houska (a.houska) New status: Ready for Committer
2023-03-03 14:55:58 Justin Pryzby (justinpryzby) New status: Needs review
2023-02-06 16:40:49 Antonin Houska (a.houska) Added a.houska as reviewer
2023-02-06 16:40:44 Antonin Houska (a.houska) New status: Waiting on Author
2023-02-02 14:37:29 Peter Eisentraut (petere) Changed targetversion to None
2023-01-31 16:16:06 vigneshwaran C (vignesh.postgres) Closed in commitfest 2023-01 with status: Moved to next CF
2023-01-25 03:15:10 James Coleman (jcole1989) New status: Needs review
2023-01-06 06:13:00 vigneshwaran C (vignesh.postgres) New status: Waiting on Author
2022-12-11 07:32:26 Ian Barwick (barwick) Closed in commitfest 2022-11 with status: Moved to next CF
2022-09-27 02:56:51 James Coleman (jcole1989) Closed in commitfest 2022-07 with status: Moved to next CF
2022-09-27 02:56:46 James Coleman (jcole1989) New status: Needs review
2022-08-02 20:57:40 Jacob Champion (jchampion) Closed in commitfest 2022-07 with status: Returned with feedback
2022-04-08 12:58:26 Greg Stark (stark) Closed in commitfest 2022-03 with status: Moved to next CF
2022-03-22 00:48:11 Andres Freund (andresfreund) New status: Waiting on Author
2022-02-02 16:33:44 Julien Rouhaud (rjuju) Closed in commitfest 2022-01 with status: Moved to next CF
2022-01-14 19:15:59 James Coleman (jcole1989) New status: Needs review
2021-12-03 07:34:01 Michael Paquier (michael-kun) New status: Waiting on Author
2021-12-03 07:33:54 Michael Paquier (michael-kun) Closed in commitfest 2021-11 with status: Moved to next CF
2021-11-03 13:46:45 James Coleman (jcole1989) New status: Needs review
2021-10-03 16:00:37 Jaime Casanova (jcasanov) New status: Waiting on Author
2021-10-03 16:00:23 Jaime Casanova (jcasanov) Closed in commitfest 2021-09 with status: Moved to next CF
2021-10-03 16:00:18 Jaime Casanova (jcasanov) New status: Needs review
2021-09-01 11:06:10 Daniel Gustafsson (d_gustafsson) New status: Waiting on Author
2021-07-12 16:23:33 James Coleman (jcole1989) Changed authors to James Coleman (jcole1989)
2021-07-12 16:23:33 James Coleman (jcole1989) Changed targetversion to 15
2021-07-12 16:23:21 James Coleman (jcole1989) Attached mail thread CAAaqYe_x1u3V4uPiv=dJ=k2EJ7txhdq6yexJDkYZ1x1pu0QwcQ@mail.gmail.com
2021-07-12 16:23:21 James Coleman (jcole1989) Created patch record
Edit