| From: | Álvaro Herrera <alvherre(at)alvh(dot)no-ip(dot)org> |
|---|---|
| To: | "Justin Pryzby" <pryzby(at)telsasoft(dot)com> |
| Cc: | "Peter Eisentraut" <peter(dot)eisentraut(at)enterprisedb(dot)com>, "Amit Langote" <amitlangote09(at)gmail(dot)com>, "Japin Li" <japinli(at)hotmail(dot)com>, "Zhihong Yu" <zyu(at)yugabyte(dot)com>, "Simon Riggs" <simon(dot)riggs(at)enterprisedb(dot)com>, "pgsql-hackers(at)lists(dot)postgresql(dot)org" <pgsql-hackers(at)lists(dot)postgresql(dot)org>, "Tomas Vondra" <tomas(dot)vondra(at)enterprisedb(dot)com>, "Daniel Westermann" <dwe(at)dbi-services(dot)com>, "Erik Rijkers" <er(at)xs4all(dot)nl>, "Jaime Casanova" <jcasanov(at)systemguards(dot)com(dot)ec>, "Andres Freund" <andres(at)anarazel(dot)de> |
| Subject: | Re: support for MERGE |
| Date: | 2022-06-14 09:27:06 |
| Message-ID: | e0d96c29-6211-48bb-be50-77af87dbbf76@www.fastmail.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-hackers |
On Wed, Jun 1, 2022, at 5:28 PM, Alvaro Herrera wrote:
> Re-reading the modified paragraph, I propose "see X for a thorough
> explanation on the behavior of MERGE under concurrency". However, in
> the proposed patch the link goes to Chapter 13 "Concurrency Control",
> and the explanation that we intend to link to is hidden in subsection
> 13.2.1 "Read Committed Isolation level". So it appears that we do not
> have any explanation on how MERGE behaves in other isolation levels.
> That can't be good ...
OK, here's slightly updated wording for this, after reading the MVCC docs again. I didn't change the link to point specifically to read-committed, but I worded the reference to suggest that the referenced explanation is within each isolation level's subsection. In reality, there's not much to say about each specific command in REPEATABLE READ and SERIALIZABLE, but in the former I added MERGE to the list of commands.
I checked the pages for UPDATE and DELETE, to see if they had any explanation of concurrency, to use that as precedent. I couldn't find anything.
| Attachment | Content-Type | Size |
|---|---|---|
| v4-0001-Link-to-MVCC-docs-in-MERGE-docs.patch | text/x-patch | 3.4 KB |
| From | Date | Subject | |
|---|---|---|---|
| Next Message | kuroda.hayato@fujitsu.com | 2022-06-14 09:33:27 | RE: Multi-Master Logical Replication |
| Previous Message | Julien Rouhaud | 2022-06-14 09:13:19 | Re: Add header support to text format and matching feature |