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, <pe...@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. > >
