Re: Отв.: Re: UUID v7 - Mailing list pgsql-hackers

From Masahiko Sawada
Subject Re: Отв.: Re: UUID v7
Date
Msg-id CAD21AoArOpZy1j0Ac2x8_-NZs2fvko3p46=tA+z=O1EnFDpdXw@mail.gmail.com
Whole thread Raw
In response to Отв.: Re: UUID v7  (Sergey Prokhorenko <sergeyprokhorenko@yahoo.com.au>)
Responses Re: Отв.: Re: UUID v7
List pgsql-hackers
On Thu, Nov 28, 2024 at 8:13 PM Sergey Prokhorenko
<sergeyprokhorenko@yahoo.com.au> wrote:
>
> I mean to add not benchmark results to the patch, but functions so that everyone can compare themselves on their
equipment.The comparison with UUIDv4 is not very interesting, as the choice is usually between UUIDv7 and an integer
key.And I have described many use cases, and in your benchmark there is only one, the simplest. 

I don't think we should add such benchmark functions at least to this
patch. If there already is a well-established workload using UUIDv7
and UUIDv4 etc, users can use pgbench with custom scripts, or it might
make sense to add it to pgbench as a built-in workload. Which however
should be a separate patch. Having said that, I think users should use
benchmarks that fit their workloads, and it would not be easy to
establish workloads that are reasonable for most systems.

Regards,

--
Masahiko Sawada
Amazon Web Services: https://aws.amazon.com



pgsql-hackers by date:

Previous
From: Amit Kapila
Date:
Subject: Re: crash with synchronized_standby_slots
Next
From: Kirill Reshke
Date:
Subject: Re: relfilenode statistics