Re: UUID v7 - Mailing list pgsql-hackers

From Andrey Borodin
Subject Re: UUID v7
Date
Msg-id 51252CFC-9FBB-45EA-97DC-FE1402D4447F@yandex-team.ru
Whole thread Raw
In response to Re: UUID v7  (Marcos Pegoraro <marcos@f10.com.br>)
Responses Re: UUID v7
List pgsql-hackers

> On 24 Jan 2024, at 22:00, Marcos Pegoraro <marcos@f10.com.br> wrote:
>
> Is enough from 1970 ?
Per standard unix_ts_ms field is a number of milliseconds from UNIX start date 1970-01-01.

> How about if user wants to have an UUID of his birth date ?

I've claimed my
0078c135-bd00-70b1-865a-63c3741922a5

But again, UUIDs are not designed to store timestamp. They are unique and v7 promote data locality via time-ordering.


Best regards, Andrey Borodin.


pgsql-hackers by date:

Previous
From: Tomas Vondra
Date:
Subject: Re: logical decoding and replication of sequences, take 2
Next
From: "Tristan Partin"
Date:
Subject: Re: make dist using git archive