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

Sandro Santilli <strk@kbt.io>

From: Sandro Santilli <strk@kbt.io>

To: Tomas Vondra <tomas@vondra.me>

Cc: Amit Langote <amitlangote09@gmail.com>, Junwang Zhao <zhjwpku@gmail.com>, Pavel Stehule <pavel.stehule@gmail.com>, PostgreSQL-development <pgsql-hackers@postgresql.org>

Date: 2026-04-09T11:07:50Z

Lists: pgsql-hackers

On Mon, Mar 02, 2026 at 01:34:41PM +0100, Tomas Vondra wrote:
> 
> TBH I haven't noticed the memory context issue myself, I only noticed
> because the builds with index prefetch started crashing.

We're getting a crash in PostGIS too, since that commit was merged into
the master branch, see https://trac.osgeo.org/postgis/ticket/6066

The crash is triggered a C function using SPI.

--strk;

Commits

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

Fix some const qualifier use in ri_triggers.c
- 1b9dc2cb7574 19 (unreleased) landed
doc: Improve consistency of parallel vacuum description.
- 2a3d2f9f68da 19 (unreleased) cited
Move afterTriggerFiringDepth into AfterTriggersData
- d6e96bacd3c0 19 (unreleased) landed
Fix typo left by 34a30786293
- 03029409b409 19 (unreleased) landed
Fix RI fast-path crash under nested C-level SPI
- 34a307862930 19 (unreleased) landed
Add nkeys parameter to recheck_matched_pk_tuple()
- e1cc57fabd6c 19 (unreleased) landed
Fix deferred FK check batching introduced by commit b7b27eb41a5
- 5c54c3ed1b93 19 (unreleased) landed
Optimize fast-path FK checks with batched index probes
- b7b27eb41a5c 19 (unreleased) landed
Make FastPathMeta self-contained by copying FmgrInfo structs
- edee5634564d 19 (unreleased) landed
Add fast path for foreign key constraint checks
- 2da86c1ef9b5 19 (unreleased) landed