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 1rXnzS-00CkHp-3d for pgsql-hackers@arkaria.postgresql.org; Wed, 07 Feb 2024 19:53:50 +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 1rXnzR-00CwLF-86 for pgsql-hackers@arkaria.postgresql.org; Wed, 07 Feb 2024 19:53:49 +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 1rXnzQ-00CwL6-KB for pgsql-hackers@lists.postgresql.org; Wed, 07 Feb 2024 19:53:48 +0000 Received: from wfhigh4-smtp.messagingengine.com ([64.147.123.155]) by makus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1rXnzO-005asC-4E for pgsql-hackers@lists.postgresql.org; Wed, 07 Feb 2024 19:53:47 +0000 Received: from compute3.internal (compute3.nyi.internal [10.202.2.43]) by mailfhigh.west.internal (Postfix) with ESMTP id E8F7E1800076; Wed, 7 Feb 2024 14:53:43 -0500 (EST) Received: from mailfrontend2 ([10.202.2.163]) by compute3.internal (MEProxy); Wed, 07 Feb 2024 14:53:44 -0500 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 :reply-to:subject:subject:to:to:x-me-proxy:x-me-proxy :x-me-sender:x-me-sender:x-sasl-enc; s=fm3; t=1707335623; x= 1707422023; bh=6mal/Hd11YIrb4OipExIthb/eDElhZ2LUfw79d1sDZY=; b=e 2gmn9q5RzuPbOKW74ZhpofW8tOizPXAoFc8Q3gV7Esyz+8sDcVo9GLBQEQzI/HnZ 1kWf47pC+aLNLxUPCuG8q7RSSgUdqj7awaa2RnsWgZA2NQJ0AFZgPUUVfYkpt6kG 8M9szx7RNcq50sxjf9tH3kr7yiUuLa9SZ7w/BIJyvLZEjWK1hB19JtlsmMUvb8uq pEHZDOzPQR39QF+XmW+1sy27YhbmUCOHDOp7NTfkyhi/L8pNrkMk1rzsVrLJJNFt Yq3rUtpDoD+xkXRfjGDbHAroyCyo7vBjAxPVdfQ60dOHjDAUZRePV0VXsTPI79dW MsDIRPbpsKZ0jmsopMB7A== X-ME-Sender: X-ME-Received: X-ME-Proxy-Cause: gggruggvucftvghtrhhoucdtuddrgedvledrtddvgdduvdekucetufdoteggodetrfdotf fvucfrrhhofhhilhgvmecuhfgrshhtofgrihhlpdfqfgfvpdfurfetoffkrfgpnffqhgen uceurghilhhouhhtmecufedttdenucesvcftvggtihhpihgvnhhtshculddquddttddmne cujfgurhepfffhvfevuffkgggtugfgjgesthekredttddtjeenucfhrhhomheptehlvhgr rhhoucfjvghrrhgvrhgruceorghlvhhhvghrrhgvsegrlhhvhhdrnhhoqdhiphdrohhrgh eqnecuggftrfgrthhtvghrnhepueeigfffueektdfgteeuuefgtedvueehgfehleefheel jeelfeffjedttdekvdejnecuffhomhgrihhnpehpohhsthhgrhdrvghspdgvnhhtvghrph hrihhsvggusgdrtghomhenucevlhhushhtvghrufhiiigvpedtnecurfgrrhgrmhepmhgr ihhlfhhrohhmpegrlhhvhhgvrhhrvgesrghlvhhhrdhnohdqihhprdhorhhg X-ME-Proxy: Feedback-ID: ia2694551:Fastmail Received: by mail.messagingengine.com (Postfix) with ESMTPA; Wed, 7 Feb 2024 14:53:43 -0500 (EST) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/simple; d=alvh.no-ip.org; s=schmee; t=1707335620; bh=+JtF92Yn5mdfQ0oLFwAUXiwhxo/tDtRdLAbLUinZ974=; h=Date:From:To:Cc:Subject:In-Reply-To:From; b=ULn1TqRKpsGWf6Njd8YhB4ntIQpJle8u+BLJuFanS18mCDXMl142h7D4+iLxHJu1+ FyRjDLhKzSgQ4pWINnLTmFMN7qxTFt3Rmywnr7/cNsidAbabDYN058zueXu8B968mo UR8DRPTPyUKXSY2m6APjZ7e/lNd/vnMyb/1k/zQ78Sd6k4ScRAfraSQHDWIs9SOcEF aQqlict0l3IZgEPphG7edtTtDeuEPaz539Wlumb9HQAOq26uQL1Ag3tuoVkITkl6mE CHMrNEegZKcTTxUyGzaNNinw6JDLMeDRww8L/uDlHnq2/7AokzO6y9KEFxT5+QwlHU gx9IPyl5pYe7g== Received: by schmee.alvh.no-ip.org (Postfix, from userid 1000) id C28B4BA3; Wed, 7 Feb 2024 20:53:40 +0100 (CET) Date: Wed, 7 Feb 2024 20:53:40 +0100 From: Alvaro Herrera To: "Amonson, Paul D" Cc: "Shankaran, Akash" , Nathan Bossart , Noah Misch , Tom Lane , Matthias van de Meent , "pgsql-hackers@lists.postgresql.org" Subject: Re: Popcount optimization using AVX512 Message-ID: <202402071953.5c4z7t6kl7ts@alvherre.pgsql> MIME-Version: 1.0 Content-Type: text/plain; charset=utf-8 Content-Disposition: inline Content-Transfer-Encoding: 8bit In-Reply-To: <202402071013.reqe3bdnjjuj@alvherre.pgsql> List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk I happened to notice by chance that John Naylor had posted an extension to measure performance of popcount here: https://postgr.es/m/CAFBsxsE7otwnfA36Ly44zZO+b7AEWHRFANxR1h1kxveEV=ghLQ@mail.gmail.com This might be useful as a base for a new one to verify the results of the proposed patch in machines with relevant instruction support. -- Álvaro Herrera 48°01'N 7°57'E — https://www.EnterpriseDB.com/ "We're here to devour each other alive" (Hobbes)