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

From: Amit Langote <amitlangote09(at)gmail(dot)com>
To: Chao Li <li(dot)evan(dot)chao(at)gmail(dot)com>
Cc: Junwang Zhao <zhjwpku(at)gmail(dot)com>, Haibo Yan <tristan(dot)yim(at)gmail(dot)com>, Pavel Stehule <pavel(dot)stehule(at)gmail(dot)com>, PostgreSQL-development <pgsql-hackers(at)postgresql(dot)org>, Tomas Vondra <tomas(at)vondra(dot)me>
Subject: Re: Eliminating SPI / SQL from some RI triggers - take 3
Date: 2026-04-03 05:52:45
Message-ID: CA+HiwqGFRAH2O5bGpNMErFopFyn-2-Zu3+5y+BFQim9TE8z+Pw@mail.gmail.com
Views: Whole Thread | Raw Message | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

Hi,

On Thu, Apr 2, 2026 at 5:00 PM Chao Li <li(dot)evan(dot)chao(at)gmail(dot)com> wrote:
> > On Apr 2, 2026, at 15:41, Amit Langote <amitlangote09(at)gmail(dot)com> wrote:
> > Will push tomorrow morning (Friday) barring objections.
> > <v17-0001-Batch-FK-rows-and-use-SK_SEARCHARRAY-for-fast-pa.patch>
>
> With a quick eyeball review, I found a typo:
> ```
> + * relcache invalidation. The entry itself is torn down at batch at batch end
> ```
>
> There are two “at batch”.

Thanks for spotting that. Fixed and pushed.

> I plan to spend time testing and tracing this patch tomorrow. But I don’t want to block your progress, if I find anything, I will report to you.

Sure, I didn't want to leave committing this to the weekend or the next week.

--
Thanks, Amit Langote

In response to

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Fujii Masao 2026-04-03 06:13:39 Re: Exit walsender before confirming remote flush in logical replication
Previous Message Ashutosh Bapat 2026-04-03 05:37:03 Re: SQL/PGQ: All properties reference