Re: Huge memory consumption on partitioned table with FKs

From: Tatsuro Yamada <tatsuro(dot)yamada(dot)tf(at)nttcom(dot)co(dot)jp>
To: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
Cc: Amit Langote <amitlangote09(at)gmail(dot)com>, Kyotaro Horiguchi <horikyota(dot)ntt(at)gmail(dot)com>, keisuke kuroda <keisuke(dot)kuroda(dot)3862(at)gmail(dot)com>, Alvaro Herrera <alvherre(at)alvh(dot)no-ip(dot)org>, PostgreSQL Hackers <pgsql-hackers(at)lists(dot)postgresql(dot)org>, 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-12 03:35:08
Message-ID: 1ae93786-bfac-57c1-de6a-691b0c560915@nttcom.co.jp_1
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

On 2021/03/12 2:44, Tom Lane wrote:
> I wrote:
>> Now, maybe it's a coincidence that husky failed on a
>> partitioned-foreign-key test right after this patch went in, but I bet
>> not. Since husky runs CLOBBER_CACHE_ALWAYS, it looks to me like we've
>> overlooked some cache-reset scenario or other.
>
> After reproducing it here, that *is* a coincidence. I shall now go beat
> up on the correct blame-ee, instead.

I did "make installcheck-parallel" on 7bb97211a, just in case. It was successful. :-D

Regards,
Tatsuro Yamada

In response to

Browse pgsql-hackers by date

  From Date Subject
Next Message Fujii Masao 2021-03-12 03:39:22 Re: About to add WAL write/fsync statistics to pg_stat_wal view
Previous Message Justin Pryzby 2021-03-12 03:33:14 Re: [HACKERS] Custom compression methods