Re: Parallel INSERT (INTO ... SELECT ...) - Mailing list pgsql-hackers

From Greg Nancarrow
Subject Re: Parallel INSERT (INTO ... SELECT ...)
Date
Msg-id CAJcOf-dguggX1oVMDPfMv5wqogrHZSbixQtu-ZCM7d3TyFG69w@mail.gmail.com
Whole thread Raw
In response to Re: Parallel INSERT (INTO ... SELECT ...)  (vignesh C <vignesh21@gmail.com>)
List pgsql-hackers
On Fri, Jan 8, 2021 at 8:25 PM vignesh C <vignesh21@gmail.com> wrote:
>

> For one of the test you can validate that the same transaction has
> been used by all the parallel workers, you could use something like
> below to validate:
> SELECT COUNT(*) FROM (SELECT DISTINCT cmin,xmin FROM  para_insert_p1) as dt;
>

> Few includes are not required:
>  #include "executor/nodeGather.h"
>
> This include is not required in nodeModifyTable.c
>

>
> The includes indexing.h, rewriteHandler.h & lmgr.h is not required in clauses.c
>

> exeption should be exception
>
> resonable should be reasonable
>

Thanks Vignesh,
I'll be sure to make those updates in the next version of the patches.
Regards,
Greg



pgsql-hackers by date:

Previous
From: Amit Kapila
Date:
Subject: Re: Determine parallel-safety of partition relations for Inserts
Next
From: Amit Kapila
Date:
Subject: Re: Determine parallel-safety of partition relations for Inserts