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 1vm43V-006scg-0c for pgsql-hackers@arkaria.postgresql.org; Sat, 31 Jan 2026 06:02:01 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.96) (envelope-from ) id 1vm43S-007TYn-1t for pgsql-hackers@arkaria.postgresql.org; Sat, 31 Jan 2026 06:01:59 +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.96) (envelope-from ) id 1vm43S-007TYf-0u for pgsql-hackers@lists.postgresql.org; Sat, 31 Jan 2026 06:01:59 +0000 Received: from mail-qt1-x842.google.com ([2607:f8b0:4864:20::842]) by makus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_128_GCM_SHA256 (Exim 4.96) (envelope-from ) id 1vm43Q-000HNe-2U for pgsql-hackers@lists.postgresql.org; Sat, 31 Jan 2026 06:01:58 +0000 Received: by mail-qt1-x842.google.com with SMTP id d75a77b69052e-5032e15525aso28384951cf.3 for ; Fri, 30 Jan 2026 22:01:57 -0800 (PST) ARC-Seal: i=1; a=rsa-sha256; t=1769839316; cv=none; d=google.com; s=arc-20240605; b=YGQLifpCojLt2WyrTIKI0TOcAXNtR6v7iW77Eqw4X1deivoc1ksE3XEvn6FJzFvXaa nadxKBkdnwZgO5ZXC+zQWPhAA4lxUQsNlhTZ2PLJ5iMrA4rZbdl+fv7F/kw8l5ZUjVEq AbNJgl8EcT2VTwVhFe7/aMJkU9QIig6kcKUZnTGo+hezBGr4QXKUXAXcEmK+KdN8iXkh Fo29zgAiyHYgAGaOczZOFB4aUO9wuoh+YB6y4q6N8/qQ1QHj/T6Ryar+6GCL2tM0Ytqs yMKlhkbl7LTIS5U4lZb87yF4qVx/lbQiOXSx7f1zmAsJRJ27pomlsJGxxbtsApbw88uj tekQ== ARC-Message-Signature: i=1; a=rsa-sha256; c=relaxed/relaxed; d=google.com; s=arc-20240605; h=content-transfer-encoding:cc:to:subject:message-id:date:from :in-reply-to:references:mime-version:dkim-signature; bh=vmMnG/gdGCce93c6j66GkNDQF7ilGZdE9xVe8egyUFs=; fh=d9mtqVCiJPRMqwAEPZxvLM73+ukYOu8M3NRiySDXUeg=; b=Duct4qY+XKGo9eDe+WEteE27RBjUBDeX2g67gYFsHZMTBOpriZ5IzCMfyK/9GFkcop ilBXisr8PUZKZkWDmiWE5D30q1+Pyoavv6BT/SWSGPSzCpGzQUIF/98oAccu+5dCtctp n0fw4dy98uLFSBC7AKOOn490GcS4bRPoKOlLLSNb8IwP8WFyeH353JHHOHHB2o04TlTB Ho5+Fl4VpECxNS/fB5mOVSh3LjipMhX5bD55bcQ2nCbJdFhEdHlo15dk9VPuNELIf+8u 0/zJhlu0CTeGOv9juQTQynvNheY+OOsT5OFikXo32j5YvNRxJKrgC/YCbreHm7D45SYl NbTA==; darn=lists.postgresql.org ARC-Authentication-Results: i=1; mx.google.com; arc=none DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=20230601; t=1769839316; x=1770444116; darn=lists.postgresql.org; h=content-transfer-encoding:cc:to:subject:message-id:date:from :in-reply-to:references:mime-version:from:to:cc:subject:date :message-id:reply-to; bh=vmMnG/gdGCce93c6j66GkNDQF7ilGZdE9xVe8egyUFs=; b=PVQVlO2rAjj9l7fI6bN8Eo87riLSyXHjbtcHMXAsYGmmw4hKler31f/zMjJPthVazO p+OLHHwnyPPHklXDxF0+C5zhJjaaxwt3+Nf1R5JkISefavnTgRt86SxdCHyji4VBoI09 vWUmh2XAL8P+Ub2VqzZlA4ZfRZuHLsAen2qc7LcZKpcO/XCjgOnTSuJupBCcLcr7mASE 9kqJw3b6EKovICRhnTNmH0jAj6hs3DQBQW9NUcXQlqGdRrlWinxEGHUs1Mx91skF9niN akXVusjoDnClZsfUkUAuNfbJvxqPoPZBJ5uuvG1eMAvozpLxTqjS8SHS6Eze0AowENEg A61A== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20230601; t=1769839316; x=1770444116; h=content-transfer-encoding:cc:to:subject:message-id:date:from :in-reply-to:references:mime-version:x-gm-gg:x-gm-message-state:from :to:cc:subject:date:message-id:reply-to; bh=vmMnG/gdGCce93c6j66GkNDQF7ilGZdE9xVe8egyUFs=; b=bKxB3U+3nyOdWmM2JWhqYCkVXg48Jo/5wCKuqhKhlWB4SHkRpSl7E6eeOw+EOuBRlt tGTIFWH+XXNjCNwmZBzXMhSqCt27Gi6Kn3SEeC04GfhfjgmhGZqSBN3upbnemXCRwIlq 3bvzDjPeYTI6JvhurJBvn/5mi8slcfEpICyu/NE2LsMgYv6Ktx8+8UqRwG38VXRhhK6q V/ERU78tVERHbdUUH6yU1Iffg2SZ6XbxR4VzV407unTMJgKo7p/3BE+C1hdN+CagbtXP 5wiKyGGNfUFllVrFE+lTCHEyxM2KCur7EaXAJXZcTznMSPs/MNybvK/CoQggIM7VMWM7 NbKQ== X-Forwarded-Encrypted: i=1; AJvYcCWc5RXvQh4DnXVc5ZOnFylCYmEOtKO3Up1EHQ99LHs6YAfomcJk3PRLp8fMEv7YDjFe7P0cbnG9Jq+eU7Ht@lists.postgresql.org X-Gm-Message-State: AOJu0Ywtb3s5SubjiFcodRxQ4HOrGui+DPWe8DP7+g3mwigPPL39l+ko IPoZc7OvhMf24hJAsN2QczNSyxKPgwGbdvVQmkzQmEgQF/hY9flsMZzYTlDuhkDwBrVXkYM93wm PAvpt5eS0Ql9l4fUpHYfIigdm0JdKbzQ= X-Gm-Gg: AZuq6aJyFa+7rrelcqwOKqfMWIWhnuCXPtoQDbOUqUl7yWvBAkP4Xkn+kDHldc1AIAo ERxuP/AlTwnxleY9PX5z46+5a8+5E45T3bAneJz6GZTvItEflNwfqHKSle93XJfPO69HpDYho5N UJy9hj6DehJNSVKxFIuXoji7oofDaXfIZTuZCGwKW9X9/sxIhU0hFaOHcWaMMQSDOR9yyLsIq5D AXMcwyV2lCU8oKs1K/lO6thOpMnEx3Q+UCb6Bewr5rMzS3I8QGOd5WFOAAF0FrSQEYgITkDoL+A rOgof/PGgqnTcAPl+BICikvldGzh9Wp/tz7GqvDc2UrXESS0BC6gCeJeFVq0rIb0E0sljK1TJ+1 by6nLd9zFJ46d7Yc= X-Received: by 2002:ac8:5d8a:0:b0:4f4:d2c3:b236 with SMTP id d75a77b69052e-505d226cba3mr69672761cf.47.1769839316589; Fri, 30 Jan 2026 22:01:56 -0800 (PST) MIME-Version: 1.0 References: <9A17C43D-7A28-4885-8974-555A40C9523E@gmail.com> In-Reply-To: From: John Naylor Date: Sat, 31 Jan 2026 13:01:44 +0700 X-Gm-Features: AZwV_QgdUzy2fAC708_ft981F_-HXB0MECS8zgx_d0FTIsI8PqhwqaGl40IzED0 Message-ID: Subject: Re: More speedups for tuple deformation To: David Rowley Cc: Andres Freund , Chao Li , PostgreSQL Developers 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 On Sat, Jan 31, 2026 at 10:45=E2=80=AFAM David Rowley wrote: > On Sat, 31 Jan 2026 at 15:48, John Naylor wrote= : > > pg_rightmost_one_pos32(~((uint32) bits[bytenum])) > > I'd rather handle that in a single byte as the fallback path in that > function requires byte-at-a-time processing. I spot checked some less common animals in the buildfarm and i686, ppc64le, riscv64, loongarch64, and s390x all have the builtin. Of these, only riscv64 seems to lack a single instruction implementation. It's good to keep the old fallback path around just in case, but I doubt a new fallback would get any coverage at all. --=20 John Naylor Amazon Web Services