Should consider materializing the cheapest inner path in consider_parallel_nestloop()

Edit

ID 4549

Title Should consider materializing the cheapest inner path in consider_parallel_nestloop()

Topic Performance

Created 2023-09-06 11:19:09

Last modified 2024-07-12 02:48:49 (4 months, 3 weeks ago)

Latest email 2024-07-22 02:43:50 (4 months, 1 week ago)

Status

2024-07: Committed

2024-03: Moved to next CF

2024-01: Moved to next CF

2023-11: Moved to next CF

Target version

Authors Tender Wang (tndrwang)

Reviewers Robert Haas (rhaas), Richard Guo (richardguo), Yuki Fujii (fujiiyuki)Become reviewer

Committer Richard Guo (richardguo)

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

Emails

Should consider materializing the cheapest inner path in consider_parallel_nestloop()

First at 2023-09-05 08:52:35 by tender wang <tndrwang at gmail.com>
Latest at 2024-07-22 02:43:50 by Richard Guo <guofenglinux at gmail.com>
Latest attachment (v1-0001-Fix-unstable-test-in-select_parallel.sql.patch) at 2024-07-18 14:30:22 from Richard Guo <guofenglinux at gmail.com>

    Attachment (v1-0001-Fix-unstable-test-in-select_parallel.sql.patch) at 2024-07-18 14:30:22 from Richard Guo <guofenglinux at gmail.com> (Patch: Yes)
    Attachment (plan.expected.txt) at 2024-07-18 08:00:00 from Alexander Lakhin <exclusion at gmail.com> (Patch: No)
    Attachment (v6-0001-Consider-materializing-the-cheapest-inner-path-in-parallel-nestloop.patch) at 2024-07-06 09:32:41 from Richard Guo <guofenglinux at gmail.com> (Patch: Yes)
    Attachment (v5-0001-Consider-materializing-the-cheapest-inner-path-in-parallel-nestloop.patch) at 2024-06-18 09:24:05 from Richard Guo <guofenglinux at gmail.com> (Patch: Yes)
    Attachment (v4-0001-Support-materializing-inner-path-on-parallel-oute.patch) at 2024-06-04 10:51:02 from Tender Wang <tndrwang at gmail.com> (Patch: Yes)
    Attachment (v3-0001-Support-materializing-inner-path-on-parallel-oute.patch) at 2024-04-23 08:59:42 from Tender Wang <tndrwang at gmail.com> (Patch: Yes)
    Attachment (v2-0001-Parallel-seq-scan-should-consider-materila-inner-.patch) at 2023-09-07 09:56:40 from tender wang <tndrwang at gmail.com> (Patch: Yes)
    Attachment (0001-Parallel-seq-scan-should-consider-materila-inner-pat.patch) at 2023-09-05 08:52:35 from tender wang <tndrwang at gmail.com> (Patch: Yes)

Annotations

When	Who	Mail	Annotation
2023-09-07 09:58:16	Tender Wang (tndrwang)	From tender wang <tndrwang@gmail.com> at 2023-09-07 09:56:40	v2 patch Fixed some comments

History

When	Who	What
2024-07-12 02:48:49	Richard Guo (richardguo)	Closed in commitfest 2024-07 with status: Committed
2024-07-12 02:48:49	Richard Guo (richardguo)	Changed committer to richardguo
2024-06-16 00:50:06	Tender Wang (tndrwang)	New status: Ready for Committer
2024-06-11 22:10:04	Yuki Fujii (fujiiyuki)	Added fujiiyuki as reviewer
2024-06-09 02:46:01	Alena Rybakina (a.rybakina)	Removed a.rybakina from reviewers
2024-04-23 09:02:19	Tender Wang (tndrwang)	New status: Needs review
2024-04-08 09:40:34	Andrey Borodin (x4m)	Closed in commitfest 2024-03 with status: Moved to next CF
2024-04-08 09:40:30	Andrey Borodin (x4m)	New status: Waiting on Author
2024-02-01 17:51:09	vigneshwaran C (vignesh.postgres)	Closed in commitfest 2024-01 with status: Moved to next CF
2023-12-06 08:17:44	Alena Rybakina (a.rybakina)	Added a.rybakina as reviewer
2023-12-04 09:48:47	John Naylor (john.naylor)	Closed in commitfest 2023-11 with status: Moved to next CF
2023-10-24 03:34:47	Tender Wang (tndrwang)	Changed reviewers to Robert Haas (rhaas), Richard Guo (richardguo)
2023-10-20 18:06:22	Tom Lane (tgl)	Removed tgl from reviewers
2023-10-12 02:39:12	Tender Wang (tndrwang)	Changed targetversion to None
2023-09-07 09:58:16	Tender Wang (tndrwang)	Added annotation "v2 patch Fixed some comments" to CAHewXN=4=ntM2OsJBHgJzmXxnd_0xtsCwnUhEVxgHSkBsBMO1Q@mail.gmail.com
2023-09-06 11:20:33	Tender Wang (tndrwang)	Changed reviewers to Tom Lane (tgl), Richard Guo (richardguo)
2023-09-06 11:20:33	Tender Wang (tndrwang)	Changed authors to tender wang (tndrwang)
2023-09-06 11:20:33	Tender Wang (tndrwang)	Changed targetversion to 17
2023-09-06 11:19:10	Tender Wang (tndrwang)	Attached mail thread CAHewXNkPmtEXNfVQMou_7NqQmFABca9f4etjBtdbbm0ZKDmWvw@mail.gmail.com
2023-09-06 11:19:09	Tender Wang (tndrwang)	Created patch record

Edit