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-05 18:56:33
Message-ID: 9650BAC7-AE36-4814-AD17-B6B775B7AAF9@yandex-team.ru
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

> On 2 Nov 2024, at 02:23, Masahiko Sawada <sawada(dot)mshk(at)gmail(dot)com> wrote:
>
> Most of the timing durations were nanoseconds and fell into either 0
> ns. Others fell into >1023 bins.

Indeed. We cannot have these 2 bits from nanoseconds :(
I've tried to come up with some clever tricks, but have not succeeded.
Let's use only microseconds.

Best regards, Andrey Borodin.

Attachment Content-Type Size
v30-0001-Implement-UUID-v7.patch application/octet-stream 16.0 KB

In response to

  • Re: UUID v7 at 2024-11-01 21:23:30 from Masahiko Sawada

Responses

  • Re: UUID v7 at 2024-11-06 18:14:29 from Andrey M. Borodin

Browse pgsql-hackers by date

  From Date Subject
Next Message Maiquel Grassi 2024-11-05 18:59:48 RE: Rename Function: pg_postmaster_start_time
Previous Message Robert Haas 2024-11-05 18:45:03 Re: Proposals for EXPLAIN: rename ANALYZE to EXECUTE and extend VERBOSE