Re: Huge memory consumption on partitioned table with FKs - Mailing list pgsql-hackers

From Amit Langote
Subject Re: Huge memory consumption on partitioned table with FKs
Date
Msg-id CA+HiwqGKkWYgbpkNkxJOO5Uto7JMs3im-x8K8qmn_f9W+wzesw@mail.gmail.com
Whole thread Raw
In response to Re: Huge memory consumption on partitioned table with FKs  (Kyotaro Horiguchi <horikyota.ntt@gmail.com>)
Responses Re: Huge memory consumption on partitioned table with FKs
Re: Huge memory consumption on partitioned table with FKs
List pgsql-hackers
On Fri, Dec 4, 2020 at 12:05 PM Kyotaro Horiguchi
<horikyota.ntt@gmail.com> wrote:
> > Also, the comment that was in RI_ConstraintInfo now appears in
> > RI_ConstraintParam, and the new struct (RI_ConstraintInfo) is now
> > undocumented.  What is the relationship between those two structs?  I
> > see that they have pointers to each other, but I think the relationship
> > should be documented more clearly.
>
> I'm not sure the footprint of this patch worth doing but here is a bit
> more polished version.

I noticed that the foreign_key test fails and it may have to do with
the fact that a partition's param info remains attached to the
parent's RI_ConstraintInfo even after it's detached from the parent
table using DETACH PARTITION.

-- 
Amit Langote
EDB: http://www.enterprisedb.com



pgsql-hackers by date:

Previous
From: Bharath Rupireddy
Date:
Subject: Re: Parallel Inserts in CREATE TABLE AS
Next
From: Tomas Vondra
Date:
Subject: Re: PoC/WIP: Extended statistics on expressions