Parallelize correlated subqueries that execute within each worker

Edit

ID 3246

Title Parallelize correlated subqueries that execute within each worker

Topic Performance

Created 2021-07-12 16:23:21

Last modified 2024-10-07 07:22:00 (1 month, 2 weeks ago)

Latest email 2024-07-20 23:06:55 (4 months ago)

Status

2024-09: Returned with feedback

2024-07: Moved to next CF

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 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/3246
git checkout commitfest/cf/3246

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-07-20 23:06:55 by Tomas Vondra <tomas.vondra at enterprisedb.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-10-07 07:22:00	Michael Paquier (michael-kun)	Closed in commitfest 2024-09 with status: Returned with feedback
2024-08-01 05:54:33	Corey Huinker (coreyh)	Closed in commitfest 2024-07 with status: Moved to next CF
2024-07-20 23:08:04	Tomas Vondra (fuzzycz)	New status: Waiting on Author
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