Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA1:256) (Exim 4.89) (envelope-from ) id 1gqVUg-000227-7y for pgsql-hackers@arkaria.postgresql.org; Mon, 04 Feb 2019 04:04:27 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.89) (envelope-from ) id 1gqVUe-0007ZP-Q9 for pgsql-hackers@arkaria.postgresql.org; Mon, 04 Feb 2019 04:04:24 +0000 Received: from makus.postgresql.org ([2001:4800:3e1:1::229]) by malur.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA1:256) (Exim 4.89) (envelope-from ) id 1gqVUd-0007Nq-10 for pgsql-hackers@lists.postgresql.org; Mon, 04 Feb 2019 04:04:24 +0000 Received: from out1-smtp.messagingengine.com ([66.111.4.25]) by makus.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA1:256) (Exim 4.89) (envelope-from ) id 1gqVUV-0002k6-PS for pgsql-hackers@lists.postgresql.org; Mon, 04 Feb 2019 04:04:21 +0000 Received: from compute4.internal (compute4.nyi.internal [10.202.2.44]) by mailout.nyi.internal (Postfix) with ESMTP id 870A521D63; Sun, 3 Feb 2019 23:04:14 -0500 (EST) Received: from mailfrontend1 ([10.202.2.162]) by compute4.internal (MEProxy); Sun, 03 Feb 2019 23:04:14 -0500 DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=paquier.xyz; h= date:from:to:cc:subject:message-id:references:mime-version :content-type:in-reply-to; s=fm3; bh=iGQ4CUQe83ga+HMGE3/q49k6riY WR6JdkAsJi1cFtOk=; b=jOLi8D6BHQnmqqIIALL3jSXnJV1m/qVKlC9ZDliiIDg VDf12Sdjw9SLur3H6JDO9MVh5LUITyPDQpVW08+X14uSdZe6BjfCq6vPvcgIOwY8 GUdRCiz5k3gOkQBL+Yi7x9/7rB9Y4sITmggIOmPD6rgj8nR1nnS06YPfzSlOCqRH 9PDAqvIEa5MPqYYrGoU1eYly6SfBF2y96DoLbpG8oupLgXFoFvVBAxl/3ZWWgSMd cHxc/x+1x414YFjLg0Mkqfg2rCymz7I1nliXmkvpYtQn5dWE2QKUEgrYQL5yLgDe zJgHOGOttilR6IwJ6GogPgBQQ16GxYF05rmJF4t9Dgw== DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d= messagingengine.com; h=cc:content-type:date:from:in-reply-to :message-id:mime-version:references:subject:to:x-me-proxy :x-me-proxy:x-me-sender:x-me-sender:x-sasl-enc; s=fm1; bh=iGQ4CU Qe83ga+HMGE3/q49k6riYWR6JdkAsJi1cFtOk=; b=OFrmbUXaTGXdyrDdWz/DTu NLvHO1TF9vpncUjLygJdVp54nX9J+2nnaQg2zDobxj91ZiSgv0iLknl/lG/Pnil2 48QIOy6/8ufxXgOnSLBusyWk0dDp0fs2WAhZ43IijcFVXNRzzM5hgdNxSGQ+e88P UEiW2iEABDhafVv4fZHhEzJP/zCEBzXgo6egXWd5Nt4nTWplP8Rb6YWD180lJWDC tUpghuHju2fcgBQGnQRoLXrKulGRArIk2woNnh7drQwJGdXgt4lo94h287c1bgMH ThniLi8oaigdZ1HxZVAso6tmJWX0OaQact3UraIUk8CLsHByMso1VLQo3yctEhiQ == X-ME-Sender: X-ME-Proxy-Cause: gggruggvucftvghtrhhoucdtuddrgedtledrkeefgdeihecutefuodetggdotefrodftvf curfhrohhfihhlvgemucfhrghsthforghilhdpqfhuthenuceurghilhhouhhtmecufedt tdenucesvcftvggtihhpihgvnhhtshculddquddttddmnegfrhhlucfvnfffucdljedtmd enucfjughrpeffhffvuffkfhggtggujgesghdtreertddtvdenucfhrhhomhepofhitghh rggvlhcurfgrqhhuihgvrhcuoehmihgthhgrvghlsehprghquhhivghrrdighiiiqeenuc fkphepiedurddvudehrddufeejrdduiedvnecurfgrrhgrmhepmhgrihhlfhhrohhmpehm ihgthhgrvghlsehprghquhhivghrrdighiiinecuvehluhhsthgvrhfuihiivgeptd X-ME-Proxy: Received: from paquier.xyz (c137162.net61215.cablenet.ne.jp [61.215.137.162]) by mail.messagingengine.com (Postfix) with ESMTPA id 3622BE40FF; Sun, 3 Feb 2019 23:04:08 -0500 (EST) Date: Mon, 4 Feb 2019 13:04:05 +0900 From: Michael Paquier To: Kyotaro HORIGUCHI Cc: tsunakawa.takay@jp.fujitsu.com, robertmhaas@gmail.com, tgl@sss.pgh.pa.us, bruce@momjian.us, GavinFlower@archidevsys.co.nz, ideriha.takeshi@jp.fujitsu.com, pgsql-hackers@lists.postgresql.org, alvherre@alvh.no-ip.org, andres@anarazel.de, michael.paquier@gmail.com, david@pgmasters.net, craig@2ndquadrant.com Subject: Re: Protect syscache from bloating with negative cache entries Message-ID: <20190204040134.GG1881@paquier.xyz> References: <16829.1548341992@sss.pgh.pa.us> <0A3221C70F24FB45833433255569204D1FB70E6B@G01JPEXMBYT05> <20190128.133143.115303042.horiguchi.kyotaro@lab.ntt.co.jp> MIME-Version: 1.0 Content-Type: multipart/signed; micalg=pgp-sha512; protocol="application/pgp-signature"; boundary="C7zPtVaVf+AK4Oqc" Content-Disposition: inline In-Reply-To: <20190128.133143.115303042.horiguchi.kyotaro@lab.ntt.co.jp> List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Precedence: bulk --C7zPtVaVf+AK4Oqc Content-Type: text/plain; charset=us-ascii Content-Disposition: inline On Mon, Jan 28, 2019 at 01:31:43PM +0900, Kyotaro HORIGUCHI wrote: > I'll consider the last choice and will come up with a patch. Update is recent, so I have just moved the patch to next CF. -- Michael --C7zPtVaVf+AK4Oqc Content-Type: application/pgp-signature; name="signature.asc" -----BEGIN PGP SIGNATURE----- iQIzBAABCgAdFiEEG72nH6vTowiyblFKnvQgOdbyQH0FAlxXubUACgkQnvQgOdby QH1K+w/+OXqh9A3dAuvIomQaxrtmes6fFLx2GncmIet6LS5KeD+CshhwUJFfnHqX FJ+Z/ONVUaPuyu3ccGjkXC5m/PmIzKCEZPCPRLoAVTEcsPU29YaeUGJGbopqyYTv QI2mEUrB+A9HTWX7Cb8+EWIoNpeLAMQVWnV6bADOD+oB22fqQ0PPgM3HSF/2+q9w 5j3Z2/umLbtHxE37xSbtBqFiSy+FDhPwIMHjmlVi02ejK9L1SlLp3I2IvqrGOcco ZUqBlxzY8EbPomDLWUXu7OPa5NC3aW2IgeRA+siEijQ1NBq3TFxLokY6sV0NjQ68 w7dI5ux/iGa5zjddv2fCg3rOCOh9ZSP7iqz0w+y4OckqFJO7JPUPzP+n14LOnRuM gIRfII9uWhb0EdGqIVKf6ipQA3axA5lvAyEG597F2mOgGikzXI3J985YnQJSX/8u Vw9gQSNR2RG0OmNW00fVvZD3f6kAWXKwO1EPWGJmXb1hmfL42EsGCHEx2+bzcGne GhjeGwoDGe5PRZvBwH0lhtI7MIK19Z1W57JNGGU6Cqg5rzJQSzIYOXcCkSaxlpIT Kd4G39l/JDDsxFXK4Fmt9lu1ClT9BJxfGs90uSLDQ0bn2wLHf7LivztQ/ewladVj HxQy6cGkI5UerwslZiGFI1nwNxQ75ArwW9HIXJVdrzA5LIFJ13s= =CQnM -----END PGP SIGNATURE----- --C7zPtVaVf+AK4Oqc--