Parallelize correlated subqueries that execute within each worker

Edit

3246

Title

CI (CFBot)

Not processed

Stats (from CFBot)

Unknown

Topic

Performance

Tags

Created

2021-07-12 16:23:21

Last modified

2024-10-07 07:22:00 (9 months ago)

Latest email

2024-07-20 23:06:55 (11 months ago)

Status

2024-09 (2024-09-01 - 2024-09-30): Returned with feedback

2024-07 (2024-07-01 - 2024-07-31): Moved to different CF

2024-03 (2024-03-01 - 2024-04-08): Moved to different CF

2024-01 (2024-01-01 - 2024-01-31): Moved to different CF

2023-11 (2023-11-01 - 2023-12-04): Moved to different CF

2023-09 (2023-09-01 - 2023-09-30): Moved to different CF

2023-07 (2023-07-01 - 2023-07-31): Moved to different CF

2023-03 (2023-03-01 - 2023-04-08): Moved to different CF

2023-01 (2023-01-01 - 2023-01-31): Moved to different CF

2022-11 (2022-11-01 - 2022-11-30): Moved to different CF

2022-07 (2022-07-01 - 2022-07-31): Moved to different CF

2022-03 (2022-03-01 - 2022-03-31): Moved to different CF

2022-01 (2022-01-01 - 2022-01-31): Moved to different CF

2021-11 (2021-11-01 - 2021-11-30): Moved to different CF

2021-09 (2021-09-01 - 2021-09-30): Moved to different 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-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