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

From Andrey M. Borodin
Subject Re: What is a typical precision of gettimeofday()?
Date
Msg-id F9F051F4-FED4-4391-AF2A-40663A7D85A0@yandex-team.ru
Whole thread Raw
In response to Re: What is a typical precision of gettimeofday()?  (Aleksander Alekseev <aleksander@timescale.com>)
Responses Re: What is a typical precision of gettimeofday()?
List pgsql-hackers

> On 3 Jul 2024, at 13:48, Aleksander Alekseev <aleksander@timescale.com> wrote:
>
> Hi,
>
>> That’s a very interesting result, from the UUID POV!
>> If time is almost always advancing, using time readings instead of a counter is very reasonable: we have
interprocessmonotonicity almost for free. 
>> Though time is advancing in a very small steps… RFC assumes that we use microseconds, I’m not sure it’s ok to use 10
morebits for nanoseconds… 
>
> A counter is mandatory since someone can for instance change the
> system's time while the process is generating UUIDs. You can't
> generally assume that local time of the system is monotonic.

AFAIR according to RFC when time jumps backwards, we just use time microseconds as a counter. Until time starts to
advanceagain. 


Best regards, Andrey Borodin.


pgsql-hackers by date:

Previous
From: Dilip Kumar
Date:
Subject: Re: Conflict Detection and Resolution
Next
From: shveta malik
Date:
Subject: Re: Conflict Detection and Resolution