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 1sdkqC-000dKx-Ft for pgsql-committers@arkaria.postgresql.org; Tue, 13 Aug 2024 06:17:09 +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 1sdkqA-001tGb-Ig for pgsql-committers@arkaria.postgresql.org; Tue, 13 Aug 2024 06:17:06 +0000 Received: from magus.postgresql.org ([2a02:c0:301:0:ffff::29]) by malur.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1sdkq9-001tGT-8H for pgsql-committers@lists.postgresql.org; Tue, 13 Aug 2024 06:17:06 +0000 Received: from fout1-smtp.messagingengine.com ([103.168.172.144]) by magus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1sdkq0-004bUh-Rt for pgsql-committers@lists.postgresql.org; Tue, 13 Aug 2024 06:17:04 +0000 Received: from phl-compute-05.internal (phl-compute-05.nyi.internal [10.202.2.45]) by mailfout.nyi.internal (Postfix) with ESMTP id DC47E138FC46; Tue, 13 Aug 2024 02:16:53 -0400 (EDT) Received: from phl-mailfrontend-01 ([10.202.2.162]) by phl-compute-05.internal (MEProxy); Tue, 13 Aug 2024 02:16:53 -0400 DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=eisentraut.org; h=cc:cc:content-transfer-encoding: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=1723529813; x=1723616213; bh=aiteKGa91EfBVsa8uzEfdT+fiidMYkV/ ukvRfQkrqc4=; b=3pk6wvgypmhE3zvXaLZfosrENikG9KPYuSR7a45fKRlFE50K AW40x/uq8J+9hyaBBmDz07Tb4zrt/czV8AAIBtwKKGIpRwYp+LnCgWGkc964Mlq9 DkhGDIp71R4x84o6nfHGavcOoC6H8uT98awX+6Io+1ON78USep4Vkx+qfT0njmUI CjbkhqwHhMsnHrReWUyLJ8DUlbw7+HH8T5itbBfVjehGGjJlskz4JJ96V3WkuT2p 3RCxJhZ3TyJZOKbienhsIE+aD1b+xZA8/blHFwhS8ecWQLUEpj0fVIh3HNoZv0C4 YKeERTKaAfYmcBNgn1k1YPc7ZKthuxo3m7iIyA== DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d= messagingengine.com; h=cc:cc:content-transfer-encoding :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=fm3; t=1723529813; x= 1723616213; bh=aiteKGa91EfBVsa8uzEfdT+fiidMYkV/ukvRfQkrqc4=; b=H VI89fO59CNURtbdvjT8TU4xFtqA4PMuw/e9CvhNI5F7sa2rbnhpGl3mRx5HADZ2H v28o7U61TDrIeuaY7Fzc87HCw7uA0RLitxKO+KjnQkNOUWBK9B6OGCnvXS8AlcXM /8wDMSDvu9TEMxzi0sClMvHO6IbQR7ThGmA69ECDFteujDNe9R4ZQRkl2B9HOkP9 nX7qi7FbHdX9PBBgrjGIMVSVjyTHzQ2+fAmhBPSucsBxcBPMnKB1WktF70gBnePI C3vb50tE7CDnGC/vlrWz2Excwa23aemyrqCueenbQfKOGSvrrAmiJtwbtcxf7d1z 7eDulAu8bLONAoMRaLtQA== X-ME-Sender: X-ME-Received: X-ME-Proxy-Cause: gggruggvucftvghtrhhoucdtuddrgeeftddruddtuddguddtjecutefuodetggdotefrod ftvfcurfhrohhfihhlvgemucfhrghsthforghilhdpggftfghnshhusghstghrihgsvgdp uffrtefokffrpgfnqfghnecuuegrihhlohhuthemuceftddtnecusecvtfgvtghiphhivg hnthhsucdlqddutddtmdenucfjughrpefkffggfgfuvfevfhfhjggtgfesthekredttddv jeenucfhrhhomheprfgvthgvrhcugfhishgvnhhtrhgruhhtuceophgvthgvrhesvghish gvnhhtrhgruhhtrdhorhhgqeenucggtffrrghtthgvrhhnpeetffevleefledtvdejgedt feejgfelfeelvdfffeejudejveehiefggfejgffggeenucffohhmrghinhepphhoshhtgh hrvghsqhhlrdhorhhgnecuvehluhhsthgvrhfuihiivgeptdenucfrrghrrghmpehmrghi lhhfrhhomhepphgvthgvrhesvghishgvnhhtrhgruhhtrdhorhhgpdhnsggprhgtphhtth hopeefpdhmohguvgepshhmthhpohhuthdprhgtphhtthhopegrvghkohhrohhtkhhovhes ghhmrghilhdrtghomhdprhgtphhtthhopehmihgthhgrvghlsehprghquhhivghrrdighi iipdhrtghpthhtohepphhgshhqlhdqtghomhhmihhtthgvrhhssehlihhsthhsrdhpohhs thhgrhgvshhqlhdrohhrgh X-ME-Proxy: Feedback-ID: ie0a040ee:Fastmail Received: by mail.messagingengine.com (Postfix) with ESMTPA; Tue, 13 Aug 2024 02:16:52 -0400 (EDT) Message-ID: Date: Tue, 13 Aug 2024 08:16:51 +0200 MIME-Version: 1.0 User-Agent: Mozilla Thunderbird Subject: Re: pgsql: Fix more holes with SLRU code in need of int64 for segment numbe To: Alexander Korotkov Cc: Michael Paquier , pgsql-committers@lists.postgresql.org References: <7AD52B27-1F6A-4F1B-9420-8C11ADAC6343@paquier.xyz> Content-Language: en-US From: Peter Eisentraut In-Reply-To: Content-Type: text/plain; charset=UTF-8; format=flowed Content-Transfer-Encoding: 8bit List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk On 12.08.24 23:35, Alexander Korotkov wrote: > On Fri, Aug 9, 2024 at 4:09 PM Peter Eisentraut wrote: >> On 08.08.24 01:15, Michael Paquier wrote: >>>  >>>> On Aug 8, 2024, at 5:05, Alexander Korotkov wrote: >>>> On Wed, Aug 7, 2024 at 10:52 PM Peter Eisentraut wrote: >>>>> It looks like the commit I'm talking about here is a subset of v55-0001 >>>>> from that thread? >>>> >>>> Yes, looks like this. >>>> >>>>> So why is some of this being committed now into v17? >>>>> But as I wrote above, I think this approach is a bad idea. >>>> >>>> OK, I agree that might look annoying. So, it's better to revert now. >>>> Michael, what do you think? >>> >>> The argument is two-fold here. The point of this change is that we were forcibly doing a cast to int with int64 values returned, so this commit limits the risks of missing paths in the future, while being consistent with all the SLRU code marking segment numbers with int64 for short *and* long segment file names. >> >> No, this is not what *this* patch does. (I suppose some of the related >> patches might be doing that.) This patch just casts a few things that >> are int to unsigned long long int before printing them. > > As pointed by Noah Misch [1], unlike the commit the patch [2] also > changed segment-returning functions to return int64. Thus, in the > patch output formats make much more sense, because they match the > input data types. Michael, are you intended to push the remaining > part of the patch [2]? > > Links > 1. https://www.postgresql.org/message-id/20240810175055.cd.nmisch%40google.com > 2. https://www.postgresql.org/message-id/ZqGvzSbW5TGKqZcE%40paquier.xyz Ah yes, it makes sense together with [2].