UUID primary key remove hotspots; Sequence primary key increase locality. Depend... | Hacker News

Hacker Newsnew | past | comments | ask | show | jobs | submit

		j16sdiz on April 12, 2024 \| parent \| context \| favorite \| on: The UX of UUIDs UUID primary key remove hotspots; Sequence primary key increase locality. Depends on your access pattern, you may prefer the other way, even on the same DBMS.

hot_gril on April 12, 2024 [–]

Yes, but that decision has to be well-researched.

Guidelines | FAQ | Lists | API | Security | Legal | Apply to YC | Contact