Consider parallel for LATERAL subqueries having LIMIT/OFFSET

2851

Title

Topic

Performance

Created

2020-12-01 00:01:33

Last modified

2023-03-23 18:43:01 (1 year, 7 months ago)

Latest email

2023-03-23 18:42:51 (1 year, 7 months ago)

Status

2023-03: Returned with feedback

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

2021-07: Moved to next CF

2021-03: Moved to next CF

2021-01: Moved to next CF

Target version

Authors

James Coleman (jcole1989)

Reviewers

Greg Nancarrow (gregn1234)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/2851
git checkout commitfest/cf/2851

Emails

Consider parallel for lateral subqueries with limit: First at 2020-12-01 00:00:26 by James Coleman <jtc331 at gmail.com>
Latest at 2023-03-23 18:42:51 by "Gregory Stark (as CFM)" <stark.cfm at gmail.com>
Latest attachment (v3-0002-Subqueries-with-LIMIT-can-be-parallel-safe-when-e.patch) at 2022-09-25 00:35:52 from James Coleman <jtc331 at gmail.com>
    Attachment (v3-0002-Subqueries-with-LIMIT-can-be-parallel-safe-when-e.patch) at 2022-09-25 00:35:52 from James Coleman <jtc331 at gmail.com> (Patch: Yes)
    Attachment (v2-0001-Allow-parallel-LATERAL-subqueries-with-LIMIT-OFFS.patch) at 2021-07-16 19:16:10 from James Coleman <jtc331 at gmail.com> (Patch: Yes)
    Attachment (v1-0001-Allow-parallel-LATERAL-subqueries-with-LIMIT-OFFS.patch) at 2020-12-01 00:00:26 from James Coleman <jtc331 at gmail.com> (Patch: Yes)

History

When	Who	What
2023-03-23 18:43:01	Greg Stark (stark)	Closed in commitfest 2023-03 with status: Returned with feedback
2023-01-31 16:15:56	vigneshwaran C (vignesh.postgres)	Closed in commitfest 2023-01 with status: Moved to next CF
2022-12-11 07:30:36	Ian Barwick (barwick)	Closed in commitfest 2022-11 with status: Moved to next CF
2022-09-23 20:05:32	James Coleman (jcole1989)	Closed in commitfest 2022-07 with status: Moved to next CF
2022-09-23 20:05:25	James Coleman (jcole1989)	New status: Needs review
2022-08-02 21:05:19	Jacob Champion (jchampion)	Closed in commitfest 2022-07 with status: Returned with feedback
2022-04-09 01:24:38	Greg Stark (stark)	Closed in commitfest 2022-03 with status: Moved to next CF
2022-04-09 01:24:33	Greg Stark (stark)	New status: Waiting on Author
2022-02-02 16:29:57	Julien Rouhaud (rjuju)	Closed in commitfest 2022-01 with status: Moved to next CF
2021-12-01 10:27:44	Daniel Gustafsson (d_gustafsson)	Closed in commitfest 2021-11 with status: Moved to next CF
2021-11-04 02:00:06	Greg Nancarrow (gregn1234)	New status: Ready for Committer
2021-10-06 13:16:28	Jaime Casanova (jcasanov)	Closed in commitfest 2021-09 with status: Moved to next CF
2021-08-03 02:27:03	Masahiko Sawada (masahikosawada)	Closed in commitfest 2021-07 with status: Moved to next CF
2021-05-27 04:24:25	Greg Nancarrow (gregn1234)	Added gregn1234 as reviewer
2021-04-08 15:42:27	David Steele (dsteele)	Closed in commitfest 2021-03 with status: Moved to next CF
2021-02-01 12:38:58	Masahiko Sawada (masahikosawada)	Closed in commitfest 2021-01 with status: Moved to next CF
2020-12-01 00:01:53	James Coleman (jcole1989)	Changed authors to James Coleman (jcole1989)
2020-12-01 00:01:33	James Coleman (jcole1989)	Attached mail thread CAAaqYe_HEkmLwf_1iEHxXwQOWiRyiFd=uOu6kwj3sWYdVd1-zA@mail.gmail.com
2020-12-01 00:01:33	James Coleman (jcole1989)	Created patch record