Hacker News @h4ckernews@mastodon.social · activity timestamp 2 weeks ago Avoid UUIDv4 Primary Keyshttps://andyatkinson.com/avoid-uuid-version-4-primary-keys #HackerNews #AvoidUUIDv4 #PrimaryKeys #DatabaseDesign #BestPractices #TechAdvice Read more Read less Translate Software Engineer, Author, High Performance PostgreSQL for Rails Avoid UUID Version 4 Primary Keys (for Postgres) Introduction Over the last decade, when working on databases with UUID Version 41 as the primary key data type, these databases have usually had bad performance and excessive IO. https://datatracker.ietf.org/doc/html/rfc4122#section-4.4 ↩ Reply Boost Quote You cannot quote this post Like More actions Copy link Flag this post Block
