Eliminating SPI / SQL from some RI trigger functions

Edit
ID 5450
Title Eliminating SPI / SQL from some RI trigger functions
CI (CFBot) Summary
Stats (from CFBot) Patch version: v4, Patch count: 3, First patch: +45−25, All patches: +423−43
Tags Performance
Created 2024-12-20 04:24:55
Last modified 2026-04-09 06:37:59 (2 days ago)
Latest email 2026-04-09 16:01:58 (yesterday)
Status
PG19-Final (2026-03-01 – 2026-04-09): Committed
PG19-Drafts (2025-06-22 – 2026-02-28): Moved to different CF
PG19-1 (2025-07-01 – 2025-07-31): Moved to different CF
2025-03 (2025-03-01 – 2025-04-08): Moved to different CF
2025-01 (2025-01-01 – 2025-01-31): Moved to different CF
Target version 19
Authors Amit Langote (amitlan)
Reviewers Haibo Yan (billyean)Become reviewer
Committer Amit Langote (amitlan)
Links
Emails
Eliminating SPI / SQL from some RI triggers - take 3
First at 2024-12-20 04:23:35 by Amit Langote <amitlangote09 at gmail.com>
Latest at 2026-04-09 16:01:58 by Sandro Santilli <strk at kbt.io>
Latest attachment (v4-0002-Move-afterTriggerFiringDepth-into-AfterTriggersDa.patch) at 2026-04-09 08:40:49 from Amit Langote <amitlangote09 at gmail.com>
    Attachment (v4-0002-Move-afterTriggerFiringDepth-into-AfterTriggersDa.patch) at 2026-04-09 08:40:49 from Amit Langote <amitlangote09 at gmail.com> (Patch: Yes)
    Attachment (v3-0004-Store-batch-callbacks-at-the-appropriate-level-ra.patch) at 2026-04-08 14:26:21 from Amit Langote <amitlangote09 at gmail.com> (Patch: Yes)
    Attachment (v2-0001-Modified-test-suite-from-Evan-s-patch.patch) at 2026-04-08 09:58:23 from Amit Langote <amitlangote09 at gmail.com> (Patch: Yes)
    Attachment (v1-0001-Add-nkeys-parameter-to-recheck_matched_pk_tuple.patch) at 2026-04-08 01:23:59 from Amit Langote <amitlangote09 at gmail.com> (Patch: Yes)
    Attachment (v1-0001-Fix-RI-fast-path-crash-when-FK-triggers-fire-unde.patch) at 2026-04-07 12:59:59 from Evan Montgomery-Recht <montge at mianetworks.net> (Patch: Yes)
    Attachment (v2-0001-Fix-deferred-FK-check-batching-introduced-by-comm.patch) at 2026-04-06 09:45:05 from Amit Langote <amitlangote09 at gmail.com> (Patch: Yes)
    Attachment (fix_deferred_trigger.diff) at 2026-04-03 08:57:36 from Chao Li <li.evan.chao at gmail.com> (Patch: Yes)
    Attachment (v17-0001-Batch-FK-rows-and-use-SK_SEARCHARRAY-for-fast-pa.patch) at 2026-04-02 07:41:30 from Amit Langote <amitlangote09 at gmail.com> (Patch: No)
    Attachment (v16-0001-Batch-FK-rows-and-use-SK_SEARCHARRAY-for-fast-pa.patch) at 2026-04-01 12:18:14 from Amit Langote <amitlangote09 at gmail.com> (Patch: No)
    Attachment (v15-0001-Batch-FK-rows-and-use-SK_SEARCHARRAY-for-fast-pa.patch) at 2026-04-01 09:51:10 from Amit Langote <amitlangote09 at gmail.com> (Patch: No)
    Attachment (v14-0001-Make-FastPathMeta-self-contained-by-copying-Fmgr.patch) at 2026-04-01 08:51:21 from Amit Langote <amitlangote09 at gmail.com> (Patch: Yes)
    Attachment (v13-0001-Fix-two-issues-in-fast-path-FK-check-introduced-.patch) at 2026-03-31 12:15:22 from Amit Langote <amitlangote09 at gmail.com> (Patch: Yes)
    Attachment (v1-0001-Fix-a-use-after-problem-in-ri_LoadConstraintInfo.patch) at 2026-03-31 09:09:19 from Chao Li <li.evan.chao at gmail.com> (Patch: Yes)
    Attachment (v12-0001-Add-fast-path-for-foreign-key-constraint-checks.patch) at 2026-03-30 11:15:05 from Amit Langote <amitlangote09 at gmail.com> (Patch: No)
    Attachment (v11-0002-Batch-FK-rows-and-use-SK_SEARCHARRAY-for-fast-pa.patch) at 2026-03-30 04:55:07 from Amit Langote <amitlangote09 at gmail.com> (Patch: No)
    Attachment (v10-0002-Batch-FK-rows-and-use-SK_SEARCHARRAY-for-fast-pa.patch) at 2026-03-25 00:41:11 from Amit Langote <amitlangote09 at gmail.com> (Patch: No)
    Attachment (v9_delta.patch.txt) at 2026-03-24 13:56:18 from Amit Langote <amitlangote09 at gmail.com> (Patch: Yes)
    Attachment (v9-0003-Batch-FK-rows-and-use-SK_SEARCHARRAY-for-fast-pat.patch) at 2026-03-24 11:47:17 from Amit Langote <amitlangote09 at gmail.com> (Patch: Yes)
    Attachment (v8-0001-Add-fast-path-for-foreign-key-constraint-checks.patch) at 2026-03-19 16:19:53 from Junwang Zhao <zhjwpku at gmail.com> (Patch: Yes)
    Attachment (v7-0004-Refactor-RI-fast-path-to-use-scan_cxt-and-flush_c.patch) at 2026-03-18 15:34:30 from Junwang Zhao <zhjwpku at gmail.com> (Patch: Yes)
    Attachment (v6-0003-Batch-FK-rows-and-use-SK_SEARCHARRAY-for-fast-pat.patch) at 2026-03-16 14:03:41 from Amit Langote <amitlangote09 at gmail.com> (Patch: Yes)
    Attachment (v5-0005-Use-SK_SEARCHARRAY-for-batched-fast-path-FK-probe.patch) at 2026-03-10 12:28:47 from Junwang Zhao <zhjwpku at gmail.com> (Patch: Yes)
    Attachment (fk-batch-insert.csv) at 2026-03-01 12:22:49 from Tomas Vondra <tomas at vondra.me> (Patch: No)
    Attachment (0001-Add-fast-path-for-foreign-key-constraint-checks.patch) at 2026-02-28 07:08:05 from Amit Langote <amitlangote09 at gmail.com> (Patch: Yes)
    Attachment (v3-0001-Add-fast-path-for-foreign-key-constraint-checks.patch) at 2026-02-19 09:21:27 from Amit Langote <amitlangote09 at gmail.com> (Patch: Yes)
    Attachment (v2-0002-Cache-fast-path-metadata-for-foreign-key-checks.patch) at 2025-12-01 06:09:00 from Junwang Zhao <zhjwpku at gmail.com> (Patch: Yes)
    Attachment (v1-0003-Avoid-using-an-SQL-query-for-some-RI-checks.patch) at 2024-12-20 04:23:35 from Amit Langote <amitlangote09 at gmail.com> (Patch: Yes)
