Re: UUID v7

From: Sergey Prokhorenko <sergeyprokhorenko(at)yahoo(dot)com(dot)au>
To: Jelte Fennema-Nio <postgres(at)jeltef(dot)nl>, "Andrey M(dot) Borodin" <x4mmm(at)yandex-team(dot)ru>, Peter Eisentraut <peter(at)eisentraut(dot)org>
Cc: Aleksander Alekseev <aleksander(at)timescale(dot)com>, pgsql-hackers mailing list <pgsql-hackers(at)postgresql(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>
Subject: Re: UUID v7
Date: 2024-03-22 13:58:59
Message-ID: 252684972.194362.1711115939224@mail.yahoo.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

BTW: Each microservice should have its own database to ensure data isolation and independence, enabling better scalability and fault tolerance
Source: Microservices Pattern: Shared database

|
|
| |
Microservices Pattern: Shared database

|

|

|

Sergey Prokhorenko sergeyprokhorenko(at)yahoo(dot)com(dot)au

On Friday, 22 March 2024 at 04:42:20 pm GMT+3, Sergey Prokhorenko <sergeyprokhorenko(at)yahoo(dot)com(dot)au> wrote:

Why not use a single UUID generator for the database table in this case, similar to autoincrement?

Sergey Prokhorenko
sergeyprokhorenko(at)yahoo(dot)com(dot)au

On Friday, 22 March 2024 at 03:51:20 pm GMT+3, Peter Eisentraut <peter(at)eisentraut(dot)org> wrote:

On 21.03.24 16:21, Jelte Fennema-Nio wrote:
> On Wed, 20 Mar 2024 at 19:08, Andrey M. Borodin <x4mmm(at)yandex-team(dot)ru> wrote:
>> Timer-based bits contribute to global sortability. But the real timers we have are not even millisecond adjusted. We can hope for ~few ms variation in one datacenter or in presence of atomic clocks.
>
> I think the main benefit of using microseconds would not be
> sortability between servers, but sortability between backends.

There is that, and there are also multiple backend workers for one session.

In response to

  • Re: UUID v7 at 2024-03-22 13:42:20 from Sergey Prokhorenko

Responses

  • Re: UUID v7 at 2024-03-22 14:06:57 from Sergey Prokhorenko

Browse pgsql-hackers by date

  From Date Subject
Next Message Robert Haas 2024-03-22 13:59:47 Re: documentation structure
Previous Message Dagfinn Ilmari Mannsåker 2024-03-22 13:58:24 Re: Using the %m printf format more