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> <CA+K2RumuFAk7tCqeXjTNLDsQ8ZKX3MMQTraaB1ttM8E_Aq3dLg@mail.gmail.com>
In-Reply-To: <CA+K2RumuFAk7tCqeXjTNLDsQ8ZKX3MMQTraaB1ttM8E_Aq3dLg@mail.gmail.com>
From: Manni Wood <manni.wood@enterprisedb.com>
Date: Thu, 26 Feb 2026 08:36:09 -0600
Message-ID: <CAKWEB6ro0ZXC7WUnLkTh9MdmPh4fBobX0=tHAdTbjU=eTdRZFw@mail.gmail.com>
Subject: Re: Speed up COPY FROM text/CSV parsing using SIMD
To: KAZAR Ayoub <ma_kazar@esi.dz>
Cc: Nazir Bilal Yavuz <byavuz81@gmail.com>, Nathan Bossart <nathandbossart@gmail.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="0000000000006277c8064bbb0b0a"
Archived-At: <https://www.postgresql.org/message-id/CAKWEB6ro0ZXC7WUnLkTh9MdmPh4fBobX0%3DtHAdTbjU%3DeTdRZFw%40mail.gmail.com>
Precedence: bulk

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

On Thu, Feb 26, 2026 at 8:31=E2=80=AFAM KAZAR Ayoub <ma_kazar@esi.dz> wrote=
:

> Hello,
>
> On Thu, Feb 26, 2026 at 1:19=E2=80=AFPM Nazir Bilal Yavuz <byavuz81@gmail=
.com>
> 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
>

Hello!

I have been building with this command:

meson setup build --prefix=3D/home/mwood/compiled-pg-instances/${BRANCH}
--buildtype=3Ddebugoptimized

And in my notes I have "If I use `--buildtype=3Ddebugoptimized` it optimize=
s
`-O2` and uses `-g`"

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

--0000000000006277c8064bbb0b0a
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 Thu, Feb 26,=
 2026 at 8:31=E2=80=AFAM KAZAR Ayoub &lt;<a href=3D"mailto:ma_kazar@esi.dz"=
>ma_kazar@esi.dz</a>&gt; wrote:<br></div><blockquote class=3D"gmail_quote" =
style=3D"margin:0px 0px 0px 0.8ex;border-left:1px solid rgb(204,204,204);pa=
dding-left:1ex"><div dir=3D"ltr"><div>Hello,</div><div><br></div><div dir=
=3D"ltr">On Thu, Feb 26, 2026 at 1:19=E2=80=AFPM Nazir Bilal Yavuz &lt;<a h=
ref=3D"mailto:byavuz81@gmail.com" target=3D"_blank">byavuz81@gmail.com</a>&=
gt; wrote:<br></div><div class=3D"gmail_quote"><blockquote class=3D"gmail_q=
uote" style=3D"margin:0px 0px 0px 0.8ex;border-left:1px solid rgb(204,204,2=
04);padding-left: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>
</blockquote></div><div><br clear=3D"all"></div><div>Hello!</div><div><br><=
/div><div>I have been building with this command:</div><div><br></div><div>=
meson setup build --prefix=3D/home/mwood/compiled-pg-instances/${BRANCH} --=
buildtype=3Ddebugoptimized=C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0=
=C2=A0</div><div><br></div><div>And in my notes I have &quot;If I use `--bu=
ildtype=3Ddebugoptimized` it optimizes `-O2` and uses `-g`&quot;=C2=A0<br><=
/div><div><br></div><div>Best,</div><div>-Manni</div><span class=3D"gmail_s=
ignature_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;Courier 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>

--0000000000006277c8064bbb0b0a--