Parallel INSERT SELECT take 2

Edit

Title

Topic

Performance

Created

2021-05-31 05:31:33

Last modified

2022-07-28 15:51:54 (8 months ago)

Latest email

2022-07-28 15:51:41 (8 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

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
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