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

Edit
Title Parallel INSERT (INTO ... SELECT ...)
Topic Performance
Created 2020-11-25 06:20:50
Last modified 2021-02-01 12:38:37 (3 weeks, 5 days ago)
Latest email 2021-02-26 09:23:55 (1 day, 12 hours ago)
Status
2021-03: Needs review
2021-01: Moved to next CF
Target version 14
Authors Greg Nancarrow (gregn1234)
Reviewers Antonin Houska (a.houska), Takayuki Tsunakawa (maumau), vignesh C (vignesh.postgres), Haiying Tang (tanghy), hou zhijie (houzj)Become reviewer
Committer
Links
Emails
Parallel INSERT (INTO ... SELECT ...)
First at 2020-09-22 04:55:21 by Greg Nancarrow <gregn4422 at gmail.com>
Latest at 2021-02-26 09:23:55 by "tanghy.fnst at fujitsu.com" <tanghy.fnst at fujitsu.com>
Latest attachment (performance test result_20210226.txt) at 2021-02-26 09:23:55 from "tanghy.fnst at fujitsu.com" <tanghy.fnst at fujitsu.com>
    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-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 vignesh 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