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, 4 months ago)

Latest email 2022-07-28 15:51:41 (2 years, 4 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