Re: Determine parallel-safety of partition relations for Inserts

From: Greg Nancarrow <gregn4422(at)gmail(dot)com>
To: "Hou, Zhijie" <houzj(dot)fnst(at)cn(dot)fujitsu(dot)com>
Cc: 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>, Amit Langote <amitlangote09(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>
Subject: Re: Determine parallel-safety of partition relations for Inserts
Date: 2021-02-01 23:55:40
Message-ID: CAJcOf-er_wSz_WCKg=9Eo37ag_yseNKREe3Yh3q5DXpD1xCaCQ@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

On Mon, Feb 1, 2021 at 4:02 PM Hou, Zhijie <houzj(dot)fnst(at)cn(dot)fujitsu(dot)com> wrote:
>
> Attatching v2 patch which addressed the comments above.
>
> Some further refactor:
>
> Introducing a new function is_parallel_possible_for_modify() which decide whether to do safety check.
>
> IMO, It seems more readable to extract all the check that we can do before the safety-check and put them
> in the new function.
>
> Please consider it for further review.
>

I've updated your v2 patches and altered some comments and
documentation changes (but made no code changes) - please compare
against your v2 patches, and see whether you agree with the changes to
the wording.
In the documentation, you will also notice that in your V2 patch, it
says that the "parallel_dml_enabled" table option defaults to false.
As it actually defaults to true, I changed that in the documentation
too.

Regards,
Greg Nancarrow
Fujitsu Australia

Attachment Content-Type Size
v3_0004-reloption-parallel_dml-test-and-doc.patch application/octet-stream 6.6 KB
v3_0001-guc-option-enable_parallel_dml-src.patch application/octet-stream 3.7 KB
v3_0002-guc-option-enable_parallel_dml-doc-and-test.patch application/octet-stream 5.1 KB
v3_0003-reloption-parallel_dml-src.patch application/octet-stream 8.7 KB

In response to

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Zhihong Yu 2021-02-02 00:04:11 Re: Determine parallel-safety of partition relations for Inserts
Previous Message Bruce Momjian 2021-02-01 23:52:14 Re: Key management with tests