MIME-Version: 1.0
References: <aZ3kYQnF9_u6sUQp@nathan>
 <CAN55FZ3+NYF1TkKyNtpRQuLiaauSYk9G5tA+fpruOA4-14Y_ZA@mail.gmail.com>
 <aaXrGSyq4u2d9qEC@nathan>
 <CAN55FZ2DNaKCK3Kf_kHizb2pAbQvULeDYtzaiz97B_xz7YbrkQ@mail.gmail.com>
 <91acb778-42c4-44ef-8888-f18ad9b12a5b@dunslane.net>
 <CAKWEB6r0CrN-a2P=2ey3EK7p1MxsbQx2C8=hpNGfxLxnRaX66Q@mail.gmail.com>
 <CAN55FZ1BYbdt97RLkd-vAVZ5EKiX=KLkhJ_S-4vgvNJRHvQZ6w@mail.gmail.com>
 <CAKWEB6pmXvv3sbQBNLAR_B=8wzX8rn4VFsJ4WwmNbuJ2etSwDQ@mail.gmail.com>
 <CAN55FZ25HV0FNziFR8xBpQpHkNPS48w8yEXCc91W+=0c0jr+KA@mail.gmail.com>
 <CAKWEB6rnMKYGSt=t9=pL2kKUefsAdzKfjtwdqW_acv1+vMTKVA@mail.gmail.com>
 <aatfiTMLvLok2cUc@nathan>
In-Reply-To: <aatfiTMLvLok2cUc@nathan>
From: KAZAR Ayoub <ma_kazar@esi.dz>
Date: Sat, 7 Mar 2026 00:31:19 +0100
Message-ID: 
 <CA+K2RunT=1P7_E4jrZMogDiPunNCOGw9P_UHLaJRJk=5_odKmA@mail.gmail.com>
Subject: Re: Speed up COPY FROM text/CSV parsing using SIMD
To: Nathan Bossart <nathandbossart@gmail.com>
Cc: Manni Wood <manni.wood@enterprisedb.com>,
 Nazir Bilal Yavuz <byavuz81@gmail.com>,
	Andrew Dunstan <andrew@dunslane.net>, Neil Conway <neil.conway@gmail.com>,
	Shinya Kato <shinya11.kato@gmail.com>,
	PostgreSQL-development <pgsql-hackers@postgresql.org>
Content-Type: multipart/alternative; boundary="000000000000ea5853064c6373ad"
Archived-At: 
 <https://www.postgresql.org/message-id/CA%2BK2RunT%3D1P7_E4jrZMogDiPunNCOGw9P_UHLaJRJk%3D5_odKmA%40mail.gmail.com>
Precedence: bulk

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

Hi,

On Sat, Mar 7, 2026 at 12:13=E2=80=AFAM Nathan Bossart <nathandbossart@gmai=
l.com>
wrote:

> On Fri, Mar 06, 2026 at 03:25:46PM -0600, Manni Wood wrote:
> > Well, golly! Look at these numbers. Old master with no lz4, your v11
> patch
> > with no lz4, and then your v11 patch with lz4 compiled in.
>
> I'm appreciative of all the benchmarking that you and others are doing, b=
ut
> wouldn't we be more interested in the difference between "old master with
> lz4" and "v11 with lz4"?  Else, we have multiple variables in play.
>
Yes I agree because the lz4 effect doesn't prove anything for the SIMD
patch itself right ? So basically a comparison for the SIMD effect should
be "master with/out lz4 vs patched with/out lz4, respectively and nothing
more!", is this correct ?

Regards,
Ayoub

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

<div dir=3D"ltr"><div>Hi,</div><br><div class=3D"gmail_quote gmail_quote_co=
ntainer"><div dir=3D"ltr" class=3D"gmail_attr">On Sat, Mar 7, 2026 at 12:13=
=E2=80=AFAM Nathan Bossart &lt;<a href=3D"mailto:nathandbossart@gmail.com">=
nathandbossart@gmail.com</a>&gt; wrote:<br></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">On Fri, Mar 06, 2026 at 03:25:46PM -0600, Manni Woo=
d wrote:<br>
&gt; Well, golly! Look at these numbers. Old master with no lz4, your v11 p=
atch<br>
&gt; with no lz4, and then your v11 patch with lz4 compiled in.<br>
<br>
I&#39;m appreciative of all the benchmarking that you and others are doing,=
 but<br>
wouldn&#39;t we be more interested in the difference between &quot;old mast=
er with<br>
lz4&quot; and &quot;v11 with lz4&quot;?=C2=A0 Else, we have multiple variab=
les in play.<br></blockquote><div>Yes I agree because the lz4 effect doesn&=
#39;t prove anything for the SIMD patch itself right ? So basically a compa=
rison for the SIMD effect should be &quot;master with/out lz4 vs patched wi=
th/out lz4, respectively and nothing more!&quot;, is this correct ?=C2=A0<b=
r><br></div><div>Regards,<br></div><div>Ayoub</div></div></div>

--000000000000ea5853064c6373ad--