Re:Rails 4 UUID primary keys with PostgreSQL
by jacques_chester on Saturday April 27, 2013 @02:00PM
(#5618495)
To be clear, MAC-based UUIDs are sequential. PRNG (v4) UUIDs are random and don't work well with indexes.
The cost? The keys are larger, and (unless using a sequential algorithm) are poor candidates for clustered keys (because they force page splits). The impact can be rather large (this lead to terrible performance in early versions of Sharepoint).