githubEdit

UUID version 7 vs UUID version 4

For us the more interesting one is UUID v7 - which produces time-sorted values. It means that each time new UUID v7 is generated, a greater value it has. And that makes it a good fit for B-Tree index.

Read more

  1. https://maciejwalkowiak.com/blog/postgres-uuid-primary-key/

  2. https://commitfest.postgresql.org/47/4388/

  3. https://www.ietf.org/archive/id/draft-peabody-dispatch-new-uuid-format-04.html#name-uuid-version-7

Last updated