Parallel INSERT (INTO ... SELECT ...)

Edit

Title

Topic

Performance

Created

2020-11-25 06:20:50

Last modified

2021-04-01 04:23:41 (2 years, 2 months ago)

Latest email

2021-04-01 04:26:45 (2 years, 2 months ago)

Status

2021-03: Returned with feedback

2021-01: Moved to next CF

Target version

Authors

Greg Nancarrow (gregn1234)

Reviewers

Haiying Tang (tanghy), Takayuki Tsunakawa (maumau), vigneshwaran C (vignesh.postgres), Antonin Houska (a.houska), Hou Zhijie (houzj)Become reviewer

Committer

Amit Kapila (amitkapila)

Links

Emails

Parallel INSERT (INTO ... SELECT ...): First at 2020-09-22 04:55:21 by Greg Nancarrow <gregn4422 at gmail.com>
Latest at 2021-04-01 04:26:45 by Amit Kapila <amit.kapila16 at gmail.com>
Latest attachment (v30-0001-Parallel-SELECT-for-INSERT-INTO-.-SELECT-advanced-tests.patch) at 2021-03-22 10:27:03 from Greg Nancarrow <gregn4422 at gmail.com>
    Attachment (v30-0001-Parallel-SELECT-for-INSERT-INTO-.-SELECT-advanced-tests.patch) at 2021-03-22 10:27:03 from Greg Nancarrow <gregn4422 at gmail.com> (Patch: Yes)
    Attachment (v29-0001-Parallel-SELECT-for-INSERT-INTO-.-SELECT-advanced-tests.patch) at 2021-03-18 12:18:53 from Greg Nancarrow <gregn4422 at gmail.com> (Patch: Yes)
    Attachment (0001-Fix-for-parallel_insert_enabled.patch) at 2021-03-18 03:00:03 from Justin Pryzby <pryzby at telsasoft.com> (Patch: Yes)
    Attachment (v28-0001-Add-a-new-GUC-and-a-reloption-to-enable-inserts-.patch) at 2021-03-15 05:55:26 from Amit Kapila <amit.kapila16 at gmail.com> (Patch: Yes)
    Attachment (v27-0003-Parallel-SELECT-for-INSERT-INTO-.-SELECT-advanced-tests.patch) at 2021-03-12 09:31:39 from "houzj.fnst at fujitsu.com" <houzj.fnst at fujitsu.com> (Patch: Yes)
    Attachment (v1-0001-Fix-TriggerDesc-relcache-bug-introduced-by-recent-commit.patch) at 2021-03-12 07:23:54 from Greg Nancarrow <gregn4422 at gmail.com> (Patch: Yes)
    Attachment (v26-0003-Parallel-SELECT-for-INSERT-INTO-.-SELECT-advanced-tests.patch) at 2021-03-11 13:01:42 from "houzj.fnst at fujitsu.com" <houzj.fnst at fujitsu.com> (Patch: Yes)
    Attachment (v25-0001-Enable-parallel-SELECT-for-INSERT-INTO-.-SELECT.patch) at 2021-03-08 10:24:09 from Greg Nancarrow <gregn4422 at gmail.com> (Patch: Yes)
    Attachment (v24-0001-Enable-parallel-SELECT-for-INSERT-INTO-.-SELECT.patch) at 2021-03-08 01:25:36 from "houzj.fnst at fujitsu.com" <houzj.fnst at fujitsu.com> (Patch: Yes)
    Attachment (v23-0001-Enable-parallel-SELECT-for-INSERT-INTO-.-SELECT.patch) at 2021-03-06 10:19:05 from Amit Kapila <amit.kapila16 at gmail.com> (Patch: Yes)
    Attachment (v22-0001-Enable-parallel-SELECT-for-INSERT-INTO-.-SELECT.patch) at 2021-03-05 13:04:36 from Greg Nancarrow <gregn4422 at gmail.com> (Patch: Yes)
    Attachment (v21-0001-Enable-parallel-SELECT-for-INSERT-INTO-.-SELECT.patch) at 2021-03-05 02:54:01 from Greg Nancarrow <gregn4422 at gmail.com> (Patch: Yes)
    Attachment (v20-0001-Enable-parallel-SELECT-for-INSERT-INTO-.-SELECT.patch) at 2021-03-01 03:38:21 from Greg Nancarrow <gregn4422 at gmail.com> (Patch: Yes)
    Attachment (performance test result_20210226.txt) at 2021-02-26 09:23:55 from "tanghy.fnst at fujitsu.com" <tanghy.fnst at fujitsu.com> (Patch: No)
    Attachment (AcquireExecutorLocks-partition-insert.patch) at 2021-02-26 05:07:15 from Amit Langote <amitlangote09 at gmail.com> (Patch: Yes)
    Attachment (v19-0001-Enable-parallel-SELECT-for-INSERT-INTO-.-SELECT.patch) at 2021-02-26 01:53:02 from Greg Nancarrow <gregn4422 at gmail.com> (Patch: Yes)
    Attachment (fix_modifyingcte_parallel_safety_v1.patch) at 2021-02-24 09:38:50 from Amit Kapila <amit.kapila16 at gmail.com> (Patch: Yes)
    Attachment (v18-0002-Parallel-SELECT-for-INSERT-INTO-.-SELECT-tests-and-doc.patch) at 2021-02-19 01:25:56 from Greg Nancarrow <gregn4422 at gmail.com> (Patch: Yes)
    Attachment (setrefs-v3.patch) at 2021-02-17 13:34:42 from Amit Langote <amitlangote09 at gmail.com> (Patch: Yes)
    Attachment (setrefs-v2.patch) at 2021-02-16 13:18:59 from Amit Langote <amitlangote09 at gmail.com> (Patch: Yes)
    Attachment (setrefs.patch) at 2021-02-15 07:39:36 from Greg Nancarrow <gregn4422 at gmail.com> (Patch: Yes)
    Attachment (v17-0004-Parallel-INSERT-and-or-SELECT-for-INSERT-INTO-tests-and-doc.patch) at 2021-02-12 03:02:22 from Greg Nancarrow <gregn4422 at gmail.com> (Patch: Yes)
    Attachment (v16-0004-Parallel-INSERT-and-or-SELECT-for-INSERT-INTO-tests-and-doc.patch) at 2021-02-11 12:17:27 from Greg Nancarrow <gregn4422 at gmail.com> (Patch: Yes)
    Attachment (parallel_insert.txt) at 2021-02-10 10:46:11 from "Hou, Zhijie" <houzj.fnst at cn.fujitsu.com> (Patch: No)
    Attachment (serial_insert.txt) at 2021-02-09 12:18:49 from "Hou, Zhijie" <houzj.fnst at cn.fujitsu.com> (Patch: No)
    Attachment (v15_delta.diff) at 2021-02-08 14:03:50 from Amit Langote <amitlangote09 at gmail.com> (Patch: Yes)
    Attachment (postgresql.conf) at 2021-02-08 08:12:40 from "Tang, Haiying" <tanghy.fnst at cn.fujitsu.com> (Patch: No)
    Attachment (v15-0001-Enable-parallel-SELECT-for-INSERT-INTO-.-SELECT.patch) at 2021-02-08 06:52:56 from Greg Nancarrow <gregn4422 at gmail.com> (Patch: Yes)
    Attachment (v14-0001-Enable-parallel-SELECT-for-INSERT-INTO-.-SELECT.patch) at 2021-02-02 11:03:08 from Greg Nancarrow <gregn4422 at gmail.com> (Patch: Yes)
    Attachment (test_bitmap.sql) at 2021-02-01 08:19:56 from "Tang, Haiying" <tanghy.fnst at cn.fujitsu.com> (Patch: No)
    Attachment (v13-0002-Parallel-SELECT-for-INSERT-INTO-.-SELECT-tests-and-doc.patch) at 2021-01-28 13:11:06 from Greg Nancarrow <gregn4422 at gmail.com> (Patch: Yes)
    Attachment (v12-0001-Enable-parallel-SELECT-for-INSERT-INTO-.-SELECT.patch) at 2021-01-21 01:05:44 from Greg Nancarrow <gregn4422 at gmail.com> (Patch: Yes)
    Attachment (v11-0001-Enable-parallel-SELECT-for-INSERT-INTO-.-SELECT.patch) at 2020-12-11 11:00:47 from Greg Nancarrow <gregn4422 at gmail.com> (Patch: Yes)
    Attachment (v10-0002-Parallel-SELECT-for-INSERT-INTO-.-SELECT-tests-and-doc.patch) at 2020-12-09 04:40:52 from Greg Nancarrow <gregn4422 at gmail.com> (Patch: Yes)
    Attachment (v9-0001-Enable-parallel-SELECT-for-INSERT-INTO-.-SELECT.patch) at 2020-12-07 09:04:59 from Greg Nancarrow <gregn4422 at gmail.com> (Patch: Yes)
    Attachment (v8-0001-Enable-parallel-SELECT-for-INSERT-INTO-.-SELECT.patch) at 2020-11-20 08:44:37 from Greg Nancarrow <gregn4422 at gmail.com> (Patch: Yes)
    Attachment (v7-0001-Enable-parallel-SELECT-for-INSERT-INTO-.-SELECT.patch) at 2020-11-13 09:14:20 from Greg Nancarrow <gregn4422 at gmail.com> (Patch: Yes)
    Attachment (v6-0001-Enable-parallel-SELECT-for-INSERT-INTO-.-SELECT.patch) at 2020-10-30 00:38:49 from Greg Nancarrow <gregn4422 at gmail.com> (Patch: Yes)
    Attachment (v5-0001-Enable-parallel-INSERT-and-or-SELECT-for-INSERT-INTO.patch) at 2020-10-27 03:45:47 from Greg Nancarrow <gregn4422 at gmail.com> (Patch: Yes)
    Attachment (v3-0001-Enable-parallel-SELECT-for-INSERT-INTO-.-SELECT.patch) at 2020-10-22 04:16:08 from Greg Nancarrow <gregn4422 at gmail.com> (Patch: Yes)
    Attachment (fix_paratition_failure_1.patch) at 2020-10-16 04:44:13 from Amit Kapila <amit.kapila16 at gmail.com> (Patch: Yes)
    Attachment (v2-0001-Enable-parallel-SELECT-for-INSERT-INTO-.-SELECT.patch) at 2020-10-15 04:25:14 from Greg Nancarrow <gregn4422 at gmail.com> (Patch: Yes)
    Attachment (0001-Fix-row-estimate-for-ModifyTable-paths.patch) at 2020-10-12 03:10:43 from Thomas Munro <thomas.munro at gmail.com> (Patch: Yes)
    Attachment (0001-Coordinate-combo-command-IDs-with-parallel-workers.patch) at 2020-10-08 21:41:04 from Thomas Munro <thomas.munro at gmail.com> (Patch: Yes)
    Attachment (0004-ParallelInsertSelect.patch) at 2020-10-06 09:37:28 from Greg Nancarrow <gregn4422 at gmail.com> (Patch: Yes)
    Attachment (0003-ParallelInsertSelect.patch) at 2020-09-28 03:14:27 from Greg Nancarrow <gregn4422 at gmail.com> (Patch: Yes)
    Attachment (0002-ParallelInsertSelect.patch) at 2020-09-23 08:50:22 from Greg Nancarrow <gregn4422 at gmail.com> (Patch: Yes)
    Attachment (0001-ParallelInsertSelect.patch) at 2020-09-22 04:55:21 from Greg Nancarrow <gregn4422 at gmail.com> (Patch: Yes)

