Re:Features I'd Like in PostgreSQL
by ttfkam on Sunday January 29, 2023 @10:38AM
(#34569033)
Not that much slower than bigint as long as you replace the top one or two bytes in the UUID with a rotating per-minute counter.
You keep 106 bits of entropy (from v4's 122 bits) while largely eliminating page faults. Walkability is eliminated while not leaking too much temporal info.
You keep 106 bits of entropy (from v4's 122 bits) while largely eliminating page faults. Walkability is eliminated while not leaking too much temporal info.
https://www.2ndquadrant.com/en/blog/sequential-uuid-generato...