some confusion about parallel insert select in postgres parallel dml develop

From: jiye <jiye_sw(at)126(dot)com>
To: "pgsql-hackers(at)lists(dot)postgresql(dot)org" <pgsql-hackers(at)lists(dot)postgresql(dot)org>
Subject: some confusion about parallel insert select in postgres parallel dml develop
Date: 2024-04-10 03:25:08
Message-ID: 1df05990.8e1c.18ec609b4cb.Coremail.jiye_sw@126.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

Dears,

this is a developer of postgresql and currently engaged in research of parallel dml. I read lot of mail list about postgres parallel insert select or other related developing jobs,
but i could not understand why should we determine parallel-safety of partition relations in parallel dml even just allow parallel query in insert select statement ,
i consider that modify job do in leader process and partition exprs check also in leader node, isn't that safty enough. in the other words, if we only build a parallel query planner in insert select and forbit parallel insert jobs, should we skip any parallel safty check about target relation and build parallel query plan directly ?

could anyone give me some suggestion about this confusions.

Best Regards

Tomas Ji

| |
jiye
|
|
jiye_sw(at)126(dot)com
|

Browse pgsql-hackers by date

  From Date Subject
Next Message Jeff Davis 2024-04-10 04:16:53 Re: Improve eviction algorithm in ReorderBuffer
Previous Message Michael Paquier 2024-04-10 03:13:40 Re: Improve eviction algorithm in ReorderBuffer