MIME-Version: 1.0
References: 
 <CAEudQApbWon+3Eb9x4WW_D-JkSt2mvfx99dXu9VZ4AeCuTh=fw@mail.gmail.com>
 <CAEudQApEfvhNT1fEPURzVcQH7G0A1ukh_ugoCGaErV6_dbndCQ@mail.gmail.com>
 <CAF+pBj_RS2KErTqQ6ORXjhVzmukG7Ve0wHU1Kq56xjJfFKwVqA@mail.gmail.com>
 <CAEudQAptRymgvmd5hQb2mk-Ft89XcSo_xvC74kv4JBA9v=D4Sg@mail.gmail.com>
 <CAF+pBj-K2bgNQRc9ih01WFmAWUaQtVbS37jLtYdYh5LOwOkF6A@mail.gmail.com>
 <CAF+pBj9M8rCoS-EEBwLiA6hdxm_UNjxMXG9Vc4RU8xifqnQB-g@mail.gmail.com>
 <CAEvyyTjLYVuy0V6gXE9_HgyB4gUftuTZm65gdbacE_OOKk1cqw@mail.gmail.com>
In-Reply-To: 
 <CAEvyyTjLYVuy0V6gXE9_HgyB4gUftuTZm65gdbacE_OOKk1cqw@mail.gmail.com>
From: Ranier Vilela <ranier.vf@gmail.com>
Date: Fri, 20 Mar 2026 07:58:11 -0300
Message-ID: 
 <CAEudQAoF2xfpA7tgW3gusg0dyMTwTDDwAzBqR_bbv08NBkqv-A@mail.gmail.com>
Subject: Re: Avoid multiple calls to memcpy (src/backend/access/index/genam.c)
To: lakshmi <lakshmigcdac@gmail.com>
Cc: Bryan Green <dbryan.green@gmail.com>,
 Pg Hackers <pgsql-hackers@postgresql.org>
Content-Type: multipart/alternative; boundary="00000000000044244b064d729046"
Archived-At: 
 <https://www.postgresql.org/message-id/CAEudQAoF2xfpA7tgW3gusg0dyMTwTDDwAzBqR_bbv08NBkqv-A%40mail.gmail.com>
Precedence: bulk

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

Hi.

Em sex., 20 de mar. de 2026 =C3=A0s 06:50, lakshmi <lakshmigcdac@gmail.com>
escreveu:

> Hi,
>
> I tried this change on PostgreSQL (19devel) and ran a few simple tests
> using pgbench to see how it behaves in practice.
>
> I used 10 clients and 4 threads and ran each test for 60 seconds.
>
> From my runs, the original version was giving around ~663 TPS with ~15.07
> ms latency.
> With the patched version, I observed TPS in the range of ~638=E2=80=93657=
,
> averaging around ~648 TPS, with latency slightly higher (~15.2=E2=80=9315=
.6 ms).
>
Thanks for the benchmark.
Could you share the tests and the environment?
compiler
OS
etc.

best regards,
Ranier Vilela

--00000000000044244b064d729046
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">Em sex., 20 de mar. de 2026 =
=C3=A0s 06:50, lakshmi &lt;<a href=3D"mailto:lakshmigcdac@gmail.com">lakshm=
igcdac@gmail.com</a>&gt; escreveu:<br></div><blockquote class=3D"gmail_quot=
e" style=3D"margin:0px 0px 0px 0.8ex;border-left:1px solid rgb(204,204,204)=
;padding-left:1ex"><div dir=3D"ltr">Hi,<br><br>I tried this change on Postg=
reSQL (19devel) and ran a few simple tests using pgbench to see how it beha=
ves in practice.<br><br>I used 10 clients and 4 threads and ran each test f=
or 60 seconds.<br><br>From my runs, the original version was giving around =
~663 TPS with ~15.07 ms latency.<br>With the patched version, I observed TP=
S in the range of ~638=E2=80=93657, averaging around ~648 TPS, with latency=
 slightly higher (~15.2=E2=80=9315.6 ms).<br></div></blockquote><div>Thanks=
 for the benchmark.</div><div>Could you share the tests and the environment=
?</div><div>compiler</div><div>OS</div><div>etc.</div><div><br></div><div>b=
est regards,</div><div>Ranier Vilela</div></div></div>

--00000000000044244b064d729046--