What is the difference between the following two functions

Are they both the same behind the scenes? Any performance impacts on using one?


Are they the same?


The Postgres documetation for uuid-ossp suggests using gen_random_uuid() If you only need randomly-generated (version 4) UUIDs,

The uuid-ossp extension also provides other types of UUID (such as mac-addresses based)

The difference?

I looked at the source and discovered that

  • uuid_generate_v4() uses arc4random to determine the random part.

  • gen_random_uuid() uses fortuna instead.

Other than that they do the same job.


Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy