Uploaded image for project: 'Nuxeo Platform'
  1. Nuxeo Platform
  2. NXP-32096

Add an option to use time based UUIDv7 instead of UUIDv4

    XMLWordPrintable

    Details

    • Type: New Feature
    • Status: Open
    • Priority: Minor
    • Resolution: Unresolved
    • Affects Version/s: None
    • Fix Version/s: 2021.x, 2023.x
    • Component/s: Core

      Description

      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/

        Attachments

          Activity

            People

            • Assignee:
              Unassigned
              Reporter:
              bdelbosc Benoit Delbosc
              Participants:
            • Votes:
              0 Vote for this issue
              Watchers:
              1 Start watching this issue

              Dates

              • Created:
                Updated: