Horton

Re: Eliminating SPI / SQL from some RI triggers - take 3

Pavel Stehule <pavel.stehule@gmail.com>

View thread
From: Pavel Stehule <pavel.stehule@gmail.com>
To: Amit Langote <amitlangote09@gmail.com>
Cc: PostgreSQL-development <pgsql-hackers@postgresql.org>, Junwang Zhao <zhjwpku@gmail.com>
Date: 2025-10-21T05:10:10Z
Lists: pgsql-hackers

Commits

Same data as JSON: GET /api/v1/messages/:b64id/commits the thread's linked commits as JSON, with link sources. API reference →

  1. Optimize fast-path FK checks with batched index probes

  2. Add fast path for foreign key constraint checks

Hi

út 21. 10. 2025 v 6:07 odesílatel Amit Langote <amitlangote09@gmail.com>
napsal:

> On Thu, Apr 3, 2025 at 7:19 PM Amit Langote <amitlangote09@gmail.com>
> wrote:
> > On Fri, Dec 20, 2024 at 1:23 PM Amit Langote <amitlangote09@gmail.com>
> wrote:
> > > We discussed $subject at [1] and [2] and I'd like to continue that
> > > work with the hope to commit some part of it for v18.
> >
> > I did not get a chance to do any further work on this in this cycle,
> > but plan to start working on it after beta release, so moving this to
> > the next CF.  I will post a rebased patch after the freeze to keep the
> > bots green for now.
>
> Sorry for the inactivity. I've moved the patch entry in the CF app to
> PG19-Drafts, since I don't plan to work on it myself in the immediate
> future. However, Junwang Zhao has expressed interest in taking this
> work forward, and I look forward to working with him on it.
>

This is very interesting and important feature - I can help with testing
and review if it will be necessary

Regards

Pavel



>
> --
> Thanks, Amit Langote
>
>
>