logoalt Hacker News

piterrroyesterday at 5:44 PM1 replyview on HN

For anyone interested in the topic I suggest reading about snowflake id [https://en.wikipedia.org/wiki/Snowflake_ID] or uuid7 the patterns from the article translate cleanly. The bigint is 64 bytes where uuid is 128. There are other caveats but its all about tradeoffs.


Replies

khurstoday at 6:30 AM

Technically - as Postgresql stores the UUID data type as binary, it's 16 bytes.

show 1 reply