| From: | Arne Roland <arne(dot)roland(at)malkut(dot)net> |
|---|---|
| To: | Joel Jacobson <joel(at)compiler(dot)org>, Laurenz Albe <laurenz(dot)albe(at)cybertec(dot)at>, pgsql-hackers <pgsql-hackers(at)postgresql(dot)org> |
| Cc: | Anders Granlund <anders(dot)granlund(dot)0(at)gmail(dot)com>, Andreas Karlsson <andreas(at)proxel(dot)se>, Vik Fearing <vik(at)chouppes(dot)com> |
| Subject: | Re: Key joins |
| Date: | 2026-06-04 22:41:20 |
| Message-ID: | bb9d9972-b135-4f84-836f-48956a9f11e8@malkut.net |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-hackers |
Greetings,
the change with the new patch is, that the locking is less excessive.
Foreign key paths unnecessarily blocked concurrent DML. This version of
the patch relaxes the locking to a more balanced degree. In particular
every plainly reading SELECT now takes only an ACCESS SHARE.
Regards
Arne
On 2026-06-04 6:02 PM, Joel Jacobson wrote:
> On Mon, Jun 1, 2026, at 22:36, Joel Jacobson wrote:
>> Ops, that extra ERROR: line was a mistake, sorry about that.
>>
>> The corresponding subsection has now also been fixed in the web version:
>> https://keyjoin.org/#sec7.4.13
> v9 rebases over Stamp 19beta1 and improves one type of error message in 0002.
>
> The affected queries were already rejected correctly. The change is
> only that DETAIL now first reports if there is not even a matching
> referential constraint.
>
> 0001 and 0003 are unchanged from v8.
>
> /Joel
| Attachment | Content-Type | Size |
|---|---|---|
| v10-0003-Add-information_schema.view_constraint_usage.patch.gz | application/gzip | 2.9 KB |
| v10-0002-Implement-FOR-KEY-join-support.patch.gz | application/gzip | 182.5 KB |
| v10-0001-Serialize-routine-definition-changes-with-depend.patch.gz | application/gzip | 1.9 KB |
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Tatsuo Ishii | 2026-06-04 22:49:27 | Re: Row pattern recognition |
| Previous Message | Tom Lane | 2026-06-04 22:31:24 | Re: Improving the names generated for indexes on expressions |