Laetitia Avrot shares some advice:
This month’s PGSQLPhriday event is about UUId thanks to my post calling for a
fightdebate on the topic.I will answer a question a friend developer asked me: “What is the best when we need a primary key? UUID, CUID, or TSID?”
I hadn’t heard of two of these, but Laetitia provides some links to learn more about them and then offers up some advice on whether to use any of them. And the advice sounds a lot like the advice for SQL Server.