Re: UUID v7

From: Peter Eisentraut <peter(at)eisentraut(dot)org>
To: "Andrey M(dot) Borodin" <x4mmm(at)yandex-team(dot)ru>, Aleksander Alekseev <aleksander(at)timescale(dot)com>
Cc: pgsql-hackers mailing list <pgsql-hackers(at)postgresql(dot)org>, Sergey Prokhorenko <sergeyprokhorenko(at)yahoo(dot)com(dot)au>, Jelte Fennema-Nio <postgres(at)jeltef(dot)nl>, Przemysław Sztoch <przemyslaw(at)sztoch(dot)pl>, "David G(dot) Johnston" <david(dot)g(dot)johnston(at)gmail(dot)com>, Mat Arye <mat(at)timescaledb(dot)com>, Matthias van de Meent <boekewurm+postgres(at)gmail(dot)com>, Nikolay Samokhvalov <samokhvalov(at)gmail(dot)com>, Junwang Zhao <zhjwpku(at)gmail(dot)com>
Subject: Re: UUID v7
Date: 2024-03-19 08:55:51
Views: Raw Message | Whole Thread | Download mbox | Resend email
Lists: pgsql-hackers

On 16.03.24 18:43, Andrey M. Borodin wrote:
>> On 15 Mar 2024, at 14:47, Aleksander Alekseev <aleksander(at)timescale(dot)com> wrote:
>> +1 to the idea. I doubt that anyone will miss it.
> PFA v22.
> Changes:
> 1. Squashed all editorialisation by Jelte
> 2. Fixed my erroneous comments on using Method 2 (we are using method 1 instead)
> 3. Remove all traces of uuid_extract_variant()

I have committed a subset of this for now, namely the additions of
uuid_extract_timestamp() and uuid_extract_version(). These seemed
mature and agreed upon. You can rebase the rest of your patch on top of

I have started a separate discussion to learn about the precision we can
expect from gettimeofday().

In response to

  • Re: UUID v7 at 2024-03-16 17:43:54 from Andrey M. Borodin


  • Re: UUID v7 at 2024-03-20 18:08:09 from Andrey M. Borodin

Browse pgsql-hackers by date

  From Date Subject
Next Message Fabrice Chapuis 2024-03-19 08:58:20 hot updates and fillfactor
Previous Message Peter Eisentraut 2024-03-19 08:28:37 What is a typical precision of gettimeofday()?