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 1ibG5p-00005q-Qf for pgsql-hackers@arkaria.postgresql.org; Sun, 01 Dec 2019 03:40:17 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.89) (envelope-from ) id 1ibG5o-0008AS-By for pgsql-hackers@arkaria.postgresql.org; Sun, 01 Dec 2019 03:40:16 +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 1ibG5o-00089Z-0A for pgsql-hackers@lists.postgresql.org; Sun, 01 Dec 2019 03:40:16 +0000 Received: from wnew1-smtp.messagingengine.com ([64.147.123.26]) by makus.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1ibG5h-0003Mm-El for pgsql-hackers@lists.postgresql.org; Sun, 01 Dec 2019 03:40:14 +0000 Received: from compute4.internal (compute4.nyi.internal [10.202.2.44]) by mailnew.west.internal (Postfix) with ESMTP id 09B0D52F; Sat, 30 Nov 2019 22:40:06 -0500 (EST) Received: from mailfrontend2 ([10.202.2.163]) by compute4.internal (MEProxy); Sat, 30 Nov 2019 22:40:07 -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=WlQAMNAE6m3JlWWOXcLt09+boLu aG5hwBrUcvCrR7zQ=; b=c5Md88PX+kFfyCPRP9JtJYn0u8D95+6uCus5LaM5zKs GXJPwiNxe4YhwWgWIpI7y+/fc3UNhptcHOxLA1mYw13jMNfsBGiHbsfVMU4ILBYT hPLds7pmk/srAewEduebraw57D1UoH9e6r5UTp3TTUQxspTXQgEX2H/PINobwxrH ZT80nKrRl/A1hHe3ndUQbf9mGBWuynk63l2F928LRvMS6BrWDx9skaT/CNzVKisD t+WPCOeIA53h+OFDnL8elwc1AauSA8yojV9SvmJWQEH3MRFXPV8XGU1Hf85kzG/Z wvQMbwuUtgMNJ+T4st09mDDRULb/vjG3UrZdJMKNf7A== 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=WlQAMN AE6m3JlWWOXcLt09+boLuaG5hwBrUcvCrR7zQ=; b=VtUUWG9ils3ke9Z6m1UeOt NlKd5O7RmvSSN5+8rZfyWDci6OtQ426zYYh7+FOi4SAlowcdru7mUP0H6JMWr/DL 91g97iwchhHgYCIMsxpFh8gvjQ+j5zTb3a9XqGn7E48BAM9Nehcivz6iZ/J22DGA AVsBF++VXYniaWAuKUWzx5zGj9o/YQrg5LEGrsi9PaBrGAA/QvZ+AfBoOuACh6oc Kc5rUJ7pE8sG6bCH/q3k+4ozwZo+rKVAcDkjzUbLAYBSv48gW3Pr9eGY7SQZCKp3 hstE3Ad3q6r+LYFePHaKeKBwfhX8xcwbU8jZJcwCy0WL1s76p2BYlMc5oksKbquQ == X-ME-Sender: X-ME-Proxy-Cause: gggruggvucftvghtrhhoucdtuddrgedufedrudejvddgieduucetufdoteggodetrfdotf fvucfrrhhofhhilhgvmecuhfgrshhtofgrihhlpdfqfgfvpdfurfetoffkrfgpnffqhgen uceurghilhhouhhtmecufedttdenucgfrhhlucfvnfffucdljedtmdenucfjughrpeffhf fvuffkfhggtggujgesghdtreertddtjeenucfhrhhomhepofhitghhrggvlhcurfgrqhhu ihgvrhcuoehmihgthhgrvghlsehprghquhhivghrrdighiiiqeenucfkphepudduuddrud dtvddrudektddrudekheenucfrrghrrghmpehmrghilhhfrhhomhepmhhitghhrggvlhes phgrqhhuihgvrhdrgiihiienucevlhhushhtvghrufhiiigvpedt 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 E09F330600AD; Sat, 30 Nov 2019 22:40:02 -0500 (EST) Date: Sun, 1 Dec 2019 12:40:00 +0900 From: Michael Paquier To: Kyotaro Horiguchi Cc: robertmhaas@gmail.com, ideriha.takeshi@jp.fujitsu.com, tomas.vondra@2ndquadrant.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: <20191201034000.GI2355@paquier.xyz> References: <20190701.160259.247597303.horikyota.ntt@gmail.com> <20191119.194810.255216975235933051.horikyota.ntt@gmail.com> MIME-Version: 1.0 Content-Type: multipart/signed; micalg=pgp-sha512; protocol="application/pgp-signature"; boundary="1RkCiX/UEfbG28Bk" Content-Disposition: inline In-Reply-To: <20191119.194810.255216975235933051.horikyota.ntt@gmail.com> List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Precedence: bulk --1RkCiX/UEfbG28Bk Content-Type: text/plain; charset=utf-8 Content-Disposition: inline Content-Transfer-Encoding: quoted-printable On Tue, Nov 19, 2019 at 07:48:10PM +0900, Kyotaro Horiguchi wrote: > I'd like to throw in food for discussion on how much SearchSysCacheN > suffers degradation from some choices on how we can insert a code into > the SearchSysCacheN code path. Please note that the patch has a warning, causing cfbot-san to complain: catcache.c:786:1: error: no previous prototype for =E2=80=98CatalogCacheFlushCatalog2=E2=80=99 [-Werror=3Dmissing-prototypes] CatalogCacheFlushCatalog2(Oid catId) ^ cc1: all warnings being treated as errors So this should at least be fixed. For now I have moved it to next CF, waiting on author. -- Michael --1RkCiX/UEfbG28Bk Content-Type: application/pgp-signature; name="signature.asc" -----BEGIN PGP SIGNATURE----- iQIzBAABCgAdFiEEG72nH6vTowiyblFKnvQgOdbyQH0FAl3jNhAACgkQnvQgOdby QH2E0hAAkiypebbLsM8cmkUDmj3U1GqyJWTrLiuEO35DBY0EjmwZtOMHOa/krewA iY1akpAIzOt+UdMCwYlgEPFeOMqlaS9DQFX+7Dvu06pA02AbHdpucRabAVDgDDGC 1ngA8iC8rLeOWXS1UWi/dG9e9zBIodcK/NrlQLCYYG8/VvDmiPnfN2PcyBzFaQLD laLw7F8sQrJ1CO7HCGZfEcFqVwR8LI5UpHhXPyNiczk5javgCN5couI2WnE9q9rq +3tRe+940UMEmMBBEEZgEYXrsgh56cxES4Dr4SzgVZIR+DPGOthS8m0SGwbk1TaO eLbtFHKbKD2HsW318U/nFUZxhp3YpJlWJZ5fWXk9hNtXS1Sp8esMrnZehxMw2Ugw ZeTMM4FmGPRujaUJ4I2oiDQQnXlR4+9CPVVpjAjjAoaB9qkNiP/6r3gxDQA5ZEUY InzmxwUKq76++BlUofy2wZeaj/dXIDTiQhID6og7vonvzBNioHxfGu7esgOQAYk6 KEK2DJ32J/ngU40/5Dh/7RxHuleoxXfwJHw2DRynwch/8L7JR67/GF52mJeEVYSK 85J29IV8VbRVxbdjgjwenRdLW+lTAhPXV2FBX08UY9R+u6gFFynoGMgtddtBnK2s PdIpGei4LP9E/vl7nS4yuux31Q3YvbpBjEjZXu8GdOb6B5EFHzA= =u3mX -----END PGP SIGNATURE----- --1RkCiX/UEfbG28Bk--