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: v3, Patch count: 1, First patch: +22−14, All patches: +22−14
Tags Performance
Created 2026-09-29 20:25:33
Last modified 2026-10-04 22:30:16 (2 weeks ago)
Latest email 2026-10-16 07:32:16 (4 days ago)
Status
PG20-3 (2026-11-01 – 2026-11-30): Needs review
Target version 20
Authors Manuel 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-10-16 07:32:16 by Álvaro Herrera <alvherre at kurilemu.de>
Latest attachment (v3-0001-Index-pg_constraint.confrelid-to-avoid-seqscans-i.patch) at 2026-10-02 20:03:07 from Manu <manuelreyesbravo at gmail.com>
    Attachment (v3-0001-Index-pg_constraint.confrelid-to-avoid-seqscans-i.patch) at 2026-10-02 20:03:07 from Manu <manuelreyesbravo at gmail.com> (Patch: No)
    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)
Partial indexes on system catalogs
First at 2026-10-01 21:49:21 by Manu <manuelreyesbravo at gmail.com>
Latest at 2026-10-04 23:16:26 by Manu <manuelreyesbravo at gmail.com>
Latest attachment (v4-0001-Index-pg_constraint.confrelid-to-avoid-seqscans-o.patch) at 2026-10-04 23:16:26 from Manu <manuelreyesbravo at gmail.com>
    Attachment (v4-0001-Index-pg_constraint.confrelid-to-avoid-seqscans-o.patch) at 2026-10-04 23:16:26 from Manu <manuelreyesbravo at gmail.com> (Patch: No)
    Attachment (partial-catalog-index-poc-v1.patch.txt) at 2026-10-01 21:49:21 from Manu <manuelreyesbravo at gmail.com> (Patch: No)
History
When Who What
2026-10-04 22:30:16 Manuel Reyes Bravo (manu15) Attached mail thread 179089136170.117434.3768797469846977966@gmail.com
2026-10-02 21:04:41 CFbot Patch does not need rebase anymore
2026-10-02 19:53:32 CFbot Patch needs rebase
2026-09-29 20:25:33 Manuel 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 Manuel Reyes Bravo (manu15) Created patch record
Edit