-
Type: New Feature
-
Status: Open
-
Priority: Minor
-
Resolution: Unresolved
-
Affects Version/s: None
-
Component/s: Core
-
Tags:
-
Story Points:3
Instead of using java.util.UUID that conforms to UUIDv4 and provides random unique identifier, we could use the new time based UUIDv7.
The fact that identifier are ordered plays a big role in optimizing underlying indexes at scale.
Also, it can be useful for debugging purpose as we can get a timestamp from such UUID.
See:
https://buildkite.com/blog/goodbye-integers-hello-uuids
https://blog.devgenius.io/analyzing-new-unique-identifier-formats-uuidv6-uuidv7-and-uuidv8-d6cc5cd7391a
https://www.cybertec-postgresql.com/en/unexpected-downsides-of-uuid-keys-in-postgresql/