UUIDv7 only promises uniqueness, and Python's version can run ahead of your clock (alexsci.com)
Alex Scott's post argues the three properties people credit to UUIDv7, monotonic order, a trustworthy creation time and unguessability, are not guaranteed by RFC 9562. Even Postgres warns that an extracted timestamp may differ from the creation time.
Commenters said that misses the real reason to use it: keeping new rows together in the index.
Sign in to save