libuuid performance impact

From: Marc Cousin <cousinmarc(at)gmail(dot)com>
To: pgsql-pkg-debian(at)postgresql(dot)org
Subject: libuuid performance impact
Date: 2018-04-30 15:32:17
Message-ID: 4f125945-e979-1f9e-a39b-a4bf5a4eca6b@gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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

Responses

Browse pgsql-pkg-debian by date

  From Date Subject
Next Message Christoph Berg 2018-05-01 14:24:55 Re: libuuid performance impact
Previous Message apt.postgresql.org repository 2018-04-30 07:39:49 pspg updated to version 1.1.0-1.pgdg+1