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 1sYXAw-00C62H-9E for pgsql-hackers@arkaria.postgresql.org; Mon, 29 Jul 2024 20:40:58 +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 1sYXAu-00313e-Mj for pgsql-hackers@arkaria.postgresql.org; Mon, 29 Jul 2024 20:40:56 +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 1sYXAu-00313Q-DK for pgsql-hackers@lists.postgresql.org; Mon, 29 Jul 2024 20:40:56 +0000 Received: from fhigh3-smtp.messagingengine.com ([103.168.172.154]) by makus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1sYXAr-0025vl-JC for pgsql-hackers@postgresql.org; Mon, 29 Jul 2024 20:40:55 +0000 Received: from compute7.internal (compute7.nyi.internal [10.202.2.48]) by mailfhigh.nyi.internal (Postfix) with ESMTP id CA33011401C1 for ; Mon, 29 Jul 2024 16:40:52 -0400 (EDT) Received: from wimap21 ([10.202.2.81]) by compute7.internal (MEProxy); Mon, 29 Jul 2024 16:40:52 -0400 DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=compiler.org; h= cc:content-transfer-encoding:content-type:content-type:date:date :from:from:in-reply-to:message-id:mime-version:reply-to:subject :subject:to:to; s=fm3; t=1722285652; x=1722372052; bh=J7QMA7uYkK mrujyfkBfWo+QD9WA4wZdsC+YT++xzPzY=; b=HSfwXVqm7A5SU/Oxou4nskoaam 8tzAINa7fgXks7WJF+fOdj0msvIgizZFzbvCfKr3jQDYx4x4R14IYqLsGzgMZWHv uLAFoXboHROZlM+YgMeQ/hrOvCTatzAHgJdOdc1EQVW2P3JTXnbN8rx6vE2+v6tj jvWFM1yWGUlxobuIisBluEWJF2NVPT2ioKoeow8PenXgAFTveiDCvRrnZ+SKV5aM KLUAoQOKEe2PcZVJxKcVbzle46Ni93tJIWH5PIYvTuUpxIP2GV2bYFtYAND1uRDw /mA3j7eSAzeidYQ1H3WSYxSbiOiObeYXf0NjK2C5v1v0LoBUbmShkPZ8O6Ig== DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d= messagingengine.com; h=cc:content-transfer-encoding:content-type :content-type:date:date:feedback-id:feedback-id:from:from :in-reply-to:message-id:mime-version:reply-to:subject:subject:to :to:x-me-proxy:x-me-proxy:x-me-sender:x-me-sender:x-sasl-enc; s= fm3; t=1722285652; x=1722372052; bh=J7QMA7uYkKmrujyfkBfWo+QD9WA4 wZdsC+YT++xzPzY=; b=rU9GAMWACtcVg1p7e7I9NRwknMybJ+CEIJ3TuEmwNZGI FSkXNdnGT3yeSCWuIefR6917ta59v2DV0gt524dskZnLM5NysSdNNtW/nmXe+mzt RfdYpbGbHpwLEvcAYmesbWNdOvXyaOcryGZC6oMRWnzdpkoqrT/IIkAytHiWM7gY hJjl1MfUlO1POVzfTLnj+JDwe58beDv+iYKTC4iDYFslRSdSdKfboexb8EyFU5QC PsiwObJC0Jf42QAo1wugrNdTZpf3dmnQp3BxGT6OIOUdUGY0a134tX01IEk0yhvT RuqARmnnjN/Pw2rdujtnSqKbWDImvCtm4rpKWiz7xQ== X-ME-Sender: X-ME-Proxy-Cause: gggruggvucftvghtrhhoucdtuddrgeeftddrjedvgdduheegucetufdoteggodetrfdotf fvucfrrhhofhhilhgvmecuhfgrshhtofgrihhlpdfqfgfvpdfurfetoffkrfgpnffqhgen uceurghilhhouhhtmecufedttdenucenucfjughrpefofgggkfffhffvufgtgfesthhqre dtreerjeenucfhrhhomhepfdflohgvlhculfgrtghosghsohhnfdcuoehjohgvlhestgho mhhpihhlvghrrdhorhhgqeenucggtffrrghtthgvrhhnpeekgfeltedvgefgffekkeejfe euieeujeeufeeuvdeuuddtuefhueehieellefgveenucffohhmrghinhepphhoshhtghhr rdgvshenucevlhhushhtvghrufhiiigvpedtnecurfgrrhgrmhepmhgrihhlfhhrohhmpe hjohgvlhestghomhhpihhlvghrrdhorhhgpdhnsggprhgtphhtthhopedt X-ME-Proxy: Feedback-ID: ic6394509:Fastmail Received: by mailuser.nyi.internal (Postfix, from userid 501) id A01DB37A0084; Mon, 29 Jul 2024 16:40:52 -0400 (EDT) X-Mailer: MessagingEngine.com Webmail Interface User-Agent: Cyrus-JMAP/3.11.0-alpha0-582-g5a02f8850-fm-20240719.002-g5a02f885 MIME-Version: 1.0 Message-Id: <73b34bf6-d2d8-4eb9-acb6-5a8cdf11674b@app.fastmail.com> Date: Mon, 29 Jul 2024 22:40:16 +0200 From: "Joel Jacobson" To: pgsql-hackers Subject: Is *fast* 32-bit support still important? Content-Type: text/plain;charset=utf-8 Content-Transfer-Encoding: quoted-printable List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk Hello hackers, I would like your help to collectively try to answer these three questio= ns: 1. Who are the current users of 32-bit PostgreSQL? 2. Among these users, how many are upgrading to new major versions? 3. For how many of these users is performance critical? This came up during ongoing work on optimizing numeric_mul [1]. To me, it's non-obvious whether introducing `#if SIZEOF_DATUM < 8` with separate 32-bit and 64-bit code paths is worthwhile to maintain performa= nce for both. Knowing more about $subject can hopefully help us reason about how much additional code complication is justifiable for *fast* 32-bit support. I checked the archives but only found a discussion on *dropping* 32-bit = support [2], which is a different topic. Thanks for input! /Joel [1]=C2=A0https://postgr.es/m/9d8a4a42-c354-41f3-bbf3-199e1957db97@app.fa= stmail.com [2] https://postgr.es/m/0a71b43129fb447988f152941e1dbcb3@nidsa.net