Get the latest tech news
UUIDv7 Comes to PostgreSQL 18
PostgreSQL 18 adds native support for UUIDv7. A timestamp-based UUID variant that plays nicely with btree indexes. Here's what that means for you.
Async I/O (with io_uring) — 2-3x speedups on seq scans, vacuums Skip scan on multi-column btree indexes + smarter OR/IN optimizations Keep planner stats during major upgrades UUIDv7 functions Virtual generated columns OAuth login + md5 deprecation warning EXPLAIN ANALYZE now shows I/O, CPU, WAL Temporal constraints, LIKE on nondeterministic collation, casefolding New wire protocol version: 3.2 (first since 2003!) Unguessable public identifiers: Properly generated, UUIDs can't be guessed, predicted or used to infer information about the system. The standard also provides the option to include millisecond timestamp in the UUID and/or carefully seeded counter, to support ordering within a single second (if needed).
Or read this on Hacker News