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 1scPMj-006zTj-Og for pgsql-committers@arkaria.postgresql.org; Fri, 09 Aug 2024 13:09:10 +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 1scPMi-003Fbs-Bz for pgsql-committers@arkaria.postgresql.org; Fri, 09 Aug 2024 13:09:08 +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 1scPMh-003Fbk-03 for pgsql-committers@lists.postgresql.org; Fri, 09 Aug 2024 13:09:08 +0000 Received: from fout6-smtp.messagingengine.com ([103.168.172.149]) by magus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1scPMd-003yQz-Et for pgsql-committers@lists.postgresql.org; Fri, 09 Aug 2024 13:09:06 +0000 Received: from compute4.internal (compute4.nyi.internal [10.202.2.44]) by mailfout.nyi.internal (Postfix) with ESMTP id D248C138EB58; Fri, 9 Aug 2024 09:09:00 -0400 (EDT) Received: from mailfrontend1 ([10.202.2.162]) by compute4.internal (MEProxy); Fri, 09 Aug 2024 09:09:00 -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=1723208940; x=1723295340; bh=XdJ4hM+4lFL4+qVgGsKZ3hWvT//j2Fnl 18eH41v7BQY=; b=laXyU+5l7c3G9RCwLqfJytVPQpKGPJ1faGAeKTju+f4vxyYI nAmprwkiRoRy/uxMClY7nLKgPJphix3PhdTFFm3m6SS6OsOX0fDrSeLxUqgyjpW4 O3sL+LMeCkOxCZp9yyoKaFisHGstnxDN9bjofj4cQ8NKi5UsCNddjdXTPnbqo6Ck OqL7R1I3w6X+TWS+xE9gTDCC3RoyrSikR9skGHA336aSdjUaI56twKXztyK+y7od L0B42bOlz8je+mipT/Q7i45FFOegtSQWXLtvfJJN//2ew4bM3vQ/+0hSDZJswMpF B9sEdm49lRz+JM//4cNbRjoS0lq/ggpCsvAkfQ== 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=1723208940; x= 1723295340; bh=XdJ4hM+4lFL4+qVgGsKZ3hWvT//j2Fnl18eH41v7BQY=; b=A Eclp5fPx5G/06PClwtY9GLb97XXSvRCz8PCqJhzPTrNvi8hfW2K7evHlJh3gHixt KZvnACAByMdZRUvc0Z7kH9ShTbqgaosSgujip3eecMMH5CyF+Qh4qNCwNqse3gcV zSmuyzxMDcLjga75DGEHRuI5gBhVaR9ysDpW6y3R8uuJ26qMky3lJfkqcZDOvz1x uB/Z1xwAJPKxwEmVYAGN6PSOG8gOVRSxDzZdc1tV2l+bYtdUOoba2yDOIxDTNtD6 Sk7umvfJLDhrx8lOdllhetS5IlWyNb2OX9UFP4H4Z7J7IGNMr0CkcL23mwB70svf fw7a1EhU/CDWQQ/t18Jtg== X-ME-Sender: X-ME-Received: X-ME-Proxy-Cause: gggruggvucftvghtrhhoucdtuddrgeeftddrleeggdeitdcutefuodetggdotefrodftvf curfhrohhfihhlvgemucfhrghsthforghilhdpggftfghnshhusghstghrihgsvgdpuffr tefokffrpgfnqfghnecuuegrihhlohhuthemuceftddtnecusecvtfgvtghiphhivghnth hsucdlqddutddtmdenucfjughrpefkffggfgfuvfevfhfhjggtgfesthekredttddvjeen ucfhrhhomheprfgvthgvrhcugfhishgvnhhtrhgruhhtuceophgvthgvrhesvghishgvnh htrhgruhhtrdhorhhgqeenucggtffrrghtthgvrhhnpeejhfevhedttefgfffhhfeffefg gffhffelgfeiueeukeehvdehvdefheffvdefueenucevlhhushhtvghrufhiiigvpedtne curfgrrhgrmhepmhgrihhlfhhrohhmpehpvghtvghrsegvihhsvghnthhrrghuthdrohhr ghdpnhgspghrtghpthhtohepfedpmhhouggvpehsmhhtphhouhhtpdhrtghpthhtohepmh hitghhrggvlhesphgrqhhuihgvrhdrgiihiidprhgtphhtthhopegrvghkohhrohhtkhho vhesghhmrghilhdrtghomhdprhgtphhtthhopehpghhsqhhlqdgtohhmmhhithhtvghrsh eslhhishhtshdrphhoshhtghhrvghsqhhlrdhorhhg X-ME-Proxy: Feedback-ID: ie0a040ee:Fastmail Received: by mail.messagingengine.com (Postfix) with ESMTPA; Fri, 9 Aug 2024 09:08:59 -0400 (EDT) Message-ID: Date: Fri, 9 Aug 2024 15:08:58 +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: Michael Paquier , Alexander Korotkov Cc: pgsql-committers@lists.postgresql.org References: <7AD52B27-1F6A-4F1B-9420-8C11ADAC6343@paquier.xyz> Content-Language: en-US From: Peter Eisentraut In-Reply-To: <7AD52B27-1F6A-4F1B-9420-8C11ADAC6343@paquier.xyz> 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 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.