Re: Has gen_random_uuid() gotten much slower in v17?

From: Peter Eisentraut <peter(at)eisentraut(dot)org>
To: David Mullineux <dmullx(at)gmail(dot)com>, pgsql-performance(at)lists(dot)postgresql(dot)org
Subject: Re: Has gen_random_uuid() gotten much slower in v17?
Date: 2024-09-11 09:40:16
Message-ID: 68398e13-35fd-410b-b279-c200e07ffcbd@eisentraut.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-performance

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.

In response to

Responses

Browse pgsql-performance by date

  From Date Subject
Next Message David Mullineux 2024-09-11 10:47:41 Re: Has gen_random_uuid() gotten much slower in v17?
Previous Message James Pang 2024-09-11 07:00:38 Re: many backends hang on MultiXactOffsetSLRU