Re: What is a typical precision of gettimeofday()?

[Andrey M. Borodin]

> On 3 Jul 2024, at 16:29, Hannu Krosing <han...@google.com> wrote:
> 
> We currently do something similar with OIDs where we just keep
> generating them and then testing for conflicts.
> 
> I don't think this is the best way to do it but it mostly works when
> you can actually test for uniqueness, like for example in TOAST or
> system tables.
> 
> Not sure this works even reasonably well for UUIDv7.

Uniqueness is ensured with extra 60+ bits of randomness. Timestamp and 
counter\microseconds are there to promote sortability (thus ensuring data 
locality).


Best regards, Andrey Borodin.