News for hackers. Stuff that matters.
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.

There are no comments on this comment yet.