MIME-Version: 1.0
References: 
 <CAGsyd8XBE7Ksq2Z75CTStrjSswOjVUE8S+i7qq1hGvYRj+_bcA@mail.gmail.com>
 <68398e13-35fd-410b-b279-c200e07ffcbd@eisentraut.org>
In-Reply-To: <68398e13-35fd-410b-b279-c200e07ffcbd@eisentraut.org>
From: David Mullineux <dmullx@gmail.com>
Date: Wed, 11 Sep 2024 11:47:41 +0100
Message-ID: 
 <CAGsyd8VBW+zwYuLEiJ3JC5NCFveumUiwhJQoS_-zvhnyfARcbQ@mail.gmail.com>
Subject: Re: Has gen_random_uuid() gotten much slower in v17?
To: Peter Eisentraut <peter@eisentraut.org>
Cc: pgsql-performance@lists.postgresql.org
Content-Type: multipart/alternative; boundary="000000000000dc9b1c0621d5b8b3"
Archived-At: 
 <https://www.postgresql.org/message-id/CAGsyd8VBW%2BzwYuLEiJ3JC5NCFveumUiwhJQoS_-zvhnyfARcbQ%40mail.gmail.com>
Precedence: bulk

--000000000000dc9b1c0621d5b8b3
Content-Type: text/plain; charset="UTF-8"

Good idea. Thanks.    I did check. It's not enabled by default but just in
case I did another build. This time explicitly defining --disable-debug and
--disable-cassert. And I tested. Still slower than old versions.

This feels like a build configuration problem. Just can't put my finger on
it yet.

On Wed, 11 Sept 2024, 10:40 Peter Eisentraut, <peter@eisentraut.org> wrote:

> On 10.09.24 15:58, David Mullineux wrote:
> > I'm getting a bit concerned by the slow performance of generating uidds
> > on latest dev code versus older versions. Here I compare the time to
> > generate 50k random uuids. Both son the same machine.
> > I must be missing something.
>
> Are you sure that the 18devel installation isn't compiled with
> assertions enabled?
>
> The underlying code for gen_random_uuid() is virtually unchanged between
> PG14 and current.
>
>

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

<div dir=3D"auto">Good idea. Thanks.=C2=A0 =C2=A0 I did check. It&#39;s not=
 enabled by default but just in case I did another build. This time explici=
tly defining --disable-debug and --disable-cassert. And I tested. Still slo=
wer than old versions.=C2=A0<div dir=3D"auto"><br></div><div dir=3D"auto">T=
his feels like a build configuration problem. Just can&#39;t put my finger =
on it yet.</div></div><br><div class=3D"gmail_quote"><div dir=3D"ltr" class=
=3D"gmail_attr">On Wed, 11 Sept 2024, 10:40 Peter Eisentraut, &lt;<a href=
=3D"mailto:peter@eisentraut.org">peter@eisentraut.org</a>&gt; wrote:<br></d=
iv><blockquote class=3D"gmail_quote" style=3D"margin:0 0 0 .8ex;border-left=
:1px #ccc solid;padding-left:1ex">On 10.09.24 15:58, David Mullineux wrote:=
<br>
&gt; I&#39;m getting a bit concerned by the slow performance of generating =
uidds <br>
&gt; on latest dev code versus older versions. Here I compare the time to <=
br>
&gt; generate 50k random uuids. Both son the same machine.<br>
&gt; I must be missing something.<br>
<br>
Are you sure that the 18devel installation isn&#39;t compiled with <br>
assertions enabled?<br>
<br>
The underlying code for gen_random_uuid() is virtually unchanged between <b=
r>
PG14 and current.<br>
<br>
</blockquote></div>

--000000000000dc9b1c0621d5b8b3--