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>
 <CAKWEB6ro0ZXC7WUnLkTh9MdmPh4fBobX0=tHAdTbjU=eTdRZFw@mail.gmail.com> <CAKWEB6qPC3KkbAD1XD12jvBQ8fwoQRvKycaU30Eed8EAE0qkpQ@mail.gmail.com>
In-Reply-To: <CAKWEB6qPC3KkbAD1XD12jvBQ8fwoQRvKycaU30Eed8EAE0qkpQ@mail.gmail.com>
From: KAZAR Ayoub <ma_kazar@esi.dz>
Date: Thu, 26 Feb 2026 16:51:33 +0100
Message-ID: <CA+K2Ru=UvNyzvHoJWo_DZHfdyTny-kaYkxPZTgzHpewMdDTRGg@mail.gmail.com>
Subject: Re: Speed up COPY FROM text/CSV parsing using SIMD
To: Manni Wood <manni.wood@enterprisedb.com>
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="000000000000f86bf1064bbc182a"
Archived-At: <https://www.postgresql.org/message-id/CA%2BK2Ru%3DUvNyzvHoJWo_DZHfdyTny-kaYkxPZTgzHpewMdDTRGg%40mail.gmail.com>
Precedence: bulk

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

On Thu, Feb 26, 2026 at 4:32=E2=80=AFPM Manni Wood <manni.wood@enterprisedb=
.com>
wrote:

> I have a thought and a question:
>
> My notes say "If I use `--buildtype=3Drelease` it optimizes `-O2` and the
> executable contains no debug symbols."
>
That would be `debugoptimized` not `release`, from [1] i see that `release`
is -O3 with no debug.

>
> So, seeing as end users will presumably be seeing the performance
> generated by `--buildtype=3Drelease`, should we be building with that for=
 all
> performance testing?
>
I know that Debian builds with  'CFLAGS=3D-g -O2 -flto=3Dauto -ffat-lto-obj=
ects
-flto=3Dauto -ffat-lto-objects -fstack-protector-strong -Wformat
-Werror=3Dformat-security -fno-omit-frame-pointer'
'LDFLAGS=3D-Wl,-Bsymbolic-functions -flto=3Dauto -ffat-lto-objects -flto=3D=
auto
-Wl,-z,relro -Wl,-z,now' ; this is from pg_config for v18.

[1] https://mesonbuild.com/Builtin-options.html

Regards,
Ayoub

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

<div dir=3D"ltr"><div dir=3D"ltr">On Thu, Feb 26, 2026 at 4:32=E2=80=AFPM M=
anni Wood &lt;<a href=3D"mailto:manni.wood@enterprisedb.com">manni.wood@ent=
erprisedb.com</a>&gt; wrote:</div><div class=3D"gmail_quote gmail_quote_con=
tainer"><blockquote class=3D"gmail_quote" style=3D"margin:0px 0px 0px 0.8ex=
;border-left:1px solid rgb(204,204,204);padding-left:1ex"><div dir=3D"ltr">=
I have a thought and a question:<div><br></div><div>My notes say &quot;If I=
 use `--buildtype=3Drelease` it optimizes `-O2` and the executable contains=
 no debug symbols.&quot;</div></div></blockquote><div>That would be `debugo=
ptimized` not `release`, from [1] i see that `release` is -O3 with no debug=
.</div><blockquote class=3D"gmail_quote" style=3D"margin:0px 0px 0px 0.8ex;=
border-left:1px solid rgb(204,204,204);padding-left:1ex"><div dir=3D"ltr"><=
div><br></div><div>So, seeing as end users will presumably be seeing the pe=
rformance generated by `--buildtype=3Drelease`, should we be building with =
that for all performance testing?</div></div></blockquote><div>I know that =
Debian builds with=C2=A0=C2=A0&#39;CFLAGS=3D-g -O2 -flto=3Dauto -ffat-lto-o=
bjects -flto=3Dauto -ffat-lto-objects -fstack-protector-strong -Wformat -We=
rror=3Dformat-security -fno-omit-frame-pointer&#39; &#39;LDFLAGS=3D-Wl,-Bsy=
mbolic-functions -flto=3Dauto -ffat-lto-objects -flto=3Dauto -Wl,-z,relro -=
Wl,-z,now&#39; ; this is from pg_config for v18.<br><br>[1] <a href=3D"http=
s://mesonbuild.com/Builtin-options.html">https://mesonbuild.com/Builtin-opt=
ions.html</a></div><div><br></div><div>Regards,<br></div><div>Ayoub</div></=
div></div>

--000000000000f86bf1064bbc182a--