On Tue, Sep 22, 2020 at 10:26 AM Greg Nancarrow <gregn4...@gmail.com> wrote: > > Hi Hackers, > > Following on from Dilip Kumar's POC patch for allowing parallelism of > the SELECT part of "INSERT INTO ... SELECT ...", I have attached a POC > patch for allowing parallelism of both the INSERT and SELECT parts, > where it can be allowed. > For cases where it can't be allowed (e.g. INSERT into a table with > foreign keys, or INSERT INTO ... SELECT ... ON CONFLICT ... DO UPDATE > ...") it at least allows parallelism of the SELECT part. > Obviously I've had to update the planner and executor and > parallel-worker code to make this happen, hopefully not breaking too > many things along the way.
I feel this will be a very good performance improvement. +1 for this. Regards, Vignesh EnterpriseDB: http://www.enterprisedb.com
