Parallelize correlated subqueries that execute within each worker

Edit

Title

Topic

Performance

Created

2021-07-12 16:23:21

Last modified

2023-08-01 20:13:22 (1 month, 4 weeks ago)

Latest email

2023-07-04 01:26:44 (2 months, 4 weeks ago)

Status

2023-09: Needs review

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

Antonin Houska (a.houska)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 2023-07-04 01:26:44 by James Coleman <jtc331 at gmail.com>
Latest attachment (v11-0002-Parallelize-correlated-subqueries.patch) at 2023-07-04 01:26:44 from James Coleman <jtc331 at gmail.com>
    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
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