History
When Who What
2026-04-09 06:37:59 Zhao Junwang (zhjwpku) Closed in commitfest PG19-Final with status: Committed
2026-04-07 20:42:31 CFbot Patch does not need rebase anymore
2026-04-06 09:47:18 Amit Langote (amitlan) Closed in commitfest PG19-Final with status: Committed
2026-04-06 09:47:18 Amit Langote (amitlan) Changed committer to amitlan
2026-04-03 09:06:27 CFbot Patch needs rebase
2026-03-17 00:22:24 Haibo Yan (billyean) Added billyean as reviewer
2026-02-28 06:41:06 Amit Langote (amitlan) New status: Needs review
2026-02-28 06:41:01 Amit Langote (amitlan) Moved from CF PG19-Drafts to CF PG19-Final
2025-12-01 06:38:27 CFbot Patch does not need rebase anymore
2025-10-21 04:03:46 Amit Langote (amitlan) Moved from CF PG19-1 to CF PG19-Drafts
2025-10-21 04:02:48 Amit Langote (amitlan) New status: Waiting on Author
2025-10-21 03:58:30 Amit Langote (amitlan) Closed in commitfest PG19-1 with status: Withdrawn
2025-04-03 10:18:54 Amit Langote (amitlan) Closed in commitfest 2025-03 with status: Moved to next CF
2025-04-01 06:53:15 vigneshwaran C (vignesh.postgres) New status: Waiting on Author
2025-03-17 21:45:35 CFbot Patch needs rebase
2025-02-27 00:55:15 Amit Langote (amitlan) Closed in commitfest 2025-01 with status: Moved to next CF
2025-02-27 00:55:10 Amit Langote (amitlan) Changed targetversion to 19
2024-12-20 04:25:10 Amit Langote (amitlan) Changed authors to Amit Langote (amitlan)
2024-12-20 04:25:10 Amit Langote (amitlan) Changed targetversion to 18
2024-12-20 04:24:55 Amit Langote (amitlan) Attached mail thread CA+HiwqF4C0ws3cO+z5cLkPuvwnAwkSp7sfvgGj3yQ=Li6KNMqA@mail.gmail.com
2024-12-20 04:24:55 Amit Langote (amitlan) Created patch record
Edit