public inbox for [email protected]  

help / color / mirror / Atom feed
From: Arne Roland <[email protected]>
To: Joel Jacobson <[email protected]>
To: Laurenz Albe <[email protected]>
To: pgsql-hackers <[email protected]>
Cc: Anders Granlund <[email protected]>
Cc: Andreas Karlsson <[email protected]>
Cc: Vik Fearing <[email protected]>
Subject: Re: Key joins
Date: Fri, 5 Jun 2026 00:41:20 +0200
Message-ID: <[email protected]> (raw)
In-Reply-To: <[email protected]>
References: <[email protected]>
	<[email protected]>
	<[email protected]>
	<[email protected]>
	<[email protected]>
	<[email protected]>
	<[email protected]>
	<[email protected]>
	<[email protected]>

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

Attachments:

  [application/gzip] v10-0003-Add-information_schema.view_constraint_usage.patch.gz (2.9K, ../[email protected]/2-v10-0003-Add-information_schema.view_constraint_usage.patch.gz)
  download

  [application/gzip] v10-0002-Implement-FOR-KEY-join-support.patch.gz (182.5K, ../[email protected]/3-v10-0002-Implement-FOR-KEY-join-support.patch.gz)
  download

  [application/gzip] v10-0001-Serialize-routine-definition-changes-with-depend.patch.gz (1.9K, ../[email protected]/4-v10-0001-Serialize-routine-definition-changes-with-depend.patch.gz)
  download

view thread (26+ messages)  latest in thread

reply
Reply instructions:

You may reply publicly to this message via plain-text email
using any one of the following methods:

* Reply to all the recipients using the --to and --cc options:
  reply via email

  To: [email protected]
  Cc: [email protected], [email protected], [email protected], [email protected], [email protected], [email protected]
  Subject: Re: Key joins
  In-Reply-To: <[email protected]>

* Save the following mbox file, import it into your mail client,
  and reply-to-all from there: mbox

This inbox is served by agora; see mirroring instructions
for how to clone and mirror all data and code used for this inbox