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 1sYG3e-00A3Qi-Ue for pgsql-pkg-debian@arkaria.postgresql.org; Mon, 29 Jul 2024 02:24:18 +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 1sYG3d-00EAHb-Ic for pgsql-pkg-debian@arkaria.postgresql.org; Mon, 29 Jul 2024 02:24:17 +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 1sYG3d-00EAHT-Cj for pgsql-pkg-debian@lists.postgresql.org; Mon, 29 Jul 2024 02:24:17 +0000 Received: from mail.thelabyrinth.net ([45.56.70.56]) by makus.postgresql.org with esmtps (TLS1.2) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1sYG3a-001xaK-Mb for pgsql-pkg-debian@lists.postgresql.org; Mon, 29 Jul 2024 02:24:16 +0000 Received: from [10.5.0.2] (unknown [185.203.219.10]) (using TLSv1.2 with cipher ECDHE-RSA-AES128-GCM-SHA256 (128/128 bits)) (No client certificate requested) (Authenticated sender: dsteele) by mail.thelabyrinth.net (Postfix) with ESMTPSA id 1B5C454681 for ; Mon, 29 Jul 2024 02:24:12 +0000 (UTC) Message-ID: Date: Mon, 29 Jul 2024 09:24:09 +0700 MIME-Version: 1.0 User-Agent: Mozilla Thunderbird Subject: Re: The end of 32-bit PostgreSQL support? To: pgsql-pkg-debian@lists.postgresql.org References: Content-Language: en-US From: David Steele In-Reply-To: Content-Type: text/plain; charset=UTF-8; format=flowed Content-Transfer-Encoding: 7bit List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk On 7/28/24 23:44, Christoph Berg wrote: > > Having seen how much time you had to spend on resolving this, I wonder > it it is finally time to sunset the support for 32-bit architectures > in PostgreSQL on Debian. I can't even remember when I've seen a 32-bit > cluster in the wild, and there's been zero complaints when I disabled > i386 support on apt.postgresql.org for bullseye. Well, not quite zero [1]. It took me a while to notice because we test 32-bit on the oldest Debian/Ubuntu and Debian 11 only because the oldest this summer. > There is a steady > stream of extension bugs specific to 32-bit, upstreams have little way > and incentive to fix that, and we waste a lot of time for probably no > users. > > Comments? Disable it all (but keep libpq5 for applications)? Continue > to build the server since it works, but disable building all > extensions? It's been years since I've had any evidence that anybody is running 32-bit in a production environment. Probably time to drop support for it. Regards, David -- [1] https://www.postgresql.org/message-id/flat/1b5a6c90-37ab-4a0c-818f-b2ae3a62850d%40pgmasters.net#5a75b557124a1e3523be1fd9809d04e2