Re: UUID v7

Sergey,

I took a look at your patch for chapter 9.14 "UUID Functions" docs page.
You've added some really good content here. I think section 9.14.4.
"Deciding Whether and Which UUID to Use" would be better suited for Chapter
8: "Data Types" -- specifically, 8.12. "UUID Type", since the content seems
to deal more with the UUID data type than the UUID functions.

Best regards,
Andy A.

On Sun, Feb 16, 2025 at 8:13 PM Sergey Prokhorenko <
sergeyprokhorenko(at)yahoo(dot)com(dot)au> wrote:

> On Wednesday 5 February 2025 at 01:07:02 am GMT+3, Masahiko Sawada <
> sawada(dot)mshk(at)gmail(dot)com> wrote:
>
>
> On Sun, Feb 2, 2025 at 11:41 AM Sergey Prokhorenko
> <sergeyprokhorenko(at)yahoo(dot)com(dot)au> wrote:
> >
> > Dear colleagues,
> >
> > I would like to present for discussion my attached new draft
> documentation on UUID functions (Section 9.14. UUID Functions), which
> replaces the previously proposed draft at
> https://www.postgresql.org/docs/devel/functions-uuid.html. I have
> preserved and significantly supplemented the text that was there.
> >
> > I have the following goals:
> >
> > 1. State that from now on, the function uuidv7(), rather than
> autoincrement, is the default choice for generating primary keys
> >
> > 2. Describe the advantages of uuidv7() over autoincrement and uuidv4()
> >
> > 3. Refute the often-cited imaginary disadvantages of UUIDv7 compared to
> autoincrement, such as:
> >
> > - Lower performance (see the refutation in the article "UUID
> Benchmark War" https://ardentperf.com/2024/02/03/uuid-benchmark-war/)
> >
> > - Disclosure of date and time of record creation in the table (in
> reality, the timestamp offset parameter distorts this information)
> >
> > 4. Confirm the fault tolerance of the uuidv7() function in all possible
> critical situations, namely:
> >
> > - System clock failure
> >
> > - Receiving an invalid value of the offset argument, which would
> result in a timestamp overflow or a negative timestamp
> >
>
> Thank you for the proposal. Could you share the proposed document as a
> .diff or .patch file? That would be easier to review the updates.
>
>
> Regards,
>
>
> --
> Masahiko Sawada
> Amazon Web Services: https://aws.amazon.com
>
> _________________________________________________________
>
> Dear colleagues,
>
> I have attached a file changed.diff containing my proposed changes to the
> documentation on UUID functions (Section 9.14. UUID Functions). The text
> of the changes in this file is updated, and it is slightly different from
> the previously submitted text.
>
>
> Regards,
>
> Sergey Prokhorenko
> sergeyprokhorenko(at)yahoo(dot)com(dot)au
>
>
>
>
>