Re: Huge memory consumption on partitioned table with FKs

From: David Steele <david(at)pgmasters(dot)net>
To: Amit Langote <amitlangote09(at)gmail(dot)com>, Kyotaro Horiguchi <horikyota(dot)ntt(at)gmail(dot)com>
Cc: Alvaro Herrera <alvherre(at)alvh(dot)no-ip(dot)org>, PostgreSQL Hackers <pgsql-hackers(at)lists(dot)postgresql(dot)org>, Tatsuro Yamada <tatsuro(dot)yamada(dot)tf(at)nttcom(dot)co(dot)jp>, keisuke kuroda <keisuke(dot)kuroda(dot)3862(at)gmail(dot)com>, tatsuhito(dot)kasahara(dot)rd(at)hco(dot)ntt(dot)co(dot)jp
Subject: Re: Huge memory consumption on partitioned table with FKs
Date: 2021-03-03 13:21:37
Message-ID: b38b574b-b666-0d60-1af4-0f3bd680fe3b@pgmasters.net
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

On 12/7/20 10:59 PM, Amit Langote wrote:
> On Tue, Dec 8, 2020 at 12:04 PM Kyotaro Horiguchi
> <horikyota(dot)ntt(at)gmail(dot)com> wrote:
>> At Tue, 8 Dec 2020 01:16:00 +0900, Amit Langote <amitlangote09(at)gmail(dot)com> wrote in
>>> On Mon, Dec 7, 2020 at 23:48 Alvaro Herrera <alvherre(at)alvh(dot)no-ip(dot)org> wrote:
>>>>
>>>> I think this bit about splitting the struct is a distraction. Let's get
>>>> a patch that solves the bug first, and then we can discuss what further
>>>> refinements we want to do. I think we should get your patch in
>>>> CA+HiwqEOrfN9b=f3sDmySPGc4gO-L_VMFHXLLxVmmdP34e64+w(at)mail(dot)gmail(dot)com
>>>> committed (which I have not read yet.) Do you agree with this plan?
>>>
>>>
>>> Yeah, I agree.
>>
>> Or https://www.postgresql.org/message-id/CA+HiwqGrr2YOO6voBM6m_OAc9w-WMxe1gOuQ-UyDPin6zJtyZw@mail.gmail.com ?
>>
>> +1 from me to either one.
>
> Oh, I hadn't actually checked the actual message that Alvaro
> mentioned, but yeah I too am fine with either that one or the latest
> one.

Any progress on the decision of how to handle this bug? Not sure if that
was handled elsewhere but it appears to be key to making progress on
this patch.

Regards,
--
-David
david(at)pgmasters(dot)net

In response to

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message David Steele 2021-03-03 13:39:54 Re: 回复:Re: Cache relation sizes?
Previous Message Julien Rouhaud 2021-03-03 13:13:09 Re: archive_command / pg_stat_archiver & documentation