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 <pgsql-hackers-owner+archive@lists.postgresql.org>)
	id 1vyZ90-000Dbf-0a
	for pgsql-hackers@arkaria.postgresql.org;
	Fri, 06 Mar 2026 17:39:22 +0000
Received: from localhost ([127.0.0.1] helo=malur.postgresql.org)
	by malur.postgresql.org with esmtp (Exim 4.96)
	(envelope-from <pgsql-hackers-owner+archive@lists.postgresql.org>)
	id 1vyZ8y-006NsW-29
	for pgsql-hackers@arkaria.postgresql.org;
	Fri, 06 Mar 2026 17:39:21 +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 <byavuz81@gmail.com>)
	id 1vyZ8y-006Nql-1C
	for pgsql-hackers@lists.postgresql.org;
	Fri, 06 Mar 2026 17:39:20 +0000
Received: from mail-dy1-x1334.google.com ([2607:f8b0:4864:20::1334])
	by makus.postgresql.org with esmtps  (TLS1.3) tls
 TLS_ECDHE_RSA_WITH_AES_128_GCM_SHA256
	(Exim 4.98.2)
	(envelope-from <byavuz81@gmail.com>)
	id 1vyZ8w-00000000nzN-42d1
	for pgsql-hackers@postgresql.org;
	Fri, 06 Mar 2026 17:39:19 +0000
Received: by mail-dy1-x1334.google.com with SMTP id
 5a478bee46e88-2bdfd129c52so6137812eec.0
        for <pgsql-hackers@postgresql.org>;
 Fri, 06 Mar 2026 09:39:18 -0800 (PST)
ARC-Seal: i=1; a=rsa-sha256; t=1772818758; cv=none;
        d=google.com; s=arc-20240605;
        b=R9V08XtzDnSR0UQXJd7ecWNKJ9cZfrr6rMyDLDIKWbAFU3Nt8/6OPzlmmG+uEvC4Dh
         hZx2Osk2i/YG9TiiC1WOLKTZL2c2+Nba7tT36wUh5pDrLvFu7M6sB6WOhsPqWG4VNovn
         gcD/WoitGEzQ7M9/PkOR3DLeJ/EU0+hIpyzNW86sQERHsiFCqQMXOfAFsHdsLoZoEiJC
         pZ/alPUUgOZLN1sEbNDljS2ziYVGZOet9u+Y//aWQ4j2xpHNuGTNJOa/bA7jA2XI3V/d
         mIAdHV7LcrTsLbVhzEmupS8dkQL/xlRwVNtr/j1VQkqccGaj+/dFLYEtQb0pxuPFwKql
         UoDg==
ARC-Message-Signature: i=1; a=rsa-sha256; c=relaxed/relaxed; d=google.com;
 s=arc-20240605;
        h=cc:to:subject:message-id:date:from:in-reply-to:references
         :mime-version:dkim-signature;
        bh=nGLKbQzLbLmQUCcxhpFMjIurztQjMTtfRnt9dasddGU=;
        fh=bBlLPSFCPOuTXPl8kPaj7CFyTGs45aF8L8Lyfitla34=;
        b=lGnQfARYMe4cOnbgNF2Z2SjraRTOi7k8w7z637bFNpl/jgO84+hjBO6iok8yOF+NQ/
         tMqmeT9OB/M4/qhb3PiX9ni8C5IW0YFknhnXw8FHE4qDrYSmiRvvm+Gp/fDLk6cTXKTu
         JLjXe7E2xs2CbLW5nktsSN81Ev1SyctbA0WSebt7qbEgQWKRkW2kNmH43SCdX5KfrjIB
         SiJZK1XbY1b1iyjCI4Uk5hMPVcKOfRqakVK0srLLDJj0GYSutso13IXg3gwt+bIFSGOs
         IvKtmVtHBvaly5C4Lib5oFHD1hc4KpxOoxS2nUz+wjDc30k1d91BBI7x3oYMrXNgICWr
         Ea3w==;
        darn=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=1772818758; x=1773423558;
 darn=postgresql.org;
        h=cc:to:subject:message-id:date:from:in-reply-to:references
         :mime-version:from:to:cc:subject:date:message-id:reply-to;
        bh=nGLKbQzLbLmQUCcxhpFMjIurztQjMTtfRnt9dasddGU=;
        b=FEJaIInr3wCGhzZhgLqlmws+k3itr7xwVbq3bDCneWTBOOUp3oMjY4KV2rWQWI/+zN
         auahWihVDh+RgrA6xZ1S4YzA6ZxNpE4tRu8fZQpO6KzI6Z68Z4tNAtJ+RCiuq3ez9qzA
         Hrh9QnbgdgTjGgpjNdl7I5KBFMYm89Xygj7n/J6Cth7I2E8oks2x6jgo+YLpqdtWhrFt
         HfeGLZP8TL/bz+3wkPlJVb04egSZXQ6/gp4U7OtqczWHmpACgCRiHT2tQPmQELQmXha6
         nISdpMKqIz9+Ga/2e5KjPF5rbjgSGqfAe0D4a1M+em+PoYzNFDnbUezrIwouUKPeSwqK
         dP2g==
