The major tradeoffs between using UUIDs and sequential integers as primary keys fall into two categories:
- Usability tradeoffs, and
- Performance tradeoffs
And I'll say up front: I believe UUIDs are rarely a good idea, both for the reasons I've listed here, and the fact that I've almost never seen them used in the wild.