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
|
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 |