X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed;
        d=1e100.net; s=20230601; t=1772818758; x=1773423558;
        h=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=nGLKbQzLbLmQUCcxhpFMjIurztQjMTtfRnt9dasddGU=;
        b=ncbTd/MfgCAAtpp2ppFLgIV1NYEXUp3NnzRPeSHJw1eENWkx03+AevvVj6Vj2/E/Bz
         NHqkMo2HoHyjbzxICYmacLE+g2wC9sK6nJomTcoWSAAbhWuxTMW8cTv7adkIdhPS3o2Z
         eIBxXWgr4JIVKlLujm7iIETPXBTs2sOZkTk3G6GWrPDbrsgPtNRbh7ABX/fYtz4GA4ed
         fggQX2KRsue0G+Ev0iTPNvSpuRDnCCdhIRgxO0s9XE5AFc614GTUS2UjKr9cd6tpe9Pi
         /zoW/ynaO/Bj5P518XSzW4uX4l51sBzEKVy5VT1n2T5UkJaG7DjwTUjjr0cEyX13eLM7
         C/MQ==
X-Forwarded-Encrypted: i=1;
 AJvYcCXUtpWFb/0ywFhQ1OsS9vXGog6eiQ+MnsqCcC5jynEoU+Toggof0ahZ/q4+wMD1uYyeGB3lqEqqHgjIHlEj@postgresql.org
X-Gm-Message-State: AOJu0YysuoUelkuA/URr0o7k7mcmExU3V6faofU7JNilHO0xw8NL4v47
	6OIe3bVgxinkN8J9KLnHZ/uq21PGbhgfEDmkYniBkKpYInS9eHTjxvwTseBEkdC9YNQZ3idtmdC
	g45XBSYclSz7cs0mw/WVSqqpKRr91W0k=
X-Gm-Gg: ATEYQzxPoSqOaT37XkwFBOBLH3M3YYLVD5zN7Q0rhY6MjPiNsgEyoHlFXw9526EPko3
	4uDcjOvWb2o0lL/6Mp+L7ZYahwbOZmv/7dpN65yf2uNGmZDvkzuLoRUM5AEV1KocWA+xilSeVbW
	QOTnlISAI7su5tfBIRErvP99qT9dAhYw4LKg+HBp0NC/yfdydkiBBUy2cM5y5Z4oOVqdqb8FXtZ
	Igqza+fcyZkYXkt/Dl2LQXTZhyWFHXYmOUgrJeb6AxsXYSZlSeVnBOxq86y2v1XQDuRSjHwBZZz
	5axnuXs=
X-Received: by 2002:a05:7300:220f:b0:2ba:8706:d022 with SMTP id
 5a478bee46e88-2be4e03eb41mr1162603eec.18.1772818757942; Fri, 06 Mar 2026
 09:39:17 -0800 (PST)
