Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1kNqLh-0003hG-Vy for pgsql-hackers@arkaria.postgresql.org; Thu, 01 Oct 2020 04:37:45 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.92) (envelope-from ) id 1kNqLg-0006ib-Mp for pgsql-hackers@arkaria.postgresql.org; Thu, 01 Oct 2020 04:37:44 +0000 Received: from magus.postgresql.org ([2a02:c0:301:0:ffff::29]) by malur.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1kNqLg-0006iT-GC for pgsql-hackers@lists.postgresql.org; Thu, 01 Oct 2020 04:37:44 +0000 Received: from wnew1-smtp.messagingengine.com ([64.147.123.26]) by magus.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1kNqLc-0005DX-Fk for pgsql-hackers@lists.postgresql.org; Thu, 01 Oct 2020 04:37:44 +0000 Received: from compute1.internal (compute1.nyi.internal [10.202.2.41]) by mailnew.west.internal (Postfix) with ESMTP id E15A69DE; Thu, 1 Oct 2020 00:37:36 -0400 (EDT) Received: from mailfrontend2 ([10.202.2.163]) by compute1.internal (MEProxy); Thu, 01 Oct 2020 00:37:37 -0400 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=fm2; bh=VUaJybnJP9rpOy3TenF6AZLBWJD pradqFY0mIl/vCTA=; b=ZWSxmoSeoFsCJXUqCJaAREvw3EraavENc8lI+gprfiF jjF7StgRMasG3CuXovR4z5/rNRP7CjT6CxWxmpwoUT6q93KgZrhepHgQzG4hRzJ8 b8RroKJgGOKhKkFfibUFSHkN8LZxN/P2aXjVZzDGrBdfMGY0DST/LQ2Htz6eiwbF ioQajRLnry9vcwf13/1MkC5cTodV5d2q1g9X8zMNmv5cbZ5O3G5SWXRDAsw/gjjG fDZGA98OYd1LnwjgakPjMUa0aL7EMXp+j1WpglR7LBpu6GtAn93H2+l1TMiXnVNY 6ciYaJmhgccPV/r299IaZwYj0tDxgh9ZlFg0mKbg8KQ== 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=fm3; bh=VUaJyb nJP9rpOy3TenF6AZLBWJDpradqFY0mIl/vCTA=; b=r/6bXBq8POJ9oFThBLjB7x YO6ZemJWve9YoG3rPyASwAHFRcVmfpozLkYKcZMKX36NJwKIDOLHoXqkfGfRcluS TSMTe9XlVYS9Uj77g2dRo1Neb65MDrtE/BpENlSRhWKAOi7KR1lNVGU7dZO77pzq UPyKeDlN9GRkWDldCQ077KV8pY12sH6Rs4duaLWHoJgXSpQXQknnrATABuuM3D1N G8KXfOtYgOcs9oGRUXWV1IUfxoSf8ecrWjiUtHvfPJhoEWCvaT/dRJHQinvWx+g1 BNr0+eKjBPbKt6f3Q8nUbhjhwVzowAnfGGeEoBTH5SNpus0ledpji1bYCsP8+8hA == X-ME-Sender: X-ME-Proxy-Cause: gggruggvucftvghtrhhoucdtuddrgedujedrfeefgdekkecutefuodetggdotefrodftvf curfhrohhfihhlvgemucfhrghsthforghilhdpqfgfvfdpuffrtefokffrpgfnqfghnecu uegrihhlohhuthemuceftddtnecufghrlhcuvffnffculdejtddmnecujfgurhepfffhvf fukfhfgggtuggjsehgtderredttddvnecuhfhrohhmpefoihgthhgrvghlucfrrghquhhi vghruceomhhitghhrggvlhesphgrqhhuihgvrhdrgiihiieqnecuggftrfgrthhtvghrnh epvdegudeuhfdtueeltedtveejheehieevueeigeelteegleejleeiueeiheegvefhnecu kfhppeduuddurddutddvrddukedtrddukeehnecuvehluhhsthgvrhfuihiivgeptdenuc frrghrrghmpehmrghilhhfrhhomhepmhhitghhrggvlhesphgrqhhuihgvrhdrgiihii X-ME-Proxy: Received: from paquier.xyz (ee0822lan1.rev.em-net.ne.jp [111.102.180.185]) by mail.messagingengine.com (Postfix) with ESMTPA id 880DF3064682; Thu, 1 Oct 2020 00:37:32 -0400 (EDT) Date: Thu, 1 Oct 2020 13:37:29 +0900 From: Michael Paquier To: Kyotaro Horiguchi Cc: tomas.vondra@2ndquadrant.com, robertmhaas@gmail.com, ideriha.takeshi@jp.fujitsu.com, tgl@sss.pgh.pa.us, andres@anarazel.de, tsunakawa.takay@jp.fujitsu.com, alvherre@2ndquadrant.com, bruce@momjian.us, pgsql-hackers@lists.postgresql.org, michael.paquier@gmail.com, david@pgmasters.net, craig@2ndquadrant.com Subject: Re: Protect syscache from bloating with negative cache entries Message-ID: <20201001043729.GI8130@paquier.xyz> References: <20191119.194810.255216975235933051.horikyota.ntt@gmail.com> <20200114.124932.686592702655880857.horikyota.ntt@gmail.com> <20200121162947.e3pnaro4jtzwqu75@development> <20200122.143819.1183954869198108813.horikyota.ntt@gmail.com> MIME-Version: 1.0 Content-Type: multipart/signed; micalg=pgp-sha512; protocol="application/pgp-signature"; boundary="fckbADODYWZD5TdN" Content-Disposition: inline In-Reply-To: <20200122.143819.1183954869198108813.horikyota.ntt@gmail.com> List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Precedence: bulk --fckbADODYWZD5TdN Content-Type: text/plain; charset=us-ascii Content-Disposition: inline Content-Transfer-Encoding: quoted-printable On Wed, Jan 22, 2020 at 02:38:19PM +0900, Kyotaro Horiguchi wrote: > I changed my mind to attach the benchmark patch as .txt file, > expecting the checkers not picking up it as a part of the patchset. >=20 > I have in the precise performance measurement mode for a long time, > but I think it's settled. I'd like to return to normal mode and > explain this patch. Looking at the CF bot, this patch set does not compile properly. Could you look at that? -- Michael --fckbADODYWZD5TdN Content-Type: application/pgp-signature; name="signature.asc" -----BEGIN PGP SIGNATURE----- iQIzBAABCgAdFiEEG72nH6vTowiyblFKnvQgOdbyQH0FAl91XQkACgkQnvQgOdby QH3n1A/9ERNe5i5VCRJNrQaBOMffhM9Pjpt060qZHnY1gVUr3SPR6TmnwItBebEB eTDgbL+MfCEmnt9dpD+DnABmD2s+eRpOBQRwV/hyKZ1Jv+AryQXb3fjGNaC74U7u ZLk//9H+6Gd2pTwHm7bKWIMH0MrmA/rj/jwgYpps/nbX7zZc/ufqF1VjHLNODdLG VTcIlYxXm08BDsFxTcRwAeEnL00r10hav7FQ84I3bFaqGET5Cyyzx9za1EROBhvm hjDVgBQf0sM8JXrWM+ioUUs4zSOt+++7BKB3V3zOOJB/yvoFR+vF82qdpXcKPQeA MQKx0HHp/xqVYGh4MOPkNLAoSXlD8fcwOucWCrbG+nomyCXex4oPlD5gewTn6CnN ybd91n8qSgd4xqMdx0g4q/LclLnWyMTOB7eI0Ml7p+zz3zwQDEB5s8ilIfJTmyoc H6AWoFuMa4ZeAb2F1jhaWA3VzctKS49to5zlDnNKhzekeTsLnb1XfZGd12dyiO5i ydIwNZe3GigBZxevpHEJl+VyeGAdM0ZgphlubXEbn/e7WGApfNB7weN7F1b9PM+5 s0K6T4tWpxjYQzvZVKHdmTa7pcA2zI9F87iIUI4W5j+v0E7JiaC8oU0hP1S3zEGj mUPzhauBN5kUF0AzyZxKHEUKKtxR3DkzU3goIa2BtHganrG/IBk= =O+7e -----END PGP SIGNATURE----- --fckbADODYWZD5TdN--