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 (5 months ago)
Latest email 2024-07-22 02:43:50 (4 months, 3 weeks 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