Hacker News new | ask | show | jobs
by xmdx 1091 days ago
That's what created_at and updated_at are for surely
2 comments

I was going to ask, when would you only rely on a sequential id for temporal locality, wouldn't most people be indexing and sorting on `created_at` or something equivalent?
You don’t need to need temporal elements, the simple fact that UUIDs are a bad fit for B-Trees means that simply inserting a bunch of data that relies on a UUIDv4 for its unique ID, will also run into these same problems.

You’d typically see this as either lower performance of a table than you expect, or higher IOPS usage of your database (which gets expensive at scale).

From the ActiveRecord fame ;-)