Parallel INSERT SELECT take 2

Edit
ID 3143
Title Parallel INSERT SELECT take 2
Topic Performance
Created 2021-05-31 05:31:33
Last modified 2022-07-28 15:51:54 (2 years, 2 months ago)
Latest email 2022-07-28 15:51:41 (2 years, 2 months ago)
Status
2022-07: Returned with feedback
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
Target version
Authors Greg Nancarrow (gregn1234), Hou Zhijie (houzj)
Reviewers 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/3143
git checkout commitfest/cf/3143
Emails
Parallel INSERT SELECT take 2
First at 2021-04-12 01:21:57 by "tsunakawa.takay at fujitsu.com" <tsunakawa.takay at fujitsu.com>
Latest at 2021-08-05 09:41:10 by "houzj.fnst at fujitsu.com" <houzj.fnst at fujitsu.com>
Latest attachment (v14-0001-CREATE-ALTER-TABLE-PARALLEL-DML.patch) at 2021-07-23 05:00:07 from Greg Nancarrow <gregn4422 at gmail.com>
    Attachment (v14-0001-CREATE-ALTER-TABLE-PARALLEL-DML.patch) at 2021-07-23 05:00:07 from Greg Nancarrow <gregn4422 at gmail.com> (Patch: Yes)
    Attachment (v13-0001-CREATE-ALTER-TABLE-PARALLEL-DML.patch) at 2021-07-20 01:47:37 from "houzj.fnst at fujitsu.com" <houzj.fnst at fujitsu.com> (Patch: Yes)
    Attachment (v12-0001-CREATE-ALTER-TABLE-PARALLEL-DML.patch) at 2021-07-12 08:00:52 from "houzj.fnst at fujitsu.com" <houzj.fnst at fujitsu.com> (Patch: Yes)
    Attachment (v11-0004-regression-test-and-doc-updates.patch) at 2021-07-06 03:42:28 from "houzj.fnst at fujitsu.com" <houzj.fnst at fujitsu.com> (Patch: Yes)
    Attachment (v10-0001-CREATE-ALTER-TABLE-PARALLEL-DML.patch) at 2021-06-10 01:26:38 from "houzj.fnst at fujitsu.com" <houzj.fnst at fujitsu.com> (Patch: Yes)
    Attachment (v9-0001-CREATE-ALTER-TABLE-PARALLEL-DML.patch) at 2021-06-08 09:12:31 from "houzj.fnst at fujitsu.com" <houzj.fnst at fujitsu.com> (Patch: Yes)
    Attachment (v8-0001-CREATE-ALTER-TABLE-PARALLEL-DML.patch) at 2021-06-02 09:33:26 from "houzj.fnst at fujitsu.com" <houzj.fnst at fujitsu.com> (Patch: Yes)
    Attachment (v7-0004-regression-test-and-doc-updates.patch) at 2021-06-02 07:30:32 from "houzj.fnst at fujitsu.com" <houzj.fnst at fujitsu.com> (Patch: Yes)
    Attachment (v6-0004-regression-test-and-doc-updates.patch) at 2021-05-31 05:34:09 from "houzj.fnst at fujitsu.com" <houzj.fnst at fujitsu.com> (Patch: Yes)
    Attachment (v5-POC-0002-parallel-SELECT-for-INSERT.patch) at 2021-05-24 05:15:46 from "houzj.fnst at fujitsu.com" <houzj.fnst at fujitsu.com> (Patch: Yes)
    Attachment (v4-POC-0004-regression-test-updates.patch) at 2021-05-14 08:24:30 from "houzj.fnst at fujitsu.com" <houzj.fnst at fujitsu.com> (Patch: Yes)
    Attachment (v3-POC-0003-xid-related-and-testcase.patch) at 2021-05-11 12:40:53 from "houzj.fnst at fujitsu.com" <houzj.fnst at fujitsu.com> (Patch: Yes)
    Attachment (v2-POC-0004-fix-testcase-with-wrong-parallel-safety-flag.patch) at 2021-04-28 02:44:18 from "houzj.fnst at fujitsu.com" <houzj.fnst at fujitsu.com> (Patch: Yes)
    Attachment (v1-POC-0003-check-parallel-safety-in-fmgr.patch) at 2021-04-22 11:20:59 from "houzj.fnst at fujitsu.com" <houzj.fnst at fujitsu.com> (Patch: Yes)
