Re: UUID or auto-increment

Поиск
Список
Период
Сортировка
От Peter J. Holzer
Тема Re: UUID or auto-increment
Дата
Msg-id 20200810200610.GA32371@hjp.at
обсуждение исходный текст
Ответ на Re: UUID or auto-increment  (Israel Brewster <ijbrewster@alaska.edu>)
Ответы Re: UUID or auto-increment
Список pgsql-general
On 2020-08-10 09:10:00 -0800, Israel Brewster wrote:
> I would point out, however, that using a V1 UUID rather than a V4 can
> help with this as it is sequential, not random (based on MAC address
> and timestamp + random).

If I read the specs correctly, a V1 UUID will roll over every 429
seconds. I think that as far as index locality is concerned, this is
essentially random for most applications.

        hp

--
   _  | Peter J. Holzer    | Story must make more sense than reality.
|_|_) |                    |
| |   | hjp@hjp.at         |    -- Charles Stross, "Creative writing
__/   | http://www.hjp.at/ |       challenge!"

Вложения

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

Предыдущее
От: Martin Gainty
Дата:
Сообщение: Re: Certficates
Следующее
От: "David G. Johnston"
Дата:
Сообщение: Re: Certficates