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

Edit

ID 2844

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

Topic Performance

Created 2020-11-25 06:20:50

Last modified 2021-04-01 04:23:41 (3 years, 7 months ago)

Latest email 2021-04-01 04:26:45 (3 years, 7 months ago)

Status

2021-03: Returned with feedback

2021-01: Moved to next CF

Target version 14

Authors Greg Nancarrow (gregn1234)

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

Committer Amit Kapila (amitkapila)

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/2844
git checkout commitfest/cf/2844

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