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>
 <CAN55FZ1BYbdt97RLkd-vAVZ5EKiX=KLkhJ_S-4vgvNJRHvQZ6w@mail.gmail.com>
In-Reply-To: 
 <CAN55FZ1BYbdt97RLkd-vAVZ5EKiX=KLkhJ_S-4vgvNJRHvQZ6w@mail.gmail.com>
From: Manni Wood <manni.wood@enterprisedb.com>
Date: Fri, 6 Mar 2026 12:13:33 -0600
Message-ID: 
 <CAKWEB6pmXvv3sbQBNLAR_B=8wzX8rn4VFsJ4WwmNbuJ2etSwDQ@mail.gmail.com>
Subject: Re: Speed up COPY FROM text/CSV parsing using SIMD
To: Nazir Bilal Yavuz <byavuz81@gmail.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: multipart/alternative; boundary="00000000000082647f064c5f0326"
Archived-At: 
 <https://www.postgresql.org/message-id/CAKWEB6pmXvv3sbQBNLAR_B%3D8wzX8rn4VFsJ4WwmNbuJ2etSwDQ%40mail.gmail.com>
Precedence: bulk

--00000000000082647f064c5f0326
Content-Type: text/plain; charset="UTF-8"
Content-Transfer-Encoding: quoted-printable

On Fri, Mar 6, 2026 at 11:39=E2=80=AFAM Nazir Bilal Yavuz <byavuz81@gmail.c=
om>
wrote:

> 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 usin=
g
> 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
>

Hello, Nazir!

When I ran `meson setup build --buildtype=3Ddebugoptimized` on both my x86
machine and my arm machine, the response on both was:

"External libraries
"  lz4                      : NO"

However, I did not remove commit 34dfca2934 from any of my Postgres builds;
I left that commit in place.

Let me know if that helps!

And I agree, the results look nice.

Best,

-Manni
--=20
-- Manni Wood EDB: https://www.enterprisedb.com

--00000000000082647f064c5f0326
Content-Type: text/html; charset="UTF-8"
Content-Transfer-Encoding: quoted-printable

<div dir=3D"ltr"><div dir=3D"ltr"><br></div><br><div class=3D"gmail_quote g=
mail_quote_container"><div dir=3D"ltr" class=3D"gmail_attr">On Fri, Mar 6, =
2026 at 11:39=E2=80=AFAM Nazir Bilal Yavuz &lt;<a href=3D"mailto:byavuz81@g=
mail.com">byavuz81@gmail.com</a>&gt; wrote:<br></div><blockquote class=3D"g=
mail_quote" style=3D"margin:0px 0px 0px 0.8ex;border-left:1px solid rgb(204=
,204,204);padding-left:1ex">Hi,<br>
<br>
On Fri, 6 Mar 2026 at 20:00, Manni Wood &lt;<a href=3D"mailto:manni.wood@en=
terprisedb.com" target=3D"_blank">manni.wood@enterprisedb.com</a>&gt; wrote=
:<br>
&gt;<br>
&gt; Hello.<br>
&gt;<br>
&gt; I ran Nazir&#39;s v11 patch on my x86 tower PC and my arm raspberry pi=
 using the same build I&#39;ve been using: meson with &quot;debugoptimized&=
quot;, which translates to &quot;-g -O2&quot; gcc flags.<br>
<br>
Thanks for the benchmark! The results look nice.<br>
<br>
One question: does your benchmark include the 34dfca2934 LZ4 commit,<br>
and is LZ4 enabled on your system?<br>
<br>
-- <br>
Regards,<br>
Nazir Bilal Yavuz<br>
Microsoft<br>
</blockquote></div><div><br clear=3D"all"></div><div>Hello, Nazir!<div><br>=
</div><div>When I ran `meson setup build --buildtype=3Ddebugoptimized` on b=
oth my x86 machine and my arm machine, the response on both was:</div><div>=
<br></div><div>&quot;External libraries</div><div>&quot;=C2=A0=C2=A0lz4 =C2=
=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0: =
NO&quot;</div></div><div><br></div><div>However, I did not remove commit=C2=
=A034dfca2934 from any of my Postgres builds; I left that commit in place.<=
/div><div><br></div><div>Let me know if that helps!</div><div><br></div><di=
v>And I agree, the results look nice.</div><div><br></div><div>Best,</div><=
div><br></div><div>-Manni</div><span class=3D"gmail_signature_prefix">-- </=
span><br><div dir=3D"ltr" class=3D"gmail_signature"><div dir=3D"ltr"><span =
style=3D"color:rgb(29,28,29);font-family:Monaco,Menlo,Consolas,&quot;Courie=
r New&quot;,monospace;font-size:12px;background-color:rgba(29,28,29,0.04)">=
--
Manni Wood
EDB: </span><a href=3D"https://www.enterprisedb.com/" rel=3D"noopener noref=
errer" style=3D"font-family:Monaco,Menlo,Consolas,&quot;Courier New&quot;,m=
onospace;font-size:12px;background-color:rgba(29,28,29,0.04)" target=3D"_bl=
ank">https://www.enterprisedb.com</a></div></div></div>

--00000000000082647f064c5f0326--