Re: Speed up COPY FROM text/CSV parsing using SIMD - Mailing list pgsql-hackers

From Manni Wood
Subject Re: Speed up COPY FROM text/CSV parsing using SIMD
Date
Msg-id CAKWEB6qPC3KkbAD1XD12jvBQ8fwoQRvKycaU30Eed8EAE0qkpQ@mail.gmail.com
Whole thread Raw
In response to Re: Speed up COPY FROM text/CSV parsing using SIMD  (Manni Wood <manni.wood@enterprisedb.com>)
Responses Re: Speed up COPY FROM text/CSV parsing using SIMD
List pgsql-hackers
I have a thought and a question:

My notes say "If I use `--buildtype=release` it optimizes `-O2` and the executable contains no debug symbols."

So, seeing as end users will presumably be seeing the performance generated by `--buildtype=release`, should we be building with that for all performance testing?

Best,
-Manni

On Thu, Feb 26, 2026 at 8:36 AM Manni Wood <manni.wood@enterprisedb.com> wrote:


On Thu, Feb 26, 2026 at 8:31 AM KAZAR Ayoub <ma_kazar@esi.dz> wrote:
Hello,

On Thu, Feb 26, 2026 at 1:19 PM 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=debugoptimized ...

-O3: meson setup buildtype=release ...
All my builds are with CFLAGS='-O2 -g'

Regards,
Ayoub

Hello!

I have been building with this command:

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

And in my notes I have "If I use `--buildtype=debugoptimized` it optimizes `-O2` and uses `-g`" 

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


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

pgsql-hackers by date:

Previous
From: Andres Freund
Date:
Subject: Re: pgstat include expansion
Next
From: KAZAR Ayoub
Date:
Subject: Re: Speed up COPY FROM text/CSV parsing using SIMD