ATTACH PARTITION cost grows linearly with pg_constraint size (seqscan in CloneFkReferenced), much worse since not-null constraints are in pg_constraint (PG 18)

Edit
ID 7365
Title ATTACH PARTITION cost grows linearly with pg_constraint size (seqscan in CloneFkReferenced), much worse since not-null constraints are in pg_constraint (PG 18)
CI (CFBot) Summary
Stats (from CFBot) Patch version: v2, Patch count: 1, First patch: +23−15, All patches: +23−15
Tags Performance
Created 2026-09-29 20:25:33
Last modified 2026-09-29 20:25:33 (1 hour ago)
Latest email 2026-09-29 18:45:31 (3 hours ago)
Status
PG20-3 (2026-11-01 – 2026-11-30): Needs review
Target version 20
Authors Manu Reyes Bravo (manu15)
Reviewers Become reviewer
Committer
Links
Emails
ATTACH PARTITION cost grows linearly with pg_constraint size (seqscan in CloneFkReferenced), much worse since not-null constraints are in pg_constraint (PG 18)
First at 2026-09-29 11:38:42 by Bernhard Wonisch <bernhard.wonisch at gmx.at>
Latest at 2026-09-29 18:45:31 by Álvaro Herrera <alvherre at kurilemu.de>
Latest attachment (v2-0001-Index-pg_constraint.confrelid-to-avoid-seqscans-i.patch) at 2026-09-29 18:02:09 from Manu <manuelreyesbravo at gmail.com>
    Attachment (v2-0001-Index-pg_constraint.confrelid-to-avoid-seqscans-i.patch) at 2026-09-29 18:02:09 from Manu <manuelreyesbravo at gmail.com> (Patch: No)
    Attachment (v1-0001-Index-pg_constraint.confrelid-to-avoid-a-seqscan-.patch) at 2026-09-29 16:08:24 from Manu <manuelreyesbravo at gmail.com> (Patch: No)
    Attachment (unknown_filename) at 2026-09-29 11:38:42 from Bernhard Wonisch <bernhard.wonisch at gmx.at> (Patch: No)
History
When Who What
2026-09-29 20:25:33 Manu Reyes Bravo (manu15) Attached mail thread trinity-08d3329b-f6b2-4c11-91d7-2198e50bf4fc-1790681922354@trinity-msg-rest-gmx-gmx-live-58cc8f554d-c56lm
2026-09-29 20:25:33 Manu Reyes Bravo (manu15) Created patch record
Edit