Re:Mistakes Beginners Make When Working with Databases
by nieksand on Wednesday June 08, 2016 @11:55AM
(#11863092)
Actually, uuid4 as a pkey will cause pathological insertion performance on a b-tree since you are randomly inserting across the tree (having to constantly split pages) rather than appending to a far extent.
If you want to use uuids, uuid1 may be a better bet.
If you want to use uuids, uuid1 may be a better bet.