confusion about Re: Write operations in parallel mode's update part.

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
|

Browse pgsql-hackers by date

  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