UUIDv7 Comes to PostgreSQL 18
a year ago
- #UUIDv7
- #PostgreSQL
- #Database
- PostgreSQL 18 beta 1 is released with new features like UUIDv7, async I/O, and virtual generated columns.
- UUIDv7 is a timestamp-based UUID variant that improves sorting and index locality in databases.
- UUIDs are useful for distributed databases, unguessable public identifiers, and client-generated IDs.
- UUIDv7 addresses concerns with sorting and index locality but not the size of UUIDs.
- PostgreSQL 18 introduces the `uuidv7()` function to generate UUIDv7 values and supports timestamp extraction.
- The community is encouraged to test PostgreSQL 18 beta and report issues before the official release in September.