Re: What is a typical precision of gettimeofday()? - Mailing list pgsql-hackers

From Aleksander Alekseev
Subject Re: What is a typical precision of gettimeofday()?
Date
Msg-id CAJ7c6TNNvPwbRsfnAAEfgeoKkAT8t1k2xyqHYOuLOQhemFZqsw@mail.gmail.com
Whole thread Raw
In response to Re: What is a typical precision of gettimeofday()?  (Hannu Krosing <hannuk@google.com>)
List pgsql-hackers
Hi,

> 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.

UUIDv7 is not guaranteed to be unique. It just does it best to reduce
the number of possible conflicts. So I don't think we should worry
about it.


-- 
Best regards,
Aleksander Alekseev



pgsql-hackers by date:

Previous
From: "Andrey M. Borodin"
Date:
Subject: Re: What is a typical precision of gettimeofday()?
Next
From: Dilip Kumar
Date:
Subject: Re: Conflict Detection and Resolution