Re: pgsql: Add fast path for foreign key constraint checks

From: Amit Langote <amitlangote09(at)gmail(dot)com>
To: Amit Langote <amitlan(at)postgresql(dot)org>
Cc: pgsql-committers(at)lists(dot)postgresql(dot)org
Subject: Re: pgsql: Add fast path for foreign key constraint checks
Date: 2026-04-01 08:52:32
Message-ID: CA+HiwqE8rxabeSTmotNy70fcB8V9J5JcES8xxhtk0PXgzd9Q=w@mail.gmail.com
Views: Whole Thread | Raw Message | Download mbox | Resend email
Thread:
Lists: pgsql-committers

On Tue, Mar 31, 2026 at 9:21 PM Amit Langote <amitlangote09(at)gmail(dot)com> wrote:
> On Tue, Mar 31, 2026 at 5:08 PM Amit Langote <amitlangote09(at)gmail(dot)com> wrote:
> > On Tue, Mar 31, 2026 at 4:17 PM Amit Langote <amitlangote09(at)gmail(dot)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

In response to

Browse pgsql-committers by date

  From Date Subject
Next Message Amit Langote 2026-04-01 09:48:04 pgsql: Make FastPathMeta self-contained by copying FmgrInfo structs
Previous Message Amit Langote 2026-04-01 08:34:55 pgsql: Fix two issues in fast-path FK check introduced by commit 2da86c