Received: from malur.postgresql.org ([217.196.149.56])
	by arkaria.postgresql.org with esmtps
 (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA384:256)
	(Exim 4.89)
	(envelope-from <pgsql-hackers-owner+archive@lists.postgresql.org>)
	id 1eyjPG-0006iA-JM
	for pgsql-hackers@arkaria.postgresql.org; Wed, 21 Mar 2018 19:28:18 +0000
Received: from localhost ([127.0.0.1] helo=malur.postgresql.org)
	by malur.postgresql.org with esmtp (Exim 4.89)
	(envelope-from <pgsql-hackers-owner+archive@lists.postgresql.org>)
	id 1eyjPF-0000nl-JD
	for pgsql-hackers@arkaria.postgresql.org; Wed, 21 Mar 2018 19:28:17 +0000
Received: from makus.postgresql.org ([2001:4800:1501:1::229])
	by malur.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA384:256)
	(Exim 4.89)
	(envelope-from <david@pgmasters.net>)
	id 1eyjPF-0000mW-9G
	for pgsql-hackers@lists.postgresql.org; Wed, 21 Mar 2018 19:28:17 +0000
Received: from mail.thelabyrinth.net ([45.56.70.56])
	by makus.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA384:256)
	(Exim 4.89)
	(envelope-from <david@pgmasters.net>)
	id 1eyjP8-00055K-8I
	for pgsql-hackers@postgresql.org; Wed, 21 Mar 2018 19:28:16 +0000
Received: from Davids-iMac.local (unknown [173.169.74.224])
	(using TLSv1.2 with cipher ECDHE-RSA-AES128-GCM-SHA256 (128/128 bits))
	(No client certificate requested)
	(Authenticated sender: dsteele)
	by mail.thelabyrinth.net (Postfix) with ESMTPSA id A9BEF54661;
	Wed, 21 Mar 2018 19:28:08 +0000 (UTC)
Subject: Re: Re: Protect syscache from bloating with negative cache entries
To: Kyotaro HORIGUCHI <horiguchi.kyotaro@lab.ntt.co.jp>, tgl@sss.pgh.pa.us
Cc: tsunakawa.takay@jp.fujitsu.com, alvherre@alvh.no-ip.org,
 andres@anarazel.de, robertmhaas@gmail.com, michael.paquier@gmail.com,
 Jim.Nasby@bluetreble.com, craig@2ndquadrant.com, pgsql-hackers@postgresql.org
References: <352.1520482349@sss.pgh.pa.us>
 <20180309.174001.202113825.horiguchi.kyotaro@lab.ntt.co.jp>
 <20180312.173408.162882093.horiguchi.kyotaro@lab.ntt.co.jp>
 <20180315.141246.130742928.horiguchi.kyotaro@lab.ntt.co.jp>
From: David Steele <david@pgmasters.net>
Message-ID: <43095b16-14fc-e4d8-3310-2b86eaaab662@pgmasters.net>
Date: Wed, 21 Mar 2018 15:28:07 -0400
User-Agent: Mozilla/5.0 (Macintosh; Intel Mac OS X 10.13; rv:52.0)
 Gecko/20100101 Thunderbird/52.6.0
MIME-Version: 1.0
In-Reply-To: <20180315.141246.130742928.horiguchi.kyotaro@lab.ntt.co.jp>
Content-Type: text/plain; charset=windows-1252
Content-Language: en-US
Content-Transfer-Encoding: 7bit
List-Id: <pgsql-hackers.lists.postgresql.org>
List-Help: <https://lists.postgresql.org/manage/>
List-Subscribe: <https://lists.postgresql.org/manage/>
List-Post: <mailto:pgsql-hackers@lists.postgresql.org>
List-Owner: <mailto:pgsql-hackers-owner@lists.postgresql.org>
List-Archive: <https://www.postgresql.org/list/pgsql-hackers>
Precedence: bulk

On 3/15/18 1:12 AM, Kyotaro HORIGUCHI wrote:
> At Mon, 12 Mar 2018 17:34:08 +0900 (Tokyo Standard Time), Kyotaro HORIGUCHI <horiguchi.kyotaro@lab.ntt.co.jp> wrote in > 
> 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.

It looks like this should be marked Needs Review so I have done so.  If
that's not right please change it back or let me know and I will.

Regards,
-- 
-David
david@pgmasters.net