[j16sdiz]

UUID primary key remove hotspots; Sequence primary key increase locality.

Depends on your access pattern, you may prefer the other way, even on the same DBMS.

[hot_gril]

Yes, but that decision has to be well-researched.