Request a Demo
Home   >   mailing lists

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

From KAZAR Ayoub
Subject Re: Speed up COPY FROM text/CSV parsing using SIMD
Date
Msg-id CA+K2Ru=UvNyzvHoJWo_DZHfdyTny-kaYkxPZTgzHpewMdDTRGg@mail.gmail.com
Whole thread
In response to Re: Speed up COPY FROM text/CSV parsing using SIMD  (Manni Wood <manni.wood@enterprisedb.com>)
List pgsql-hackers
Tree view
On Thu, Feb 26, 2026 at 4:32 PM Manni Wood <manni.wood@enterprisedb.com> wrote:
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."
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=release`, should we be building with that for all performance testing?
I know that Debian builds with  'CFLAGS=-g -O2 -flto=auto -ffat-lto-objects -flto=auto -ffat-lto-objects -fstack-protector-strong -Wformat -Werror=format-security -fno-omit-frame-pointer' 'LDFLAGS=-Wl,-Bsymbolic-functions -flto=auto -ffat-lto-objects -flto=auto -Wl,-z,relro -Wl,-z,now' ; this is from pg_config for v18.

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

Regards,
Ayoub

pgsql-hackers by date:

Previous
From: Manni Wood
Date:
Subject: Re: Speed up COPY FROM text/CSV parsing using SIMD
Next
From: "David G. Johnston"
Date:
Subject: Re: doc: Clarify that empty COMMENT string removes the comment