On Thu, Nov 28, 2024 at 8:13 PM Sergey Prokhorenko <sergeyprokhore...@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
