Re: Parallel INSERT (INTO ... SELECT ...)

From: Greg Nancarrow <gregn4422(at)gmail(dot)com>
To: Amit Langote <amitlangote09(at)gmail(dot)com>
Cc: "Hou, Zhijie" <houzj(dot)fnst(at)cn(dot)fujitsu(dot)com>, Amit Kapila <amit(dot)kapila16(at)gmail(dot)com>, PostgreSQL Hackers <pgsql-hackers(at)lists(dot)postgresql(dot)org>, vignesh C <vignesh21(at)gmail(dot)com>, David Rowley <dgrowleyml(at)gmail(dot)com>, Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>, "Tsunakawa, Takayuki" <tsunakawa(dot)takay(at)fujitsu(dot)com>, "Tang, Haiying" <tanghy(dot)fnst(at)cn(dot)fujitsu(dot)com>
Subject: Re: Parallel INSERT (INTO ... SELECT ...)
Date: 2021-02-08 06:52:56
Message-ID: CAJcOf-d1wAm-JAEqeYFp=ghbE5HDassrzBsy-0kX=kMBmr_rBA@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

Posting an updated set of patches.
The only update is to include an improved, but only temporary, fix to
the query rewriter hasModifyingCTE issue (I separately posted a patch
for this but Tom Lane concluded that the issue is more complex than
initially thought, and no easy fix could be confidently attempted at
this point in time, so nothing ended up getting pushed - the issue
needs further investigation at another time).
See also comment in patch 0001.

Regards,
Greg Nancarrow
Fujitsu Australia

Attachment Content-Type Size
v15-0001-Enable-parallel-SELECT-for-INSERT-INTO-.-SELECT.patch application/octet-stream 22.5 KB
v15-0004-Parallel-INSERT-and-or-SELECT-for-INSERT-INTO-tests-and-doc.patch application/octet-stream 19.9 KB
v15-0003-Enable-parallel-INSERT-and-or-SELECT-for-INSERT-INTO.patch application/octet-stream 44.3 KB
v15-0002-Parallel-SELECT-for-INSERT-INTO-.-SELECT-tests-and-doc.patch application/octet-stream 63.9 KB

In response to

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Hou, Zhijie 2021-02-08 06:59:56 RE: Parallel INSERT (INTO ... SELECT ...)
Previous Message osumi.takamichi@fujitsu.com 2021-02-08 06:52:18 RE: Single transaction in the tablesync worker?