| From: | Aleksander Alekseev <aleksander(at)timescale(dot)com> |
|---|---|
| To: | pgsql-hackers <pgsql-hackers(at)postgresql(dot)org> |
| Cc: | Hannu Krosing <hannuk(at)google(dot)com>, "Andrey M(dot) Borodin" <x4mmm(at)yandex-team(dot)ru>, Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>, Peter Eisentraut <peter(at)eisentraut(dot)org> |
| Subject: | Re: What is a typical precision of gettimeofday()? |
| Date: | 2024-07-03 11:47:26 |
| Message-ID: | CAJ7c6TNNvPwbRsfnAAEfgeoKkAT8t1k2xyqHYOuLOQhemFZqsw@mail.gmail.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | 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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Dilip Kumar | 2024-07-03 11:52:55 | Re: Conflict Detection and Resolution |
| Previous Message | Andrey M. Borodin | 2024-07-03 11:46:30 | Re: What is a typical precision of gettimeofday()? |