Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1t0s97-00Dax7-Cf for pgsql-hackers@arkaria.postgresql.org; Wed, 16 Oct 2024 00:44:13 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.94.2) (envelope-from ) id 1t0s94-00DXw1-NL for pgsql-hackers@arkaria.postgresql.org; Wed, 16 Oct 2024 00:44:11 +0000 Received: from makus.postgresql.org ([2001:4800:3e1:1::229]) by malur.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1t0s94-00DXvr-DD for pgsql-hackers@lists.postgresql.org; Wed, 16 Oct 2024 00:44:10 +0000 Received: from fout-a2-smtp.messagingengine.com ([103.168.172.145]) by makus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1t0s92-0015Ze-2c for pgsql-hackers@lists.postgresql.org; Wed, 16 Oct 2024 00:44:09 +0000 Received: from phl-compute-12.internal (phl-compute-12.phl.internal [10.202.2.52]) by mailfout.phl.internal (Postfix) with ESMTP id 30AF013801D7; Tue, 15 Oct 2024 20:44:07 -0400 (EDT) Received: from phl-mailfrontend-02 ([10.202.2.163]) by phl-compute-12.internal (MEProxy); Tue, 15 Oct 2024 20:44:07 -0400 DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=paquier.xyz; h= cc:cc:content-type:content-type:date:date:from:from:in-reply-to :in-reply-to:message-id:mime-version:references:reply-to:subject :subject:to:to; s=fm2; t=1729039447; x=1729125847; bh=qJGy3VtRmO 9x2tfGgJxv7Mc6dE8smhbVFfSfRFj9Ibw=; b=AY6uDf8LUi5ZnbCdo2kgo9U3oq SL/e05RzDAhQU/BhNjHQm1fSLS6bkR8M0RTx2/mHilsFmoaPSMLwVxsdTxolXwh3 U9E2d/xE8DsYTloHpKf6R9CLNznIZrn07HE8dEhrG+QKiqHChzruODTkV2coxVRT 9odOMvTtBBgbt9uArzxjP//3IzdwdufzUWsESibeVAbKwVXC/hoHfpyhfyvRmTh2 aVIXiBtnLZ9SlRzcQE8aHd1NWk0Fsaf1VdQFOrA3NFgv3MH7ZrdIM4xAXApyEwpW MNzgena4CbRPUFNqVhm2/vBliGS+eZHPBrRtUmI8i82b5/qBhm1MIZzEjqpQ== DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d= messagingengine.com; h=cc:cc:content-type:content-type:date:date :feedback-id:feedback-id:from:from:in-reply-to:in-reply-to :message-id:mime-version:references:reply-to:subject:subject:to :to:x-me-proxy:x-me-proxy:x-me-sender:x-me-sender:x-sasl-enc; s= fm2; t=1729039447; x=1729125847; bh=qJGy3VtRmO9x2tfGgJxv7Mc6dE8s mhbVFfSfRFj9Ibw=; b=jgJ3+x8nnp7eEoHO6gj2vdXjIoW22GElSZBE7r45/VtG ykbv05EI1Y5rUm+tqoHKQX6Y1ATRS40Mf/jnJ9aqEVtZ5tyGIvHdjYx5CCeGaYKQ lvRLXa8b8rg/RxfcfD77ImU+0SfHFELopuGOvnbzwqZF+074qhcpSWDchTSycrF9 psmROo/Qz2Mk7AiigObWWlS+Vzz+2wpkNfs55JiFVhzfCFmEkGiGJbCa1C7xpufX 9YasuRfdN+RSUYylRB8PhjcJxa4KnNVOr80dWPDSjy5mnrTi3NxH5FsTgOLLgueU 2hMttpybEVCOQbIvGPP3DbcCpurOCdWxO+igG1Om8w== X-ME-Sender: X-ME-Received: X-ME-Proxy-Cause: gggruggvucftvghtrhhoucdtuddrgeeftddrvdegkedgfeekucetufdoteggodetrfdotf fvucfrrhhofhhilhgvmecuhfgrshhtofgrihhlpdggtfgfnhhsuhgsshgtrhhisggvpdfu rfetoffkrfgpnffqhgenuceurghilhhouhhtmecufedttdenucesvcftvggtihhpihgvnh htshculddquddttddmnegfrhhlucfvnfffucdlfeehmdenucfjughrpeffhffvvefukfhf gggtuggjsehgtderredttddvnecuhfhrohhmpefoihgthhgrvghlucfrrghquhhivghruc eomhhitghhrggvlhesphgrqhhuihgvrhdrgiihiieqnecuggftrfgrthhtvghrnhepgeff jeevgfevuddvjedtvddtieejheduueelvddufedtgfefjedvkeevkeeivddvnecuffhomh grihhnpehpohhsthhgrhgvshhqlhdrohhrghenucevlhhushhtvghrufhiiigvpedtnecu rfgrrhgrmhepmhgrihhlfhhrohhmpehmihgthhgrvghlsehprghquhhivghrrdighiiipd hnsggprhgtphhtthhopeefpdhmohguvgepshhmthhpohhuthdprhgtphhtthhopegsvghr thhrrghnuggurhhouhhvohhtrdhpghesghhmrghilhdrtghomhdprhgtphhtthhopehkoh husggvrhesghhmrghilhdrtghomhdprhgtphhtthhopehpghhsqhhlqdhhrggtkhgvrhhs sehlihhsthhsrdhpohhsthhgrhgvshhqlhdrohhrgh X-ME-Proxy: Feedback-ID: i0fe9450f:Fastmail Received: by mail.messagingengine.com (Postfix) with ESMTPA; Tue, 15 Oct 2024 20:44:05 -0400 (EDT) Date: Wed, 16 Oct 2024 09:43:48 +0900 From: Michael Paquier To: Bertrand Drouvot Cc: Kouber Saparev , pgsql-hackers@lists.postgresql.org Subject: Re: BF mamba failure Message-ID: References: <172854117093.1162.5418906857588663992.pgcf@coridan.postgresql.org> MIME-Version: 1.0 Content-Type: multipart/signed; micalg=pgp-sha512; protocol="application/pgp-signature"; boundary="lQnHBv2c95Os0Rgb" Content-Disposition: inline In-Reply-To: List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk --lQnHBv2c95Os0Rgb Content-Type: text/plain; charset=us-ascii Content-Disposition: inline Content-Transfer-Encoding: quoted-printable On Fri, Oct 11, 2024 at 08:18:58AM +0000, Bertrand Drouvot wrote: > On Fri, Oct 11, 2024 at 11:07:29AM +0300, Kouber Saparev wrote: >> Unfortunately not, we are running 15.4 and planning to upgrade very soon. >> Is the patch mentioned already merged in PostgreSQL 16? >=20 > Yes, as of 16.4. Right. I'd surely welcome more eyes on what I have posted here: https://www.postgresql.org/message-id/Zm-8Xo93K9yD9fy7@paquier.xyz I am a bit annoyed by the fact of making PgStatShared_HashEntry slightly larger to track the age of the entries, especially as this comes down to being useful only when OID wraparound for all stats kinds (well, except replslot data, because slot IDs can be more aggressive or custom pgstats), but I don't really have a brighter idea for the reason that this is something that we need to track at entry-level to be able to tell across backends when a single stats dshash entry can or cannot be reused. -- Michael --lQnHBv2c95Os0Rgb Content-Type: application/pgp-signature; name="signature.asc" -----BEGIN PGP SIGNATURE----- iQIzBAABCgAdFiEEG72nH6vTowiyblFKnvQgOdbyQH0FAmcPDEQACgkQnvQgOdby QH3zkA/+P3jGPj8dQL5Rfyvavo6FphyCaCDXKiKT3N0bHMgC5ipPbHLh1j3f1/N5 Aa1UbGmPEbLd0K4iff36VSmNEua2bxbrRm3t0ZGSaaHnROpSblC32SJkW1KmLQ0Z ar08HCY+e0sY0hDUAZfVbZIo7/hvX06MSBLVH0T9u1jaeZ7C4boOvOdkSh5DfU7Q YaDUxpkiJzx+DorjZrBNKz61YhSiI/VPf7NniG1b6Jmtg1eQ05cwFwdQ3vYd8Lfy X7oeHuOlxwcH3RVeRNSD0k0Z4derexbHS5M1C+4GpPlsa97BGVKIlWxEitxP0R6R Uj3oU6KEkoyAWy05OzGmnlQPKUaDQdxWpLH8siAezH7cAbXTU/FraQFwQ2JQVdS1 JCxoj/9LQKuUThCP7ILFTQPr1L7Nt3GP7t7Ce4tvqfQn98M3xhF8t/6IWmwsvpnh Tk5ALreThEcDhn2EwiDi+0YVB7Rcc7pxYl3hEDTR7c9Bm8xpLtthryXSVTWoCfwe HaAydScGepCl/SgrUxh/nxQsA0XJRvErss0fklJLyA6OX7UdHneooxLt9utngq8H lhVbN+VbPGJ6rpMlWnXHWoasV+8VJeCfFtYWpgAFLIhXZqDqwvzoYq1O/E0q7grV MrB62grN+pfUxu0hLvTUxPZHFv0O+z7na4Xl21nFjsT9LlOo9e4= =8446 -----END PGP SIGNATURE----- --lQnHBv2c95Os0Rgb--