MIME-Version: 1.0
References: 
 <CAN55FZ2RPMxquXE6TH7dQkhtoiBcOOOZq8EOXj5COHv3ecP_cw@mail.gmail.com>
 <CA+K2Ru=fFTUVgEDr-fBed5aOMeDbH9vrOEhapXzHEpBeOxkucg@mail.gmail.com>
 <CAKWEB6pq7C0Wv1wT9Y1_c_1fn-+cR8pb210Pj3w2FcEOmNGxbQ@mail.gmail.com>
 <CAN55FZ2DT4-k06umn=7NYG+NoM6gnVJVQCCwRrr2qOraO+Jadw@mail.gmail.com>
 <aZikzQP6WPJ5Rq2S@nathan>
 <CAN55FZ3cBN_TncLVWyXAKm-KfewguN1AUjyRhoR6zL_QCxHh7A@mail.gmail.com>
 <CAKWEB6qzsZEQ4Czo9QBFiMXqdXVJknHUJwg6wjRwNzLn4+Jw0g@mail.gmail.com>
 <CAN55FZ2O2Ls==sdpROHqxWRx-PMBZ0riJ6eVKoHj8=vssTavxw@mail.gmail.com>
 <aZ3kYQnF9_u6sUQp@nathan>
 <CAN55FZ3+NYF1TkKyNtpRQuLiaauSYk9G5tA+fpruOA4-14Y_ZA@mail.gmail.com>
 <aaXrGSyq4u2d9qEC@nathan>
 <CAN55FZ2DNaKCK3Kf_kHizb2pAbQvULeDYtzaiz97B_xz7YbrkQ@mail.gmail.com>
 <91acb778-42c4-44ef-8888-f18ad9b12a5b@dunslane.net>
 <CAKWEB6r0CrN-a2P=2ey3EK7p1MxsbQx2C8=hpNGfxLxnRaX66Q@mail.gmail.com>
In-Reply-To: 
 <CAKWEB6r0CrN-a2P=2ey3EK7p1MxsbQx2C8=hpNGfxLxnRaX66Q@mail.gmail.com>
From: Nazir Bilal Yavuz <byavuz81@gmail.com>
Date: Fri, 6 Mar 2026 20:39:04 +0300
X-Gm-Features: AaiRm53N35s63oAHGpilj9VwzlXQWpNmm1A2f_QPxcuFrS2nPQxK44ENAiflh9E
Message-ID: 
 <CAN55FZ1BYbdt97RLkd-vAVZ5EKiX=KLkhJ_S-4vgvNJRHvQZ6w@mail.gmail.com>
Subject: Re: Speed up COPY FROM text/CSV parsing using SIMD
To: Manni Wood <manni.wood@enterprisedb.com>
Cc: Andrew Dunstan <andrew@dunslane.net>,
 Nathan Bossart <nathandbossart@gmail.com>,
	KAZAR Ayoub <ma_kazar@esi.dz>, Neil Conway <neil.conway@gmail.com>,
	Shinya Kato <shinya11.kato@gmail.com>,
	PostgreSQL-development <pgsql-hackers@postgresql.org>
Content-Type: text/plain; charset="UTF-8"
List-Id: <pgsql-hackers.lists.postgresql.org>
List-Help: <https://lists.postgresql.org/manage/>
List-Subscribe: <https://lists.postgresql.org/manage/>
List-Post: <mailto:pgsql-hackers@lists.postgresql.org>
List-Owner: <mailto:pgsql-hackers-owner@lists.postgresql.org>
List-Archive: <https://www.postgresql.org/list/pgsql-hackers>
Archived-At: 
 <https://www.postgresql.org/message-id/CAN55FZ1BYbdt97RLkd-vAVZ5EKiX%3DKLkhJ_S-4vgvNJRHvQZ6w%40mail.gmail.com>
Precedence: bulk

Hi,

On Fri, 6 Mar 2026 at 20:00, Manni Wood <manni.wood@enterprisedb.com> wrote:
>
> Hello.
>
> I ran Nazir's v11 patch on my x86 tower PC and my arm raspberry pi using the same build I've been using: meson with "debugoptimized", which translates to "-g -O2" gcc flags.

Thanks for the benchmark! The results look nice.

One question: does your benchmark include the 34dfca2934 LZ4 commit,
and is LZ4 enabled on your system?

-- 
Regards,
Nazir Bilal Yavuz
Microsoft