Request a Demo
Home   >   mailing lists

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 CAKWEB6ro0ZXC7WUnLkTh9MdmPh4fBobX0=tHAdTbjU=eTdRZFw@mail.gmail.com
Whole thread
In response to Re: Speed up COPY FROM text/CSV parsing using SIMD  (KAZAR Ayoub <ma_kazar@esi.dz>)
Responses Re: Speed up COPY FROM text/CSV parsing using SIMD
List pgsql-hackers
Tree view


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

pgsql-hackers by date:

Previous
From: KAZAR Ayoub
Date:
Subject: Re: Speed up COPY FROM text/CSV parsing using SIMD
Next
From: Jim Jones
Date:
Subject: Re: doc: Clarify that empty COMMENT string removes the comment