MIME-Version: 1.0
References: <CAN55FZ0J5iz9wFJLHcK7yNQqPb10_4ROoZiDu1wBZWSGC_fATg@mail.gmail.com>
 <CAKWEB6qY=mU62oAQFAVPCFWvwRuTPKBwxvM2aZ+J7p_9_MBmhQ@mail.gmail.com>
 <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>
 <CAN55FZ1inW-w-oqDwU32bLpC05XWQMY=SEMOtim74BNRekSjHQ@mail.gmail.com>
In-Reply-To: <CAN55FZ1inW-w-oqDwU32bLpC05XWQMY=SEMOtim74BNRekSjHQ@mail.gmail.com>
From: KAZAR Ayoub <ma_kazar@esi.dz>
Date: Thu, 26 Feb 2026 15:31:30 +0100
Message-ID: <CA+K2RumuFAk7tCqeXjTNLDsQ8ZKX3MMQTraaB1ttM8E_Aq3dLg@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="000000000000cf30de064bbafa7a"
Archived-At: <https://www.postgresql.org/message-id/CA%2BK2RumuFAk7tCqeXjTNLDsQ8ZKX3MMQTraaB1ttM8E_Aq3dLg%40mail.gmail.com>
Precedence: bulk

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

Hello,

On Thu, Feb 26, 2026 at 1:19=E2=80=AFPM Nazir Bilal Yavuz <byavuz81@gmail.c=
om>
wrote:

> Hi,
>
> On Wed, 25 Feb 2026 at 17:24, Nazir Bilal Yavuz <byavuz81@gmail.com>
> wrote:
> >
> > I agree with you. However, unfortunately, I see regression on master +
> > v10 compared to REL_18_3 (62d6c7d3df6).
> >
> > Thank you Kazar and Manni for benchmarks in [1] and [2]!
>
> Kazar and Manni, if possible could you please share the build commands
> you use? I see regressions for an inlining patch (dc592a4155) too when
> I build postgres with -O2.
>
> My build commands are:
>
> -O2: meson setup buildtype=3Ddebugoptimized ...
>
> -O3: meson setup buildtype=3Drelease ...

All my builds are with CFLAGS=3D'-O2 -g'

Regards,
Ayoub

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

<div dir=3D"ltr"><div>Hello,</div><div><br></div><div dir=3D"ltr">On Thu, F=
eb 26, 2026 at 1:19=E2=80=AFPM Nazir Bilal Yavuz &lt;<a href=3D"mailto:byav=
uz81@gmail.com">byavuz81@gmail.com</a>&gt; wrote:<br></div><div class=3D"gm=
ail_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-le=
ft:1ex">Hi,<br>
<br>
On Wed, 25 Feb 2026 at 17:24, Nazir Bilal Yavuz &lt;<a href=3D"mailto:byavu=
z81@gmail.com" target=3D"_blank">byavuz81@gmail.com</a>&gt; wrote:<br>
&gt;<br>
&gt; I agree with you. However, unfortunately, I see regression on master +=
<br>
&gt; v10 compared to REL_18_3 (62d6c7d3df6).<br>
&gt;<br>
&gt; Thank you Kazar and Manni for benchmarks in [1] and [2]!<br>
<br>
Kazar and Manni, if possible could you please share the build commands<br>
you use? I see regressions for an inlining patch (dc592a4155) too when<br>
I build postgres with -O2.<br>
<br>
My build commands are:<br>
<br>
-O2: meson setup buildtype=3Ddebugoptimized ...<br>
<br>-O3: meson setup buildtype=3Drelease ...</blockquote><div>All my builds=
 are with CFLAGS=3D&#39;-O2 -g&#39;</div><div><br></div><div>Regards,</div>=
<div>Ayoub</div></div></div>

--000000000000cf30de064bbafa7a--