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: v8, Patch count: 3, First patch: +723−12, All patches: +1683−13
Tags Performance
Created 2024-12-20 04:24:55
Last modified 2026-02-28 06:41:06 (2 weeks ago)
Latest email 2026-03-19 16:19:53 (13 hours ago)
Status
PG19-Final (2026-03-01 – 2026-03-31): Needs review
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
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-03-19 16:19:53 by Junwang Zhao <zhjwpku at gmail.com>
Latest 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>
    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-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