Hacker News new | ask | show | jobs
by sk5t 2524 days ago
> GUIDs are so much better it's not even a contest

GUIDs require more storage, and are likely (definitely with v4 GUID) to lead to index fragmentation. Postgres requires an extension to do most useful things with GUIDs whereas SERIAL is ready to go. I'm very pro-GUID yet don't universally prefer them in databases.