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 count: 4, First patch: +761−12, All patches: +1698−12
Tags Performance
Created 2024-12-20 04:24:55
Last modified 2026-02-28 06:41:06 (3 hours ago)
Latest email 2026-02-28 07:08:05 (2 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 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-02-28 07:08:05 by Amit Langote <amitlangote09 at gmail.com>
Latest 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>
    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-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