History

When	Who	What
2021-04-01 04:23:41	Amit Kapila (amitkapila)	Closed in commitfest 2021-03 with status: Returned with feedback
2021-03-25 15:34:20	Justin Pryzby (justinpryzby)	New status: Waiting on Author
2021-03-15 05:58:36	Justin Pryzby (justinpryzby)	Changed committer to amitkapila
2021-03-15 05:58:13	Justin Pryzby (justinpryzby)	New status: Ready for Committer
2021-02-01 12:38:37	Masahiko Sawada (masahikosawada)	Closed in commitfest 2021-01 with status: Moved to next CF
2021-01-20 01:17:09	Haiying Tang (tanghy)	Added tanghy as reviewer
2021-01-16 02:21:17	Takayuki Tsunakawa (maumau)	Added maumau as reviewer
2021-01-07 10:39:33	vigneshwaran C (vignesh.postgres)	Added vignesh.postgres as reviewer
2021-01-06 09:20:29	Antonin Houska (a.houska)	Added a.houska as reviewer
2020-12-23 02:58:28	Hou Zhijie (houzj)	Added houzj as reviewer
2020-11-25 06:22:27	Greg Nancarrow (gregn1234)	Changed authors to Greg Nancarrow (gregn1234)
2020-11-25 06:22:27	Greg Nancarrow (gregn1234)	Changed targetversion to 14
2020-11-25 06:20:50	Greg Nancarrow (gregn1234)	Attached mail thread CAJcOf-cXnB5cnMKqWEp2E2z7Mvcd04iLVmV=qpFJrR3AcrTS3g@mail.gmail.com
2020-11-25 06:20:50	Greg Nancarrow (gregn1234)	Created patch record

Edit