←back to thread

Postgres UUIDv7 and per-back end monotonicity

(brandur.org)
230 points craigkerstiens | 1 comments | 02 Jan 25 16:32 UTC | HN request time: 0.2s | source
Show context
urronglol ◴[02 Jan 25 16:49 UTC] No.42576069[source]▶
What is a v7 UUID. Why do we need more than 1. uuid from a random seed and 2. one derived from that and a timestamp (orderable)
replies(6): >>42576084 #>>42576085 #>>42576155 #>>42576193 #>>42576274 #>>42576349 #
1. mind-blight ◴[02 Jan 25 16:59 UTC] No.42576155[source]▶
A deterministic uuid based off of a hash of bits is also very useful (UUID5). I've used that for deduping records from multiple sources