Menu

#Uuidv7

4 posts

Feed·
4 of 4 posts
UUIDv4 Is Not Free: Why Random Primary Keys Are Silently Crushing Your Write Performance
📰
0Read More

UUIDv4 Is Not Free: Why Random Primary Keys Are Silently Crushing Your Write Performance

DEV Community: postgres·𝗝𝗼𝗵𝗻·6 days ago
#w6vJLSMc
#devtopostgresql#devto#dev#uuidv7#uuidv4

Discover how random UUIDv4 primary keys destroy B-Tree index locality, cause severe page fragmentation, and how switching to UUIDv7 fixes database write throughput.

15s
UUIDv7 Is a Great Database Key and a Bad Clock: 4 Tests Before You Migrate
🖼️
0Read More

UUIDv7 Is a Great Database Key and a Bad Clock: 4 Tests Before You Migrate

DEV Community: postgres·Kiell Tampubolon·24 days ago
#CnIFQQYb
#devtopostgresql#devto#dev#time#uuidv7

UUIDv7 primary keys help database indexes, but the embedded timestamp is not a reliable clock. Four tests to run before migrating your PostgreSQL IDs.

15s
Stop using UUID v4 for database primary keys — UUIDv7 is the 2026 default
🖼️
0Read More

Stop using UUID v4 for database primary keys — UUIDv7 is the 2026 default

DEV Community·engr anees·6 months ago
#aIzYQJS4
#javascript#but#webdev#database#uuid

Your B-tree indexes hate UUID v4. They've hated it for years. You probably haven't noticed because...

15s