libuuid performance impact - Mailing list pgsql-pkg-debian

From Marc Cousin
Subject libuuid performance impact
Date
Msg-id 4f125945-e979-1f9e-a39b-a4bf5a4eca6b@gmail.com
Whole thread Raw
Responses Re: libuuid performance impact  (Christoph Berg <myon@debian.org>)
List pgsql-pkg-debian
Hi

I've been investigating a performance "problem" with uuid generation
https://jasonaowen.net/blog/2017/Apr/13/benchmarking-uuids-v2/, which I
couldn't reproduce on my computer while it occurred on my servers. After
a few tests, it seems to come from uuid-ossp being replaced with
libuuid… when linking postgresql with uuid-ossp I get the exact same
performance between uuid_generate_v4 and gen_random_uuid. When linking
with libuuid, I get the same results as those displayed in the linked
webpage (I can provide numbers).

Is this an expected difference ?


Please tell me what I can provide if required.

Regards

Marc


Attachment

pgsql-pkg-debian by date:

Previous
From: apt.postgresql.org repository
Date:
Subject: pspg updated to version 1.1.0-1.pgdg+1
Next
From: Christoph Berg
Date:
Subject: Re: libuuid performance impact