Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1pZlrN-00034X-Bs for pgsql-hackers@arkaria.postgresql.org; Wed, 08 Mar 2023 04:57:05 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.92) (envelope-from ) id 1pZlrM-0008Eb-8w for pgsql-hackers@arkaria.postgresql.org; Wed, 08 Mar 2023 04:57:04 +0000 Received: from makus.postgresql.org ([2001:4800:3e1:1::229]) by malur.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1pZlrL-0008EL-Vk for pgsql-hackers@lists.postgresql.org; Wed, 08 Mar 2023 04:57:03 +0000 Received: from mail-pj1-x1034.google.com ([2607:f8b0:4864:20::1034]) by makus.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_128_GCM_SHA256:128) (Exim 4.92) (envelope-from ) id 1pZlrJ-0004bY-OZ for pgsql-hackers@postgresql.org; Wed, 08 Mar 2023 04:57:02 +0000 Received: by mail-pj1-x1034.google.com with SMTP id q31-20020a17090a17a200b0023750b69614so870903pja.5 for ; Tue, 07 Mar 2023 20:57:01 -0800 (PST) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=20210112; t=1678251421; h=in-reply-to:content-disposition:mime-version:references:message-id :subject:cc:to:from:date:from:to:cc:subject:date:message-id:reply-to; bh=lXKcxQit+S4fh492l85acfAt3DP6LsCYhvewMKQmRFM=; b=cFNtBDI18BUsFOmX/Yb2ZnpuHeuy1gKekRqj6LLDlf0GvDy5hQfcIJoTmjY/QPh/cW B4OBKHg9G0M3O/grttjqKAdW8xGnZJiAprv4Byrof3TXucvFThajf1lcC1Rd5xIZgj7M YYEmvNo5WhlxST1IG1/emrGFXZ5uJO8rrQnF7M0H3tz5lP9UfaBtubP4VrLycflvtwH+ OrmukOLDBRZ7SPvRPYiIWnopBYO/5aN4jHumg7F7MD9rqsMCmAUl1AelutzavXDMFEOA 7oe0a2lhjCZyyea/iXC3UyNlYKVM9CYDGGh18TEO9X8Y7kYz7BUAMGO1YM/lcBISivjt wn5A== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20210112; t=1678251421; h=in-reply-to:content-disposition:mime-version:references:message-id :subject:cc:to:from:date:x-gm-message-state:from:to:cc:subject:date :message-id:reply-to; bh=lXKcxQit+S4fh492l85acfAt3DP6LsCYhvewMKQmRFM=; b=TYOHiPxQav/cfudrmBmId1QV4Rivr4uTXtUFzAjaAf9BNE61L+Df9drJiFxWvKY/mG Fre49inJB/B6/iouzPiLVuMgnF0nPhQFtHNaijX/V10uqXTDb6kFBcSsspBADJOZH/1d 9z5rVFxGNA4dtqrYgpR9ShR/mU+SaSne1j93UT65L4JEHuioYPRsTW9ATfZgerfGCgfv ea/pWT5G0lGDPcD2tSyw12Uxjxbd+o1JINpusqK8Ry8u6uNboEpn58wqpYLIp9p5H8Nw rC+jiEV0KZ6fhcgnM2EwUJbOqXUGuQjKjaQLngkAKFEh/aqcC/+Ftn3sgfbdt7s3bYTU 94jQ== X-Gm-Message-State: AO0yUKVN3A6dVTiHVYCDL+wE4tqnBEtASYVz7S5b+6rQZ1hJgyEjm27m 5BvHtBOXCqca7R4qGxi1gVo= X-Google-Smtp-Source: AK7set9H2nZTITYki9NnIIjUPK/w/d+r1IeTu7KkRolz5bP4g8uImOPGRub/OmOrbXY9D1E16ut3SQ== X-Received: by 2002:a17:90b:1e01:b0:237:39b1:7cb1 with SMTP id pg1-20020a17090b1e0100b0023739b17cb1mr17895215pjb.19.1678251420595; Tue, 07 Mar 2023 20:57:00 -0800 (PST) Received: from nathanxps13 ([50.47.162.83]) by smtp.gmail.com with ESMTPSA id k9-20020a6568c9000000b005038291e5cbsm1506844pgt.35.2023.03.07.20.56.59 (version=TLS1_3 cipher=TLS_AES_256_GCM_SHA384 bits=256/256); Tue, 07 Mar 2023 20:56:59 -0800 (PST) Date: Tue, 7 Mar 2023 20:56:58 -0800 From: Nathan Bossart To: David Rowley Cc: pgsql-hackers@postgresql.org Subject: Re: optimize several list functions with SIMD intrinsics Message-ID: <20230308045658.GA3419785@nathanxps13> References: <20230308002502.GA3378449@nathanxps13> MIME-Version: 1.0 Content-Type: text/plain; charset=us-ascii Content-Disposition: inline In-Reply-To: List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk On Wed, Mar 08, 2023 at 01:54:15PM +1300, David Rowley wrote: > Interesting and quite impressive performance numbers. Thanks for taking a look. > From having a quick glance at the patch, it looks like you'll need to > take some extra time to make it work on 32-bit builds. At the moment, the support for SIMD intrinsics in Postgres is limited to 64-bit (simd.h has the details). But yes, if we want to make this work for 32-bit builds, additional work is required. -- Nathan Bossart Amazon Web Services: https://aws.amazon.com