Re: UUID v7 - Mailing list pgsql-hackers

From Peter Eisentraut
Subject Re: UUID v7
Date
Msg-id 08ccb447-cce8-491c-a9d4-7f9ac07c0330@eisentraut.org
Whole thread Raw
In response to UUID v7  (Andrey Borodin <amborodin86@gmail.com>)
Responses Re: UUID v7
List pgsql-hackers
On 21.03.24 16:21, Jelte Fennema-Nio wrote:
> On Wed, 20 Mar 2024 at 19:08, Andrey M. Borodin <x4mmm@yandex-team.ru> wrote:
>> Timer-based bits contribute to global sortability. But the real timers we have are not even millisecond adjusted. We
canhope for ~few ms variation in one datacenter or in presence of atomic clocks.
 
> 
> I think the main benefit of using microseconds would not be
> sortability between servers, but sortability between backends.

There is that, and there are also multiple backend workers for one session.




pgsql-hackers by date:

Previous
From: Robert Haas
Date:
Subject: Re: documentation structure
Next
From: Daniel Gustafsson
Date:
Subject: Re: sslinfo extension - add notbefore and notafter timestamps