I'm thinking to use UUID as PK for all tables into my new PostgreSQL database, for such a goal I will be using
uuid_ns_url functions, but I have some doubts:
- is there any problems using UUIDs only in a database (i.e. performance)?
- is there any pros and cons respect to use
- When to use
uuid_ns_url? (I haven't found info about it)
uuid_generate_v5function be any string (even an empty string) or it depends on
namespaceparameter? Examples, please.