From: Andrew Dunstan <andrew.dunstan@2ndquadrant.com>
To: Kyotaro HORIGUCHI <horiguchi.kyotaro@lab.ntt.co.jp>
To: pgsql-hackers@lists.postgresql.org
Cc: tsunakawa.takay@jp.fujitsu.com
Cc: alvherre@alvh.no-ip.org
Cc: andres@anarazel.de
Cc: robertmhaas@gmail.com
Cc: michael.paquier@gmail.com
Cc: david@pgmasters.net
Cc: Jim.Nasby@bluetreble.com
Cc: craig@2ndquadrant.com
Cc: tgl@sss.pgh.pa.us
Subject: Re: Protect syscache from bloating with negative cache entries
Date: Mon, 2 Jul 2018 19:14:58 -0400
Message-ID: <d01c4037-0740-c739-e340-5aa1119c0afd@2ndQuadrant.com> (raw)
In-Reply-To: <20180626.180003.127457941.horiguchi.kyotaro@lab.ntt.co.jp>
References: <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>
<20180626.180003.127457941.horiguchi.kyotaro@lab.ntt.co.jp>
On 06/26/2018 05:00 AM, Kyotaro HORIGUCHI wrote:
>
>> 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.
>
Andres suggested back in March (and again privately to me) that given
how much this has changed from the original this CF item should be
marked Returned With Feedback and the current patchset submitted as a
new item.
Does anyone object to that course of action?
cheers
andrew
--
Andrew Dunstan https://www.2ndQuadrant.com
PostgreSQL Development, 24x7 Support, Remote DBA, Training & Services
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-hackers@postgresql.org
Cc: andrew.dunstan@2ndquadrant.com, horiguchi.kyotaro@lab.ntt.co.jp, pgsql-hackers@lists.postgresql.org, tsunakawa.takay@jp.fujitsu.com, alvherre@alvh.no-ip.org, andres@anarazel.de, robertmhaas@gmail.com, michael.paquier@gmail.com, david@pgmasters.net, Jim.Nasby@bluetreble.com, craig@2ndquadrant.com, tgl@sss.pgh.pa.us
Subject: Re: Protect syscache from bloating with negative cache entries
In-Reply-To: <d01c4037-0740-c739-e340-5aa1119c0afd@2ndQuadrant.com>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox