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

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 





On Wed, 20 Nov 2024, 22:26 Tom Lane, <tgl@xxxxxxxxxxxxx> wrote:
[ please don't top-quote, it makes the conversation hard to follow ]

David Mullineux <dmullx@xxxxxxxxx> writes:
> On Wed, 20 Nov 2024, 15:46 Tom Lane, <tgl@xxxxxxxxxxxxx> wrote:
>> Yeah.  Also, are you building with openssl, or not?

> No, not at all!

If you're not using openssl, then gen_random_uuid basically devolves
to a read of /dev/urandom.  Maybe you're using a different kernel
than before, and it has different properties around that?

                        regards, tom lane

Just to say, thanks Tom. You were dead right. From the code in 
pg_strong_random.c
it looks like each call will do an open("/dev/urandom")

And that cannot be fast.

Not sure why,but I guess there are good reasons to not keep a file descriptor to that device open across calls ?

Thanks anyway


[Postgresql General]     [Postgresql PHP]     [PHP Users]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Books]     [PHP Databases]     [Yosemite]

  Powered by Linux