Received: from malur.postgresql.org ([2a02:16a8:dc51::56]) by arkaria.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA384:256) (Exim 4.89) (envelope-from ) id 1fa82K-0000wD-2O for pgsql-hackers@arkaria.postgresql.org; Mon, 02 Jul 2018 23:15:12 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.89) (envelope-from ) id 1fa82H-0000uv-Ku for pgsql-hackers@arkaria.postgresql.org; Mon, 02 Jul 2018 23:15:09 +0000 Received: from magus.postgresql.org ([2a02:c0:301:0:ffff::29]) by malur.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA384:256) (Exim 4.89) (envelope-from ) id 1fa82H-0000ui-Ae for pgsql-hackers@lists.postgresql.org; Mon, 02 Jul 2018 23:15:09 +0000 Received: from mail-yb0-x243.google.com ([2607:f8b0:4002:c09::243]) by magus.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA1:256) (Exim 4.89) (envelope-from ) id 1fa82A-0001AU-Ts for pgsql-hackers@lists.postgresql.org; Mon, 02 Jul 2018 23:15:06 +0000 Received: by mail-yb0-x243.google.com with SMTP id s14-v6so22254ybp.13 for ; Mon, 02 Jul 2018 16:15:02 -0700 (PDT) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=2ndquadrant-com.20150623.gappssmtp.com; s=20150623; h=from:subject:to:cc:references:message-id:date:user-agent :mime-version:in-reply-to:content-transfer-encoding:content-language; bh=2ODAptCtb1KkYwV8YUOvjsTxIQ+9m/CO7gBq16j/bhg=; b=17QiGr7OcZ7kckrb9B3P6Z9zv1PaPpdUjvHZYoT7dCqZPEXCBWqOezjBT95eQuHxXK wjps6+RBIC28nVnGTtKZ/JRnw6NbBS1drMJk4cQJhYRa+pgTOWxCuuwQB+kBv32YS4un KPRlX7eUxVwaO/e0+eIweJcNHf4RFTuSh06i4pStf8dbvWkybXfkZ3av4jfnxv19zjdW qPClqR7geYS8guNIlT6wfg1PJt5QIZ0njjKgRwgFPORDr6UFtGebUIakTjTUL/bLqYuL sSFwETdiR4MXpZ/dQo+ZnIFA/2p7cpsFfvydX/U6awoHO9x6vVIZ+R0ScslYUMq+qwYm JJIA== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20161025; h=x-gm-message-state:from:subject:to:cc:references:message-id:date :user-agent:mime-version:in-reply-to:content-transfer-encoding :content-language; bh=2ODAptCtb1KkYwV8YUOvjsTxIQ+9m/CO7gBq16j/bhg=; b=VUa5fUI6SQDRz1YjL+9MnAUylARidnUughm9Z7xPkKzoQkeH3WodZ7THJbvVeCfXXX gDsSeVlwS0iJEhAXiWgXDLdmqMwxq6sJ2J0fR69foTQYumi9haj2V1QMuj+BlOVIBApF li+NQow8lp42ehUdnzaV6upgiBp0C3+D4tZbyxQ02piOSembTY1t70yhwWpnZ9ve9p/k i6915g/OxMC4t2HonRAfwvWdqlqfUXAvEmMaCLaGNmbAuo5nnLxX1n/wlsVFP704fV5G MPqGf0GzkK3WY5r7/simBE12KZ8PLuIrKZBeiBh0gfVmA3e2GyYeQiyhKmidncM2DM4V safQ== X-Gm-Message-State: APt69E0IMKHRljsQ9MO/Z9SNvLsA8Phcvw4ofYVGKO7GPvg7c05bM1fz eTG0iCM5z4gF54VULzY9I8j/ X-Google-Smtp-Source: ADUXVKJe5goBd16sluSwY6nj+RIV2MCyqUq3ueFllU+wgKpfimHUEp2H5+ZP7mUX/ms70NsMROB68g== X-Received: by 2002:a25:6a56:: with SMTP id f83-v6mr13679754ybc.153.1530573300352; Mon, 02 Jul 2018 16:15:00 -0700 (PDT) Received: from [192.168.10.146] ([98.122.175.38]) by smtp.gmail.com with ESMTPSA id x129-v6sm521193ywe.61.2018.07.02.16.14.59 (version=TLS1_2 cipher=ECDHE-RSA-AES128-GCM-SHA256 bits=128/128); Mon, 02 Jul 2018 16:14:59 -0700 (PDT) From: Andrew Dunstan X-Google-Original-From: Andrew Dunstan Subject: Re: Protect syscache from bloating with negative cache entries To: Kyotaro HORIGUCHI , pgsql-hackers@lists.postgresql.org Cc: 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 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> Message-ID: Date: Mon, 2 Jul 2018 19:14:58 -0400 User-Agent: Mozilla/5.0 (X11; Linux x86_64; rv:52.0) Gecko/20100101 Thunderbird/52.4.0 MIME-Version: 1.0 In-Reply-To: <20180626.180003.127457941.horiguchi.kyotaro@lab.ntt.co.jp> Content-Type: text/plain; charset=windows-1252; format=flowed Content-Transfer-Encoding: 7bit Content-Language: en-MW List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Precedence: bulk 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