Re: Sequence vs UUID

Поиск
Список
Период
Сортировка
От Dominique Devienne
Тема Re: Sequence vs UUID
Дата
Msg-id CAFCRh--mkvA6nfb2VE-Zy80nHgriyKV9nMbS2iSTjwzrHW5mHw@mail.gmail.com
обсуждение исходный текст
Ответ на Re: Sequence vs UUID  (Merlin Moncure <mmoncure@gmail.com>)
Ответы Re: Sequence vs UUID  (veem v <veema0000@gmail.com>)
Список pgsql-general
Дерево обсуждения
On Tue, Feb 7, 2023 at 3:47 PM Merlin Moncure <mmoncure@gmail.com> wrote:
On Mon, Feb 6, 2023 at 1:22 PM Peter J. Holzer <hjp-pgsql@hjp.at> wrote:
On 2023-02-06 20:04:39 +0100, Julian Backes wrote:
But UUIDs are random and that plays havoc with locality.

This is really key.  [...] the databases I've seen that are written with the
UUID pattern appear to be written by developers oblivious to this fact.

Well, perhaps these developers are not dealing with temporally clustered data, like commerce related DB,
and more scientific data? In any case, this developer will definitely investigate ULIDs, vs UUIDs, vs Ints (sequences),
based on the info from this thread. I'm aware of fragmentation issues, and cache hit/miss issues etc, in general;
but was probably not sufficiently making the mental connection with UUIDs and PostgreSQL. So thanks everyone.

В списке pgsql-general по дате отправления:

Предыдущее
От: Adrian Klaver
Дата:
Сообщение: Re: ALTER COLUMN to change GENERATED ALWAYS AS expression?
Следующее
От: Raymond Brinzer
Дата:
Сообщение: Re: A Small psql Suggestion