Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.96) (envelope-from ) id 1vvdM1-00BCE8-2y for pgsql-hackers@arkaria.postgresql.org; Thu, 26 Feb 2026 15:32:42 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.96) (envelope-from ) id 1vvdM0-00Dg3e-2s for pgsql-hackers@arkaria.postgresql.org; Thu, 26 Feb 2026 15:32:40 +0000 Received: from makus.postgresql.org ([2001:4800:3e1:1::229]) by malur.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.96) (envelope-from ) id 1vvdM0-00Dg3C-1V for pgsql-hackers@lists.postgresql.org; Thu, 26 Feb 2026 15:32:40 +0000 Received: from mail-dy1-x1335.google.com ([2607:f8b0:4864:20::1335]) by makus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_128_GCM_SHA256 (Exim 4.98.2) (envelope-from ) id 1vvdLu-00000001JuJ-3yqZ for pgsql-hackers@postgresql.org; Thu, 26 Feb 2026 15:32:37 +0000 Received: by mail-dy1-x1335.google.com with SMTP id 5a478bee46e88-2bdcfbd0779so1134527eec.0 for ; Thu, 26 Feb 2026 07:32:35 -0800 (PST) ARC-Seal: i=1; a=rsa-sha256; t=1772119953; cv=none; d=google.com; s=arc-20240605; b=OIlKTpQcqSW8EWLAwMC76Eu44V/bi7+hOFhanB2pEC9UkacP6m3WnYVLn3abKCXMFF iL9a17V+C+kccUIzLU8mNkOvaIjSS45QdumiPGhzHCww43p3w2+yo5hHEgUNmD5CV3sf jVgXJwZkno9edc4RNaaNVGFxMATScVVeNAFn/qXUx/ehkOwJP9/dP21ZD8JfY2IGoNrd Q15v+3ZacwZkW9kW2ARIkSnYTEeTA1kISEQ/ZcgEIhEqApjzuPRwHSskyr61Ng5U23JP NJ6W+AKXkK05hWXCTPjotSO1s4xa0oL9DR89TRUvF9r1RwPYxj4IZ5XJtBmfKXbXcgIh L4FA== ARC-Message-Signature: i=1; a=rsa-sha256; c=relaxed/relaxed; d=google.com; s=arc-20240605; h=cc:to:subject:message-id:date:from:in-reply-to:references :mime-version:dkim-signature; bh=JV2Aa5HOCtr5qo6xGxmmMxzlSkxzJJ8gYZGsguvYE34=; fh=eAqN7PMHM7vez725PNLaYWHvVGyLIgTH/FaLlJtPfSw=; b=bnfan/Kt8iPf8EvhUYM/WEehHNqdGN91dndVH/WfxVP3QCRoWxV99BCb3tvf5d9ura LSYTTeIXU03L9hZluZT/GGTBghBAKtxJUld5ix6I0ykEGzxXrN1sSPNncUoAUrfPBMsu CT8SpCl1gIgcsYCKiggFtyJI1Lam8FXe+2dLrbaGb5t1CYfhTewrJF77b8a1/dA5b2x1 HEd2edZN9ZxIBewNdiB4e/dZvZY9KFJLO2yePqm8bCUOZuFpdYCc97uGsdS/7uDQRxWd 3GdwMwJk72IkHMW54uif7Uu2mxTN8bpRa+iRT3tpvognpbuGXK0iIHYwzFlGxcHNPLy3 whvg==; darn=postgresql.org ARC-Authentication-Results: i=1; mx.google.com; arc=none DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=enterprisedb.com; s=google; t=1772119953; x=1772724753; darn=postgresql.org; h=cc:to:subject:message-id:date:from:in-reply-to:references :mime-version:from:to:cc:subject:date:message-id:reply-to; bh=JV2Aa5HOCtr5qo6xGxmmMxzlSkxzJJ8gYZGsguvYE34=; b=GGQsNJmcn8xkVGaGwnDOZW9WC/DkegsyiVFjPDEqr4E56YsYSh+avZKaWPIGMBNyyU N+QeCe4UZCwTt1RcpQovfSWVl7o81gVoj80MUk6dhVdLtv0W8ih7ZuEjCp0gvbTpU+Af wtz5wkgG+80nFtu4SxSnnMETJRO9DrbIONt8ahKbJxV+inwaT7ISMHrC0WjqvgdwZUlw acIMSlp6FtebKA8+9simjW0A+AWnmxaeKgHTueRbMbKTq7F2svJI3F+Sli2oMeQwpKPa /iOOGwWqjd9pnHy9jJZ//j5jGYh9/OS+dDKhIaEGhSmUxq+pllREwPOCEJsj+5/Qrjb1 Dkqw== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20230601; t=1772119953; x=1772724753; h=cc:to:subject:message-id:date:from:in-reply-to:references :mime-version:x-gm-gg:x-gm-message-state:from:to:cc:subject:date :message-id:reply-to; bh=JV2Aa5HOCtr5qo6xGxmmMxzlSkxzJJ8gYZGsguvYE34=; b=jpCWeqUFp80w5WKGBxNdDY0LogrZx6r67R70/UdFkq8RHIR0doG6msHKKAszbyPKiT UECv1SZ/vfvNJ1fqSy7/6b2sEMqv2igb7yby4J07ng++KkMXdaq8HXHYemcYnIrRkeTL 6b9ShaRWpB3/z6vzrVVwyDOTfA9Fx93zr/qG1EPdUVDtLZrcvdZ+3LNsicrtiHXKrNgq Xg+dA8r7gM1WI7Cz9OOP9WVyMRHmUSuK6D+Y25+pzFJahPnHS/ETcQIhkC5R+R+GZXcq R1Rc5fVFfqQRffR2VAtwBXBGOIzkJajY22b617wB1Y4p1sTel8J0NJ7NhgdUIGsw2gGp u16g== X-Forwarded-Encrypted: i=1; AJvYcCW5xnXFZY77bSi7W2V2CzIWgbnRVPL46FIwSbSe5YamxEs6KVtWl5lk++3FQrP2wSYpuYVvD+gsQBZuOj/b@postgresql.org X-Gm-Message-State: AOJu0YyFgYyg4mHbxBIFGsovnbSlA6iwSrFNqY80wBNtyHy6D73GMzyv xnwvC7rlBtxzz0q+UNd+juENLFf2VUHLyM0wQFJbjz4PAk0FQHkGFz2DqZHmNP4MQwBzhvWnUr+ 3fmA8wLdNDDfK9xHWxCx5gyTfJ6u+NrqjjUqFoOF5 X-Gm-Gg: ATEYQzyyOETZuxteiTfke6mEMXZVlTYd1Thc03pCpLhydiHIyapECYKADWSRqgzZJUy 67bunsU7lZDdfCUVxQSATAxmlRvtSlRf0mYBJt9gNcxgASiKHRyh/n7DfYhAzRDMK0RxJcJ6auA AhgC0St5fu6qWNg8NPP/H7VJ1jCKJ1ndGqDfOot2X2H6p6Rmy2zUuouvBOh9rpWhLRshpu1nxQU 9KlwEivl6Ym1OI6eR64avPvkidlPVvFupwmBHlKyH5TKcPwG5aB+SotacbyntWYsWillJBWXNhA 2jYL1TOp X-Received: by 2002:a05:7300:d509:b0:2b8:64ad:ad4c with SMTP id 5a478bee46e88-2bdcc075eb0mr2106854eec.31.1772119953242; Thu, 26 Feb 2026 07:32:33 -0800 (PST) MIME-Version: 1.0 References: In-Reply-To: From: Manni Wood Date: Thu, 26 Feb 2026 09:32:21 -0600 X-Gm-Features: AaiRm51ltR-Si0uSJ9NUNJL3D7SywA9Ny1IO4eVXbbpmvAcP_DwZDzY3Qb94YvM Message-ID: Subject: Re: Speed up COPY FROM text/CSV parsing using SIMD To: KAZAR Ayoub Cc: Nazir Bilal Yavuz , Nathan Bossart , Neil Conway , Andrew Dunstan , Shinya Kato , PostgreSQL-development Content-Type: multipart/alternative; boundary="000000000000500ab2064bbbd48d" List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk --000000000000500ab2064bbbd48d Content-Type: text/plain; charset="UTF-8" Content-Transfer-Encoding: quoted-printable 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." 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? Best, -Manni On Thu, Feb 26, 2026 at 8:36=E2=80=AFAM Manni Wood wrote: > > > On Thu, Feb 26, 2026 at 8:31=E2=80=AFAM KAZAR Ayoub wro= te: > >> Hello, >> >> On Thu, Feb 26, 2026 at 1:19=E2=80=AFPM Nazir Bilal Yavuz >> wrote: >> >>> Hi, >>> >>> On Wed, 25 Feb 2026 at 17:24, Nazir Bilal Yavuz >>> 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 optimi= zes > `-O2` and uses `-g`" > > Best, > -Manni > -- > -- Manni Wood EDB: https://www.enterprisedb.com > --=20 -- Manni Wood EDB: https://www.enterprisedb.com --000000000000500ab2064bbbd48d Content-Type: text/html; charset="UTF-8" Content-Transfer-Encoding: quoted-printable
I have a thought and a question:

My not= es say "If I use `--buildtype=3Drelease` it optimizes `-O2` and the ex= ecutable contains no debug symbols."

So, seei= ng as end users will presumably be seeing the performance generated by `--b= uildtype=3Drelease`, should we be building with that for all performance te= sting?

Best,
-Manni

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


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

=
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!

<= /div>
I have been building with this command:

= 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

And in my notes I have "If I use `--bu= ildtype=3Ddebugoptimized` it optimizes `-O2` and uses `-g`"=C2=A0
<= /div>

Best,
-Manni
--
<= div dir=3D"ltr">-- Manni Wood EDB: https://www.enterprisedb.com


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