Re: Foreign key isolation tests - Mailing list pgsql-hackers

From Paul A Jungwirth
Subject Re: Foreign key isolation tests
Date
Msg-id CA+renyX+UpmRuDZjG91hz_cQsz=+Ei3kehsf1mtFB99hPD-H5w@mail.gmail.com
Whole thread Raw
In response to Re: Foreign key isolation tests  (Robert Haas <robertmhaas@gmail.com>)
List pgsql-hackers
On Mon, Aug 11, 2025 at 8:03 AM Robert Haas <robertmhaas@gmail.com> wrote:
>
> On Fri, Jul 18, 2025 at 7:26 PM Paul A Jungwirth
> <pj@illuminatedcomputing.com> wrote:
> > Thanks for taking a look! Here are new patches with those extra tests.
> > There are extensive regress tests already, so I just tested the same
> > concurrency pattern. I think the results are okay. I do get a
> > can't-serialize exception for a couple valid changes under REPEATABLE
> > READ and SERIALIZE, but I think they are expected and not a bug. (I
> > think you would see the same thing outside of FKs.)
>
> 0001 and 0003 look OK to me on a quick read-through. 0002 seems to do
> something horrible to isolation_schedule.

Ugh, sorry about that. Here is a fix.

Yours,

--
Paul              ~{:-)
pj@illuminatedcomputing.com

Attachment

pgsql-hackers by date:

Previous
From: Peter Geoghegan
Date:
Subject: Re: index prefetching
Next
From: Andres Freund
Date:
Subject: Re: Some ExecSeqScan optimizations