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: | confusion about Re: Write operations in parallel mode's update part. |
Date: | 2023-11-23 04:55:43 |
Message-ID: | 70790ac5.1aa4.18bfa88add7.Coremail.jiye_sw@126.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-hackers |
hi,
i found a discuss about parallel dml, it wrote as follow,
PostgreSQL: Re: Write operations in parallel mode
Make updates and deletes parallel-restricted rather than
parallel-unsafe - i.e. allow updates and deletes but only in the
leader. This similarly would allow Update -> Gather -> whatever and
Delete -> Gather -> whatever. For this, you'd need a shared combo CID
hash so that workers can learn about new combo CIDs created by the
leader.
i have some questions about this,
when do update => gather => whatever, all update jobs done by leader , thus it know itself combo cid mapping,
and only other workers can not learn about that, so why those workers must know leader's combo cids? why those worker
need see leader's updated tuples, could you give me some example cases or Unusual scenes for for this parallel update?
| |
jiye
|
|
jiye_sw(at)126(dot)com
|
From | Date | Subject | |
---|---|---|---|
Next Message | Amit Kapila | 2023-11-23 05:13:47 | Re: Synchronizing slots from primary to standby |
Previous Message | Bruce Momjian | 2023-11-23 04:41:56 | Re: [HACKERS] Typo in sequence.c |