What is the difference between the following two functions
Are they both the same behind the scenes? Any performance impacts on using one?
Database Administrators Stack Exchange is a question and answer site for database professionals who wish to improve their database skills and learn from others in the community. It only takes a minute to sign up.Sign up to join this community
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)
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.