RE: Determine parallel-safety of partition relations for Inserts - Mailing list pgsql-hackers

From Hou, Zhijie
Subject RE: Determine parallel-safety of partition relations for Inserts
Date
Msg-id a933a8f05d6c449db070e6d439f8a975@G08CNEXMBPEKD05.g08.fujitsu.local
Whole thread Raw
In response to RE: Determine parallel-safety of partition relations for Inserts  ("tsunakawa.takay@fujitsu.com" <tsunakawa.takay@fujitsu.com>)
Responses Re: Determine parallel-safety of partition relations for Inserts  (Amit Kapila <amit.kapila16@gmail.com>)
List pgsql-hackers
> From: Amit Kapila <amit.kapila16@gmail.com>
> > Good question. I think if we choose to have a separate parameter for
> > DML, it can probably a boolean to just indicate whether to enable
> > parallel DML for a specified table and use the parallel_workers
> > specified in the table used in SELECT.
> 
> Agreed.

Hi

I have an issue about the parameter for DML.

If we define the parameter as a tableoption.

For a partitioned table, if we set the parent table's parallel_dml=on,
and set one of its partition parallel_dml=off, it seems we can not divide the plan for the separate table.

For this case, should we just check the parent's parameter ?

Best regards,
houzj



pgsql-hackers by date:

Previous
From: Andrey Borodin
Date:
Subject: Re: pglz compression performance, take two
Next
From: Heikki Linnakangas
Date:
Subject: Re: Perform COPY FROM encoding conversions in larger chunks