Re: UUID v7

From: Peter Eisentraut <peter(dot)eisentraut(at)enterprisedb(dot)com>
To: "Andrey M(dot) Borodin" <x4mmm(at)yandex-team(dot)ru>
Cc: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>, Daniel Gustafsson <daniel(at)yesql(dot)se>, Matthias van de Meent <boekewurm+postgres(at)gmail(dot)com>, Nikolay Samokhvalov <samokhvalov(at)gmail(dot)com>, "Kyzer Davis (kydavis)" <kydavis(at)cisco(dot)com>, Andres Freund <andres(at)anarazel(dot)de>, Andrey Borodin <amborodin86(at)gmail(dot)com>, PostgreSQL Hackers <pgsql-hackers(at)postgresql(dot)org>, "brad(at)peabody(dot)io" <brad(at)peabody(dot)io>, "wolakk(at)gmail(dot)com" <wolakk(at)gmail(dot)com>
Subject: Re: UUID v7
Date: 2023-07-10 16:50:38
Message-ID: 5dc6fdaa-5896-ebc4-7094-eac45a818846@enterprisedb.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

On 07.07.23 14:06, Andrey M. Borodin wrote:
> Also, I think we should discuss UUID v8. UUID version 8 provides an RFC-compatible format for experimental or vendor-specific use cases. Revision 1 of IETF draft contained interesting code for v8: almost similar to v7, but with fields for "node ID" and "rolling sequence number".
> I think this is reasonable approach, thus I attach implementation of UUID v8 per [0].

I suggest we keep this thread to v7, which has pretty straightforward
semantics for PostgreSQL. v8 by definition has many possible
implementations, so you're going to have to make pretty strong arguments
that yours is the best and only one, if you are going to claim the
gen_uuid_v8 function name.

In response to

  • Re: UUID v7 at 2023-07-07 12:06:19 from Andrey M. Borodin

Responses

  • Re: UUID v7 at 2023-07-30 10:08:41 from Andrey M. Borodin

Browse pgsql-hackers by date

  From Date Subject
Next Message Alvaro Herrera 2023-07-10 16:52:13 Re: cataloguing NOT NULL constraints
Previous Message Gurjeet Singh 2023-07-10 16:43:49 Re: BUG #18016: REINDEX TABLE failure