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 1vv8vq-005Syw-0Z for pgsql-hackers@arkaria.postgresql.org; Wed, 25 Feb 2026 07:03:38 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.96) (envelope-from ) id 1vv8vo-004oDo-0j for pgsql-hackers@arkaria.postgresql.org; Wed, 25 Feb 2026 07:03:36 +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 1vv8vn-004oDf-32 for pgsql-hackers@lists.postgresql.org; Wed, 25 Feb 2026 07:03:35 +0000 Received: from mail-qt1-x842.google.com ([2607:f8b0:4864:20::842]) by magus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_128_GCM_SHA256 (Exim 4.98.2) (envelope-from ) id 1vv8vl-00000001BCE-0bm1 for pgsql-hackers@lists.postgresql.org; Wed, 25 Feb 2026 07:03:35 +0000 Received: by mail-qt1-x842.google.com with SMTP id d75a77b69052e-5033387c80aso8287321cf.0 for ; Tue, 24 Feb 2026 23:03:33 -0800 (PST) ARC-Seal: i=1; a=rsa-sha256; t=1772003013; cv=none; d=google.com; s=arc-20240605; b=AAJvk50+1v/P68ghQLDZFiP5xUgPQLIaHsv3ArUwEEN70YonQivGb/y3Vi5dlNCCH5 mSUgbQrA3dIN1fqMnLLW3GVqnMu0GURZXiFFNVUf4lvjgg8SsgJHOVoEA5IKP+FWwfCk IcJF47Wg6/dABOnAK/+BhxxIaENRSevc2uyETEe5WOWUMKusEPlfA/F9RXZGFzvkUR4u CsbpvImTVRc3fIPNnJi5vWl9TmBConrNmtfxUg/tyVbcA9xhHHAW7vq12SaGlzid4hOI q8DBhsaiGyRJBS3xy3ecsBGmdPkcuOwl+J1CfT4a+Eo+ZIs2K6JRrpP6eKn11jq9iNpP wsvw== 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=o4kekOinXYbxAh5rD+/6Svt7nDG9oWoOiHFmtBWAlk0=; fh=Qhc/LFtXhyoSKJijekYN/ZM0H/D6xLlaMDLJ978D+7s=; b=JZEOvNXCiDw4qHn95PmTwfPjk36N2E0rHU5KUyh+adOl0TfH1A6Ou6CxOjvjYIYlBp Bc0IG32UHNjN/8mJK9xaI1Y/j6ZKb8MJ0xEmiFJCoKm2E210bfQaAXlrRJYp0TsEZsL+ YcG7ZgUIN4fU3K7UnMxjPIowvLeLTWL539vxTITGPyW7qGgbSjOBhsmuIiI4BhtxPVQR PR/5Tut6DeGFjX/PnWbCVX+Avny7psTX1OkMJSw1ompIHbJu9WDmt6BJvnG5UDLxaxXk 0Q50fAzkQHEtYvCc07VglsJ2zm9780zBT6U2xN+25vfnpZW7zS57/DI1FgpNvWSXUJma VkaA==; 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=1772003013; x=1772607813; 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=o4kekOinXYbxAh5rD+/6Svt7nDG9oWoOiHFmtBWAlk0=; b=AsF8gXAus+XFm/HWoe0+4Em5zLA3rfXbTIZOEdxBajoGFdFYelBXB6Tll/5gFLD0Zj 419lwxboT8Sj+SLe+HPR/6teXDCkaEu84YlmD4af1aZzWoX/pXxiRrwS0xgUng80kpCF ybVZGp1KE01yn0kSyQACy2b1+5vkK09gUsOEsCxMBvaM2fz6hLWQnt7OESEzOjaNJPQY UuL2XLZhCKYI0U0zRO0t7LQIHHZH4bjmqVdnOgfp+h0qxAgNovRoP6nTvFXFlp2fPmHa JOS4KWS9IMNj6CyUqLNBhoYWxU+p2IsiOTyhrgExAJ0vy2IPAXh80jcbbyCqXoNgXbad 7ukw== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20230601; t=1772003013; x=1772607813; 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=o4kekOinXYbxAh5rD+/6Svt7nDG9oWoOiHFmtBWAlk0=; b=aR+zK7joQ3jOVlXg9PCaQJKDD2jLBOq0x4DMYoByTLcMn5f4nSKDsFM+JFBrrRUvQI VzSlyCnApfVxxprwMvL8QeQn1/2qzSfsNcBPZeIKQhDlt4TtFToWR78b2k0KkmVm6EYk RRASKP63SEpSOWN/X71Kp3Cgpt+V5IUbTBf5AaJRpgUQbApt667YMDiZzmrO7ERhYWxV P/BWDb2yAHmv6KfkMSHo5ut4dPy4KsjKJMWzE9E2QTArrB4sGAtWNJ2SUJ/bE/21Pz65 PG45fFnez5+oQW4aJbDa/h/Z/YJQw4gjv5WWQZSLecMVy8bKCAp1woKUzGJBsrB2U994 kFcQ== X-Forwarded-Encrypted: i=1; AJvYcCWr3NDgTygKBKVRRpe7EWz3UCVoCwrtQ1VRuUPEseN9xQ8j/8t8oaaRP/CEWJw0sWuuGwqmgXQaMLx7f61G@lists.postgresql.org X-Gm-Message-State: AOJu0YyOgT5//9PErpREFEXuXI6H6/OXQX0fzb0Mt6u881U+6Jslhkz7 5UX0xQ2OWTCE8J8p9+eOaHA6uWhJlZ4rGVsv36Atol/7bOrvKP8s9z8hw7yjxuutceF7YiVES1f ch4atMIu48iwg89OP+D5FioPvG/oZiI4= X-Gm-Gg: ATEYQzw3aC4nb8HPumv2d3+nUpXaSwuYAphZ5geNDP6rcuU/X2MiZutld6lDJViVJEV pHM1k3quxY9zZtxkn+96bt/zSG8YhBARhtJf0rO7680QOiqqI+b/Y9SUSzCjeTYJhT2YfZAJMYb pP1r/qm0gUJ3+gAqor68HBlmi3ffL//ezwwqmGQNJoeVdXtFNHQ72T+xS/vuZrW+ng1atRR98+g dnZMSRUrXs+Eds54d9hNU6i1gxgSGNccumHOUgBDGmkVjAOSphFb850/BcwvXnDdF1wenI95DWQ rqaJBTp8zFT4lauJF7VHDbfKGueZ3KNgD2mgqI2weGvH97ya0Ue3/zlm91wexokF+Kib35KHUCD M/rTe8HccvdLybh/Rx28zNBZO8zs= X-Received: by 2002:a05:622a:118e:b0:4f1:83e4:70d0 with SMTP id d75a77b69052e-50736615cd9mr31487431cf.34.1772003012757; Tue, 24 Feb 2026 23:03:32 -0800 (PST) MIME-Version: 1.0 References: In-Reply-To: From: John Naylor Date: Wed, 25 Feb 2026 14:03:21 +0700 X-Gm-Features: AaiRm538Z8zU4DteSCfxhBE2JxmMog6xcRSGtRNlDjqABAQ2HMlFxOSxkBfoEts Message-ID: Subject: Re: More speedups for tuple deformation To: David Rowley Cc: Zsolt Parragi , 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 Wed, Feb 25, 2026 at 7:40=E2=80=AFAM David Rowley = wrote: > On Wed, 25 Feb 2026 at 07:33, Zsolt Parragi w= rote: > > Won't this mix up column numbers on big-endian systems? > > Yes, I believe you're right. I've added the following before the memcpy()= . > > #ifdef WORDS_BIGENDIAN > > /* > * Fix byte order on big-endian machines before copying to the array. > */ > isnull_8 =3D pg_bswap64(isnull_8); > #endif I confirmed regression tests bail out early on a big-endian machine with v9 and pass with v10. --=20 John Naylor Amazon Web Services