Re: UUID v7

From: "Andrey M(dot) Borodin" <x4mmm(at)yandex-team(dot)ru>
To: Masahiko Sawada <sawada(dot)mshk(at)gmail(dot)com>
Cc: Sergey Prokhorenko <sergeyprokhorenko(at)yahoo(dot)com(dot)au>, Jelte Fennema-Nio <postgres(at)jeltef(dot)nl>, Michael Paquier <michael(at)paquier(dot)xyz>, Aleksander Alekseev <aleksander(at)timescale(dot)com>, pgsql-hackers mailing list <pgsql-hackers(at)postgresql(dot)org>, Peter Eisentraut <peter(at)eisentraut(dot)org>, 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>, Stepan Neretin <sncfmgg(at)gmail(dot)com>
Subject: Re: UUID v7
Date: 2024-11-21 21:22:10
Message-ID: 668541A1-715A-495D-8934-5F9EE74254CD@yandex-team.ru
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

> On 21 Nov 2024, at 02:24, Masahiko Sawada <sawada(dot)mshk(at)gmail(dot)com> wrote:
>
> But does replacing the least significant 2 bits
> with random 2 bits really not affect monotonicity?

You are right. We have to take into account this when calculating monotonicity. PFA another version.

Best regards, Andrey Borodin.

Attachment Content-Type Size
v35-0002-Mix-in-2-bits-of-entropy-into-timestampt-of-UUID.patch application/octet-stream 1.8 KB

In response to

  • Re: UUID v7 at 2024-11-20 23:24:30 from Masahiko Sawada

Responses

  • Re: UUID v7 at 2024-11-22 22:37:25 from Masahiko Sawada

Browse pgsql-hackers by date

  From Date Subject
Next Message yuansong 2024-11-21 21:26:53 Re:Re: backup server core when redo btree_xlog_insert that type is XLOG_BTREE_INSERT_POST
Previous Message Andrey M. Borodin 2024-11-21 20:52:52 Re: Forbid to DROP temp tables of other sessions