MIME-Version: 1.0
References: <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>
 <aa8QlTVEDhG1JU0Z@nathan>
 <CAN55FZ08kqmA+B9pzPDy-QstxAd=cK-RqjbR3cWBjPF_8-FXAw@mail.gmail.com>
 <abBQbdFa6OsG8TGu@nathan>
 <CAN55FZ3jXs7XDsP_-v_jUBquRu4uAdheN3xcmW=WhAyKwFLSjg@mail.gmail.com>
 <CA+K2RuneEqoCDNMmoboDw-JU8byL0yCrppXsyPR_9mqSw5GE=Q@mail.gmail.com>
 <CAN55FZ3Umf=cu9Vs9Joyrmz90eAqf1hS2QUNch9AZTjz3oY=3Q@mail.gmail.com>
In-Reply-To: 
 <CAN55FZ3Umf=cu9Vs9Joyrmz90eAqf1hS2QUNch9AZTjz3oY=3Q@mail.gmail.com>
From: KAZAR Ayoub <ma_kazar@esi.dz>
Date: Wed, 11 Mar 2026 14:23:41 +0100
Message-ID: 
 <CA+K2Runoi3YFbcM6HDOUkzJhJ1DytUT8FjJcQFLgDvhFu8aFSQ@mail.gmail.com>
Subject: Re: Speed up COPY FROM text/CSV parsing using SIMD
To: Nazir Bilal Yavuz <byavuz81@gmail.com>
Cc: Nathan Bossart <nathandbossart@gmail.com>,
 Manni Wood <manni.wood@enterprisedb.com>,
	Neil Conway <neil.conway@gmail.com>, Andrew Dunstan <andrew@dunslane.net>,
	Shinya Kato <shinya11.kato@gmail.com>,
	PostgreSQL-development <pgsql-hackers@postgresql.org>
Content-Type: multipart/alternative; boundary="000000000000032844064cbf8cea"
Archived-At: 
 <https://www.postgresql.org/message-id/CA%2BK2Runoi3YFbcM6HDOUkzJhJ1DytUT8FjJcQFLgDvhFu8aFSQ%40mail.gmail.com>
Precedence: bulk

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

On Wed, Mar 11, 2026 at 2:10=E2=80=AFPM Nazir Bilal Yavuz <byavuz81@gmail.c=
om>
wrote:

> Hi,
>
> On Wed, 11 Mar 2026 at 15:19, KAZAR Ayoub <ma_kazar@esi.dz> wrote:
> >
> > On Wed, Mar 11, 2026, 12:36 PM Nazir Bilal Yavuz <byavuz81@gmail.com>
> wrote:
> >>
> >> 0002 has an attempt to remove some branches from SIMD code but since
> >> it is kind of functional change, I wanted to attach that as another
> >> patch. I think we can apply some parts of this, if not all.
> >
> > 0002 sounds really good to have, haven't measured the diff but it's ver=
y
> logical.
>
> I agree with you. I saw very small speedups like 1%-2% but I think
> changes make sense regardless of the performance improvement.


>
> > Another quick question though, do we need USE_NO_SIMD for any reason? I
> just remembered that there's some simd paths like json that don't use it.
>
> vector8_eq() and vector8_highbit_mask() don't have non-SIMD
> implementations, so we need to use USE_NO_SIMD.
>
Aha ! that's true, thanks.

Regards,
Ayoub

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

<div dir=3D"ltr"><div dir=3D"ltr">On Wed, Mar 11, 2026 at 2:10=E2=80=AFPM N=
azir Bilal Yavuz &lt;<a href=3D"mailto:byavuz81@gmail.com">byavuz81@gmail.c=
om</a>&gt; wrote:<br></div><div class=3D"gmail_quote gmail_quote_container"=
><blockquote class=3D"gmail_quote" style=3D"margin:0px 0px 0px 0.8ex;border=
-left:1px solid rgb(204,204,204);padding-left:1ex">Hi,<br>
<br>
On Wed, 11 Mar 2026 at 15:19, KAZAR Ayoub &lt;<a href=3D"mailto:ma_kazar@es=
i.dz" target=3D"_blank">ma_kazar@esi.dz</a>&gt; wrote:<br>
&gt;<br>
&gt; On Wed, Mar 11, 2026, 12:36 PM Nazir Bilal Yavuz &lt;<a href=3D"mailto=
:byavuz81@gmail.com" target=3D"_blank">byavuz81@gmail.com</a>&gt; wrote:<br=
>
&gt;&gt;<br>
&gt;&gt; 0002 has an attempt to remove some branches from SIMD code but sin=
ce<br>
&gt;&gt; it is kind of functional change, I wanted to attach that as anothe=
r<br>
&gt;&gt; patch. I think we can apply some parts of this, if not all.<br>
&gt;<br>
&gt; 0002 sounds really good to have, haven&#39;t measured the diff but it&=
#39;s very logical.<br>
<br>
I agree with you. I saw very small speedups like 1%-2% but I think<br>
changes make sense regardless of the performance improvement.=C2=A0</blockq=
uote><blockquote class=3D"gmail_quote" style=3D"margin:0px 0px 0px 0.8ex;bo=
rder-left:1px solid rgb(204,204,204);padding-left:1ex">
<br>
<br>
&gt; Another quick question though, do we need USE_NO_SIMD for any reason? =
I just remembered that there&#39;s some simd paths like json that don&#39;t=
 use it.<br>
<br>
vector8_eq() and vector8_highbit_mask() don&#39;t have non-SIMD<br>
implementations, so we need to use USE_NO_SIMD.<br></blockquote><div>Aha ! =
that&#39;s true, thanks.</div><div><br></div><div>Regards,</div><div>Ayoub<=
/div></div></div>

--000000000000032844064cbf8cea--