[bug?] Missed parallel safety checks, and wrong parallel safety
First at 2021-04-20 08:52:46 by "tsunakawa.takay at fujitsu.com" <tsunakawa.takay at fujitsu.com>
Latest at 2022-07-28 15:51:41 by Jacob Champion <jchampion at timescale.com>
Latest attachment (v19-0002-Parallel-SELECT-for-INSERT.patch) at 2021-09-09 02:12:08 from "houzj.fnst at fujitsu.com" <houzj.fnst at fujitsu.com>
    Attachment (v19-0002-Parallel-SELECT-for-INSERT.patch) at 2021-09-09 02:12:08 from "houzj.fnst at fujitsu.com" <houzj.fnst at fujitsu.com> (Patch: Yes)
    Attachment (v18-0005-Regression-test-and-doc-updates.patch) at 2021-09-01 09:23:48 from "houzj.fnst at fujitsu.com" <houzj.fnst at fujitsu.com> (Patch: Yes)
    Attachment (v17-0004-Cache-parallel-dml-safety.patch) at 2021-08-19 08:16:11 from "houzj.fnst at fujitsu.com" <houzj.fnst at fujitsu.com> (Patch: Yes)
    Attachment (v16-0002-Parallel-SELECT-for-INSERT.patch) at 2021-08-06 08:23:09 from "houzj.fnst at fujitsu.com" <houzj.fnst at fujitsu.com> (Patch: Yes)
    Attachment (0006-hack-the-rewriter-bug.patch) at 2021-08-03 07:40:22 from "houzj.fnst at fujitsu.com" <houzj.fnst at fujitsu.com> (Patch: Yes)
    Attachment (0003-check-built-in-function-parallel-safety-in-fmgr_info.patch) at 2021-05-11 06:58:17 from "houzj.fnst at fujitsu.com" <houzj.fnst at fujitsu.com> (Patch: Yes)
    Attachment (0002-fix-testcase-with-wrong-parallel-safety-flag.patch) at 2021-04-29 01:42:18 from "houzj.fnst at fujitsu.com" <houzj.fnst at fujitsu.com> (Patch: Yes)
    Attachment (0001-fix-testcase-with-wrong-parallel-safety-flag.patch) at 2021-04-21 08:09:25 from "houzj.fnst at fujitsu.com" <houzj.fnst at fujitsu.com> (Patch: Yes)
History
When Who What
2023-04-11 05:35:35 Jianghua yang (yjhjstz.gmail.com) Removed yjhjstz.gmail.com from reviewers
2023-04-11 05:35:26 Jianghua yang (yjhjstz.gmail.com) Added yjhjstz.gmail.com as reviewer
2022-07-28 15:51:54 Jacob Champion (jchampion) Closed in commitfest 2022-07 with status: Returned with feedback
2022-03-24 22:30:01 Greg Stark (stark) Closed in commitfest 2022-03 with status: Moved to next CF
2022-01-19 22:41:37 Greg Nancarrow (gregn1234) Closed in commitfest 2022-01 with status: Moved to next CF
2022-01-14 12:14:20 Julien Rouhaud (rjuju) New status: Waiting on Author
2021-11-05 04:26:05 Greg Nancarrow (gregn1234) Closed in commitfest 2021-11 with status: Moved to next CF
2021-10-06 13:17:03 Jaime Casanova (jcasanov) Closed in commitfest 2021-09 with status: Moved to next CF
2021-08-03 07:46:55 Hou Zhijie (houzj) Attached mail thread TYAPR01MB29900259117BD4F1C36F0D5BFE489@TYAPR01MB2990.jpnprd01.prod.outlook.com
2021-08-03 07:46:24 Hou Zhijie (houzj) Detached mail thread TYAPR01MB29900259117BD4F1C36F0D5BFE489@TYAPR01MB2990.jpnprd01.prod.outlook.com
2021-08-03 06:59:06 Hou Zhijie (houzj) Attached mail thread TYAPR01MB29900259117BD4F1C36F0D5BFE489@TYAPR01MB2990.jpnprd01.prod.outlook.com
2021-08-03 02:27:44 Masahiko Sawada (masahikosawada) Closed in commitfest 2021-07 with status: Moved to next CF
2021-05-31 05:32:12 Hou Zhijie (houzj) Changed authors to Greg Nancarrow (gregn1234), hou zhijie (houzj)
2021-05-31 05:31:33 Hou Zhijie (houzj) Attached mail thread TYAPR01MB29905A9AB82CC8BA50AB0F80FE709@TYAPR01MB2990.jpnprd01.prod.outlook.com
2021-05-31 05:31:33 Hou Zhijie (houzj) Created patch record
Edit