Re: UUID v7

x4mmm@yandex-team.ru

From: "Andrey M. Borodin" <x4mmm@yandex-team.ru>

To: Masahiko Sawada <sawada.mshk@gmail.com>

Cc: Sergey Prokhorenko <sergeyprokhorenko@yahoo.com.au>, Jelte Fennema-Nio <postgres@jeltef.nl>, Michael Paquier <michael@paquier.xyz>, Aleksander Alekseev <aleksander@timescale.com>, pgsql-hackers mailing list <pgsql-hackers@postgresql.org>, Peter Eisentraut <peter@eisentraut.org>, Przemysław Sztoch <przemyslaw@sztoch.pl>, "David G. Johnston" <david.g.johnston@gmail.com>, Mat Arye <mat@timescaledb.com>, Matthias van de Meent <boekewurm+postgres@gmail.com>, Nikolay Samokhvalov <samokhvalov@gmail.com>, Junwang Zhao <zhjwpku@gmail.com>, Stepan Neretin <sncfmgg@gmail.com>

Date: 2024-11-21T21:22:10Z

Lists: pgsql-hackers

Attachments

v35-0002-Mix-in-2-bits-of-entropy-into-timestampt-of-UUID.patch (application/octet-stream) patch v35-0002

> On 21 Nov 2024, at 02:24, Masahiko Sawada <sawada.mshk@gmail.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.

Commits

Fix timestamp overflow in UUIDv7 implementation.
- a5419bc72e22 18.0 landed
Add UUID version 7 generation function.
- 78c5e141e9c1 18.0 landed
Add some UUID support functions
- 794f10f6b920 17.0 landed