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.96) (envelope-from ) id 1vTysI-00Expk-1B for pgsql-hackers@arkaria.postgresql.org; Fri, 12 Dec 2025 08:51:43 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.96) (envelope-from ) id 1vTysH-0077O8-0w for pgsql-hackers@arkaria.postgresql.org; Fri, 12 Dec 2025 08:51:42 +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.96) (envelope-from ) id 1vTysG-0077O0-2z for pgsql-hackers@lists.postgresql.org; Fri, 12 Dec 2025 08:51:41 +0000 Received: from lahtoruutu.iki.fi ([2a0b:5c81:1c1::37]) by magus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.96) (envelope-from ) id 1vTysF-000JTZ-1U for pgsql-hackers@lists.postgresql.org; Fri, 12 Dec 2025 08:51:41 +0000 Received: from [10.0.2.15] (unknown [130.41.208.2]) (using TLSv1.3 with cipher TLS_AES_128_GCM_SHA256 (128/128 bits) key-exchange x25519 server-signature RSA-PSS (2048 bits) server-digest SHA256) (No client certificate requested) (Authenticated sender: hlinnaka) by lahtoruutu.iki.fi (Postfix) with ESMTPSA id 4dSNVD4rxpz49Q5g; Fri, 12 Dec 2025 10:51:32 +0200 (EET) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=iki.fi; s=lahtoruutu; t=1765529493; h=from:from:reply-to:subject:subject:date:date:message-id:message-id: to:to:cc:cc:mime-version:mime-version:content-type:content-type: content-transfer-encoding:content-transfer-encoding: in-reply-to:in-reply-to:references:references; bh=N7qJTWeEc1Shylu3Sv4p750N0bJukIzYNy2NYFx5TfE=; b=aNADyVZDtqXnEHX9fQHDCHm/cfOUTGkIQprAKp7D3XGLEcYd1ERqNTTMLrmTa2AackURg3 2u6/NMhMbK4GVUGIJZ5ZpSLTEt4KPAnvI8hEAQsvjj0TLcUEA3rj8VSpyO3ivwA3N2SCmh VjZZD2eW07LVCRkZO/oGWcw3er53OK/rAKRF46zyx2Fk6GYzhinkIf+nzAuHba35K02xXK x1Wyg7JYjTx9luiYptnZ4r+tFnvpwDRYv0qeZ9q/OgLxonOGmjMBIOegzzxBQnRlUzeq9E TRm1vDnMv5Hrti2GaAPII2utViFvIcRUk3sCs57YF2TR3Bk/9butLm3QjLhMFw== ARC-Message-Signature: i=1; a=rsa-sha256; c=relaxed/relaxed; d=iki.fi; s=lahtoruutu; t=1765529493; h=from:from:reply-to:subject:subject:date:date:message-id:message-id: to:to:cc:cc:mime-version:mime-version:content-type:content-type: content-transfer-encoding:content-transfer-encoding: in-reply-to:in-reply-to:references:references; bh=N7qJTWeEc1Shylu3Sv4p750N0bJukIzYNy2NYFx5TfE=; b=IbKI6zF59cyS8tgVrQWc/gEzptnZegj43tQY8H7XoxmvATNHNRQePmysV/YZufvKh59uYe IaVy0ogPEJhPSPOiFRJjDe870xOVKYgSDjqCxU0p1uSWBvJGsoje70iRqx6z+acFdNZnhR yJDY2hic9WuWcEW++8PuyRGE5f3H0imp5hA607u12yaOW+68KOiJ8LsJEzm67IyQetoNbs Zo2G/y6A727fJCzqhI75D7/VZcgfI1P/iSZp3oVQALdXc5Yg9XKJunitnsZeFsvCnPX2mL i6EIthRso0dD5H1XZ1fFQGqGJ89g/mh+eiyf1lyAO7m5z3pf9VznuKqG98bpFQ== ARC-Authentication-Results: i=1; ORIGINATING; auth=pass smtp.auth=hlinnaka smtp.mailfrom=hlinnaka@iki.fi ARC-Seal: i=1; a=rsa-sha256; d=iki.fi; s=lahtoruutu; cv=none; t=1765529493; b=eByA3PYARe1yZ5hsuo8vK6Q5pESypMV9s3MBMcVK5O2wda8/TKS8QLK4Hsy4Oe3GsYmbj1 hBbtiJprPbZ6nJJvaRcRKBsMNrF5p7JpjUzCMf5DjDOohVCXAm1tMToh2cBYJ+o9HVzSeC MRBHL4Vc+/QhVRuoz28URl5BwpNUhI3BYe5thARMDxumVd4LilNbhBz56naclnJM9TmFJA 47xRw4WMVAvEK8SBVFf+IW6CnFMEumF9ZVghI2vAy9jOia8KQQt2iGFRrnsvTVO0K0qhdX wagI9x05SIv2Ubc/UhxHGPycy+QIXwv70NCSGYc9evR/9plR6+U3bhtf8bs4wQ== Message-ID: <2d9282d3-7f24-4e1c-af5f-cd33316dead7@iki.fi> Date: Fri, 12 Dec 2025 10:51:25 +0200 MIME-Version: 1.0 User-Agent: Mozilla Thunderbird Subject: Re: POC: make mxidoff 64 bits To: Alvaro Herrera Cc: Ashutosh Bapat , Maxim Orlov , Alexander Korotkov , wenhui qiu , Postgres hackers References: <202512110804.hmukvd7jna34@alvherre.pgsql> Content-Language: en-US From: Heikki Linnakangas In-Reply-To: <202512110804.hmukvd7jna34@alvherre.pgsql> 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 11/12/2025 22:05, Alvaro Herrera wrote: > On 2025-Dec-11, Heikki Linnakangas wrote: > >> That's a great question and I've been wondering about it myself. It goes all >> the way to the initial commit where multixacts were introduced, and I don't >> see any particular reason for it even back then. Even in the very first >> version of multixact.c, IMO it would've been simpler to have the writer >> handle the wraparound. >> >> Álvaro, would you happen to remember? > > Sorry, I have no recollections of the reason why it was done this way. Ok, I have pushed this. Thanks! - Heikki