Re: Huge memory consumption on partitioned table with FKs
David Steele <david@pgmasters.net>
From: David Steele <david@pgmasters.net>
To: Amit Langote <amitlangote09@gmail.com>,
Kyotaro Horiguchi <horikyota.ntt@gmail.com>
Cc: Alvaro Herrera <alvherre@alvh.no-ip.org>,
PostgreSQL Hackers <pgsql-hackers@lists.postgresql.org>,
Tatsuro Yamada <tatsuro.yamada.tf@nttcom.co.jp>,
keisuke kuroda <keisuke.kuroda.3862@gmail.com>,
tatsuhito.kasahara.rd@hco.ntt.co.jp
Date: 2021-03-03T13:21:37Z
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.ntt@gmail.com> wrote: >> At Tue, 8 Dec 2020 01:16:00 +0900, Amit Langote <amitlangote09@gmail.com> wrote in >>> On Mon, Dec 7, 2020 at 23:48 Alvaro Herrera <alvherre@alvh.no-ip.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@mail.gmail.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@pgmasters.net
Commits
-
Avoid creating duplicate cached plans for inherited FK constraints.
- c3ffe3486368 14.0 landed