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.