| From: | "Andrey M(dot) Borodin" <x4mmm(at)yandex-team(dot)ru> |
|---|---|
| To: | Jelte Fennema-Nio <postgres(at)jeltef(dot)nl> |
| Cc: | 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>, Sergey Prokhorenko <sergeyprokhorenko(at)yahoo(dot)com(dot)au>, 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-05-04 06:09:04 |
| Message-ID: | E964723F-754E-49C3-AA4C-61C6B3836029@yandex-team.ru |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-hackers |
> On 3 May 2024, at 11:18, Andrey M. Borodin <x4mmm(at)yandex-team(dot)ru> wrote:
>
Here's the documentation from ClickHouse [0] for their implementation. It's identical to provided patch in this thread, with few notable exceptions:
1. Counter is 42 bits, not 18. The counter have no guard bits, every bit is initialized with random number on time ticks.
2. By default counter is shared between threads. Alternative function generateUUIDv7ThreadMonotonic() provides thread-local counter.
Thanks!
Best regards, Andrey Borodin.
[0] https://clickhouse.com/docs/en/sql-reference/functions/uuid-functions#generateUUIDv7
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Daniel Gustafsson | 2024-05-04 08:08:48 | Re: Cutting support for OpenSSL 1.0.1 and 1.0.2 in 17~? |
| Previous Message | David G. Johnston | 2024-05-04 02:22:18 | Re: Proposal for CREATE OR REPLACE EVENT TRIGGER in PostgreSQL |