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

Title

CI (CFBot)

Summary

Stats (from CFBot)

Patch version: v10, Patch count: 1, First patch: +92−20, All patches: +92−20

Tags

Performance

Created

2026-09-29 20:25:33

Last modified

2026-11-04 23:47:53 (5 days ago)

Latest email

2026-11-04 23:46:49 (5 days ago)

Status

PG20-3 (2026-11-01 – 2026-11-30): Needs review

Target version

Authors

Manuel Reyes Bravo (manu15)

Reviewers

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)
Do we need an index on pg_constraint.confrelid?: First at 2026-10-24 10:21:37 by David Rowley <dgrowleyml at gmail.com>
Latest at 2026-11-04 23:46:49 by Manu <manuelreyesbravo at gmail.com>
Latest attachment (v10-0001-Index-pg_constraint.confrelid-to-avoid-seqscans-.patch) at 2026-11-04 23:46:49 from Manu <manuelreyesbravo at gmail.com>
    Attachment (v10-0001-Index-pg_constraint.confrelid-to-avoid-seqscans-.patch) at 2026-11-04 23:46:49 from Manu <manuelreyesbravo at gmail.com> (Patch: No)
    Attachment (v9-0001-Index-pg_constraint.confrelid-to-avoid-seqscans-o.patch) at 2026-10-27 04:46:44 from Manu <manuelreyesbravo at gmail.com> (Patch: No)
    Attachment (v6-0001-Index-pg_constraint.confrelid-to-avoid-seqscans-o.patch) at 2026-10-26 19:02:25 from Manu <manuelreyesbravo at gmail.com> (Patch: No)
    Attachment (pg_upgrade_catalog_repro.sql) at 2026-10-24 10:21:37 from David Rowley <dgrowleyml at gmail.com> (Patch: No)

History

When	Who	What
2026-11-04 23:47:53	Manuel Reyes Bravo (manu15)	Attached mail thread CAApHDvpxGcb-_ddd+qL+F=Vmv4d3WZNbUCi3WQyj0HcFnC9v1g@mail.gmail.com
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