Request a Demo
Home   >   mailing lists

Re: pgsql: Add fast path for foreign key constraint checks - Mailing list pgsql-committers

From Amit Langote
Subject Re: pgsql: Add fast path for foreign key constraint checks
Date
Msg-id CA+HiwqE8rxabeSTmotNy70fcB8V9J5JcES8xxhtk0PXgzd9Q=w@mail.gmail.com
Whole thread
In response to Re: pgsql: Add fast path for foreign key constraint checks  (Amit Langote <amitlangote09@gmail.com>)
List pgsql-committers
Tree view 
On Tue, Mar 31, 2026 at 9:21 PM Amit Langote <amitlangote09@gmail.com> wrote:
> On Tue, Mar 31, 2026 at 5:08 PM Amit Langote <amitlangote09@gmail.com> wrote:
> > On Tue, Mar 31, 2026 at 4:17 PM Amit Langote <amitlangote09@gmail.com> wrote:
> > > I'm looking at the failures on prion:
> > > https://buildfarm.postgresql.org/cgi-bin/show_log.pl?nm=prion&dt=2026-03-31%2006%3A53%3A05
> > >
> > > They all look like this:
> > > +ERROR:  could not open relation with OID 2139062143
> >
> > I've pushed a fix: 68a8601ee9ec.
>
> Found additional issues when testing locally with
> CLOBBER_CACHE_ALWAYS: a dangling fpmeta pointer after constraint cache
> invalidation, and riinfo going stale inside ri_FastPathCheck() after
> relation opens. The attached patch fixes both. I'll apply it tomorrow
> morning barring objections.

Pushed: e484b0eea6.

--
Thanks, Amit Langote

pgsql-committers by date:

Previous
From: Amit Langote
Date:
Subject: pgsql: Fix two issues in fast-path FK check introduced by commit 2da86c
Next
From: Amit Langote
Date:
Subject: pgsql: Make FastPathMeta self-contained by copying FmgrInfo structs