Re: Protect syscache from bloating with negative cache entries

From: Kyotaro HORIGUCHI <horiguchi(dot)kyotaro(at)lab(dot)ntt(dot)co(dot)jp>
To: pgsql-hackers(at)lists(dot)postgresql(dot)org
Cc: tsunakawa(dot)takay(at)jp(dot)fujitsu(dot)com, alvherre(at)alvh(dot)no-ip(dot)org, andres(at)anarazel(dot)de, robertmhaas(at)gmail(dot)com, michael(dot)paquier(at)gmail(dot)com, david(at)pgmasters(dot)net, Jim(dot)Nasby(at)bluetreble(dot)com, craig(at)2ndquadrant(dot)com, tgl(at)sss(dot)pgh(dot)pa(dot)us
Subject: Re: Protect syscache from bloating with negative cache entries
Date: 2018-07-03 00:29:14
Views: Raw Message | Whole Thread | Download mbox | Resend email
Lists: pgsql-hackers

Hello. The previous v4 patchset was just broken.

At Tue, 26 Jun 2018 18:00:03 +0900 (Tokyo Standard Time), Kyotaro HORIGUCHI <horiguchi(dot)kyotaro(at)lab(dot)ntt(dot)co(dot)jp> wrote in <20180626(dot)180003(dot)127457941(dot)horiguchi(dot)kyotaro(at)lab(dot)ntt(dot)co(dot)jp>
> Hello. I rebased this patchset.
> > The attached is the patch set including this plancache stuff.
> >
> > 0001- catcache time-based expiration (The origin of this thread)
> > 0002- introduces dynahash pruning feature
> > 0003- implement relcache pruning using 0002
> > 0004- (perhaps) independent from the three above. PoC of
> > plancache pruning. Details are shown above.
> I found up to v3 in this thread so I named this version 4.

Somehow the 0004 was merged into the 0003 and applying 0004
results in failure. I removed 0004 part from the 0003 and rebased
and repost it.


Kyotaro Horiguchi
NTT Open Source Software Center

Attachment Content-Type Size
v5-0001-Remove-entries-that-haven-t-been-used-for-a-certain-.patch text/x-patch 22.4 KB
v5-0002-introduce-dynhash-pruning.patch text/x-patch 13.5 KB
v5-0003-Apply-purning-to-relcache.patch text/x-patch 11.5 KB
v5-0004-Generic-plan-removal-of-PlanCacheSource.patch text/x-patch 10.5 KB

In response to


Browse pgsql-hackers by date

  From Date Subject
Next Message Michael Paquier 2018-07-03 00:55:58 Re: pgsql: Add wait event for fsync of WAL segments
Previous Message Kyotaro HORIGUCHI 2018-07-03 00:24:32 Re: How to find the base version cf-bot is using?