Request a Demo
Home   >   mailing lists

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) - Mailing list pgsql-hackers

From Manu
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
Msg-id 179097138709.671463.9181664331738655353@gmail.com
Whole thread
In response to 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)  (Manu <manuelreyesbravo@gmail.com>)
List pgsql-hackers
Tree view 
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

pgsql-hackers by date:

Previous
From: Nurlan Tulemisov
Date:
Subject: Re: support parameterized (LATERAL) foreign joins
Next
From: Osama Abdul Qader
Date:
Subject: Re: Severe performance degradation with concurrent updates due to excessive EvalPlanQual (EPQ) re‑evaluation