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

From: Manu <manuelreyesbravo(at)gmail(dot)com>
To: Álvaro Herrera <alvherre(at)kurilemu(dot)de>
Cc: Bernhard Wonisch <bernhard(dot)wonisch(at)gmx(dot)at>, pgsql-hackers(at)lists(dot)postgresql(dot)org
Subject: Re: ATTACH PARTITION cost grows linearly with pg_constraint size (seqscan in CloneFkReferenced), much worse since not-null constraints are in pg_constraint (PG 18)
Date: 2026-10-02 20:03:07
Message-ID: 179097138709.671463.9181664331738655353@gmail.com
Views: Whole Thread | Raw Message | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

Hi,

v3 attached, rebased on current master for CF 7365. The only change
from v2 is that it no longer bumps catversion, which was the conflict;
that's left to the committer. make check passes.

Regards,
Manu

Attachment Content-Type Size
v3-0001-Index-pg_constraint.confrelid-to-avoid-seqscans-i.patch text/x-patch 6.2 KB

In response to

Browse pgsql-hackers by date

  From Date Subject
Next Message Osama Abdul Qader 2026-10-02 20:34:26 Re: Severe performance degradation with concurrent updates due to excessive EvalPlanQual (EPQ) re‑evaluation
Previous Message Nurlan Tulemisov 2026-10-02 19:49:26 Re: support parameterized (LATERAL) foreign joins