Hi,

Attatching v1 patches, introducing options which let user manually control 
whether to use parallel dml.

About the patch:
1. add a new guc option: enable_parallel_dml (boolean)
2. add a new tableoption: parallel_dml (boolean)

   The default of both is off(false).

User can set enable_parallel_dml in postgresql.conf or seesion to enable 
parallel dml.
If user want to choose some specific to use parallel insert, they can set 
table.parallel_dml to on.

Some attention:
(1)
Currently if guc option enable_parallel_dml is set to on but table's 
parallel_dml is off,
planner still do not consider parallel for dml.

In this way, If user want to use parallel dml , they have to set 
enable_parallel_dml=on and set parallel_dml = on.
If someone dislike this, I think we can also let tableoption. parallel_dml's 
default value to on ,with this user only need
to set enable_parallel_dml=on

(2)
For the parallel_dml.
If target table is partitioned, and it's parallel_dml is set to on, planner 
will ignore
The option value of it's child. 
This is beacause we can not divide dml plan to separate table, so we just check 
the target table itself.


Thoughts and comments are welcome.

Best regards,
houzj


Attachment: v1_0004-reloption-parallel_dml-test-and-doc.patch
Description: v1_0004-reloption-parallel_dml-test-and-doc.patch

Attachment: v1_0001-guc-option-enable_parallel_dml-src.patch
Description: v1_0001-guc-option-enable_parallel_dml-src.patch

Attachment: v1_0002-guc-option-enable_parallel_dml-doc-and-test.patch
Description: v1_0002-guc-option-enable_parallel_dml-doc-and-test.patch

Attachment: v1_0003-reloption-parallel_dml-src.patch
Description: v1_0003-reloption-parallel_dml-src.patch

Reply via email to