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 1w4ejl-002PhW-1O for pgsql-hackers@arkaria.postgresql.org; Mon, 23 Mar 2026 12:50:29 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.96) (envelope-from ) id 1w4ejj-00HZZU-2L for pgsql-hackers@arkaria.postgresql.org; Mon, 23 Mar 2026 12:50:28 +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 1w4ejj-00HZZI-0j for pgsql-hackers@lists.postgresql.org; Mon, 23 Mar 2026 12:50:27 +0000 Received: from fhigh-a6-smtp.messagingengine.com ([103.168.172.157]) by magus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.98.2) (envelope-from ) id 1w4ejg-00000000gVo-3Sc0 for pgsql-hackers@lists.postgresql.org; Mon, 23 Mar 2026 12:50:27 +0000 Received: from phl-compute-02.internal (phl-compute-02.internal [10.202.2.42]) by mailfhigh.phl.internal (Postfix) with ESMTP id 5E22D1400242; Mon, 23 Mar 2026 08:50:23 -0400 (EDT) Received: from phl-imap-14 ([10.202.2.87]) by phl-compute-02.internal (MEProxy); Mon, 23 Mar 2026 08:50:23 -0400 DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=burd.me; h=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=fm1; t=1774270223; x=1774356623; bh=CeY/5NVr3rpPIIt9rFdWOhz5VRYwT74Xjg/NCX4iWuU=; b= 6AM+lDnhha84jCcwBE28hAC6yFImVueexOlr6e7oB0SW6sBXqBS6O1m8snweo+Ur TcBh8rXVae9D22YakufHAFXD0frqvnThgLnpZ+FV/ur6WyGlG/d+nZ2QKmnmV6eW TtzY/k6MQbZbPqp9sMDTn1XY0clGuPsd/E7mGxmV/H1dADQOGpOoA13IMZkI7+A3 MtNxAlH3MYnT/PmE3T3adCpCE89XTZ53LphabExVqgaWiqr06ky43p+caWXObsD9 RCvDp15Fz8ViOyvdZrUSi4yANLU0RT3Vn2eWfYq4LNjmwoftFws9ggKtjL/1YA8j 2uK+W+/mOxy0AFNQ8qTRqw== 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:in-reply-to:message-id:mime-version:references :reply-to:subject:subject:to:to:x-me-proxy:x-me-sender :x-me-sender:x-sasl-enc; s=fm1; t=1774270223; x=1774356623; bh=C eY/5NVr3rpPIIt9rFdWOhz5VRYwT74Xjg/NCX4iWuU=; b=rD3No3jKoghw1KTYr 8gNdrenvaIwvr2MHGgO/TGx2S4kq/KsRob1PN2ujl7x6MWzlgh0oMaBjm03JSjoK GFDYATo2RJle74iFztx1T9Oukx1BJhCF1phH0IIf7OrYkYyyO5GXNLIIrOfJB3h6 JfFwiNe12sX/2IETjz0WixKZgIRJCR5/sGz22vjLJqjVJ0SbSa8crugdZi73Lmq/ 9/iG3ydDfLIGIrDP2MzI9sPZcF9pcObx2Z8ax7mJ3zupmSN2mqE5i8/Z7JiLtLwH 5oltVMdKvMGMmubsIycb/xpdpfKASKxBv2M9ePYfneXgqXWiv4Pg5qm9U/GY/3/h vNqtA== X-ME-Sender: X-ME-Proxy-Cause: gggruggvucftvghtrhhoucdtuddrgeefgedrtddtgdefudekjeehucetufdoteggodetrf dotffvucfrrhhofhhilhgvmecuhfgrshhtofgrihhlpdfurfetoffkrfgpnffqhgenuceu rghilhhouhhtmecufedttdenucesvcftvggtihhpihgvnhhtshculddquddttddmnecujf gurhepofggfffhvffkjghfufgtgfesthejredtredttdenucfhrhhomhepfdfirhgvghcu uehurhgufdcuoehgrhgvghessghurhgurdhmvgeqnecuggftrfgrthhtvghrnhepgfdvue dtgeevtdejjeefhedvhfelvdeivdfgfeegleefveejveeiieevgfegveevnecuvehluhhs thgvrhfuihiivgeptdenucfrrghrrghmpehmrghilhhfrhhomhepghhrvghgsegsuhhrug drmhgvpdhnsggprhgtphhtthhopeefpdhmohguvgepshhmthhpohhuthdprhgtphhtthho pehpvghtvghrsegvihhsvghnthhrrghuthdrohhrghdprhgtphhtthhopehthhhomhgrsh drmhhunhhrohesghhmrghilhdrtghomhdprhgtphhtthhopehpghhsqhhlqdhhrggtkhgv rhhssehlihhsthhsrdhpohhsthhgrhgvshhqlhdrohhrgh X-ME-Proxy: Feedback-ID: i675e48f3:Fastmail Received: by mailuser.phl.internal (Postfix, from userid 501) id 76AB8C4006E; Mon, 23 Mar 2026 08:50:22 -0400 (EDT) X-Mailer: MessagingEngine.com Webmail Interface MIME-Version: 1.0 X-ThreadId: AhY4W57vMWfg Date: Mon, 23 Mar 2026 08:50:02 -0400 From: "Greg Burd" To: "Peter Eisentraut" , "Thomas Munro" , "PostgreSQL Hackers" Message-Id: In-Reply-To: <8a70830a-5283-4926-8ca0-0131ce1a1943@eisentraut.org> References: <5542e706-c802-476c-abc2-9ecbe5cb66e4@app.fastmail.com> <8a70830a-5283-4926-8ca0-0131ce1a1943@eisentraut.org> Subject: Re: Trying out Content-Type: text/plain Content-Transfer-Encoding: 7bit List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk On Mon, Mar 23, 2026, at 7:57 AM, Peter Eisentraut wrote: > On 21.03.26 19:39, Greg Burd wrote: >> I think that $subject is interesting because it presents an opportunity to reduce the code we maintain and potentially improve performance. This thread has languished a bit on the list, so I picked it up. I've tried it out on my local systems (greenfly, unicorn, icarus, macOS, and a Fedora x86_64 laptop I use as my daily driver) using clang, gcc, and MSVC. It seems to work, I still need to measure performance. >> >> tested: >> - Linux x86_64 (GCC 14.3.0) >> - Linux RISC-V (GCC 13.3.0, Clang 20.1.2) >> - FreeBSD x86_64 (Clang 19.1.7) >> - Windows ARM64 (MSVC 2022) >> >> I realize we're close to the end of the v19 cycle, but one last look couldn't hurt could it? Attached is "v3" of his patch set. Is anyone else interested in this? :) > > We currently require MSVC 2019, so before this could be accepted, this > requirement would need to be adjusted (including documentation, > buildfarm updates, etc.). Fair point, it does seem that's the minimum supported version (2022). I'm not a Microsoft marketplace or tools expert, so I can't gauge how hard it is to require 2022 or if that'd impact too many users of PG today on that platform who choose to use MSVC over gcc or clang. I have even less insight into what Azure uses for the host OS (Linux, FreeBSD or Windows) running Postgres for their services, but lets say it's Windows and they have a requirement for MSVC when compiling. I'd bet they could switch to 2022 without too much trouble. Are there others out there that deploy/depend/use PG on Windows and have a strong bias for MSVC (vs clang or gcc)? I have no idea. > Maybe a bit late for that. It is late, and this isn't a small set of changes. I'd be curious to know if, other than the buildfarm animals that are Wnidows with MSVC < 2022, the rest would work with this change or not. I'd also like to get some objective data on performance. Would it be wasted effort for me to get this patch into a form that could be committed, tested on the farm, then rolled back if needed (a single patch)? Is that even a thing we'd consider trying out? Maybe the effort is worth it and we consider this again at the start of v20 development? best. -greg