Re: UUID or auto-increment

Поиск
Список
Период
Сортировка
От Ravi Krishna
Тема Re: UUID or auto-increment
Дата
Msg-id 837516231.2607507.1597077490690@mail.yahoo.com
обсуждение исходный текст
Ответ на UUID or auto-increment  (Ashkar Dev <ashkardev@gmail.com>)
Ответы Re: UUID or auto-increment  (Michael Lewis <mlewis@entrata.com>)
Re: UUID or auto-increment  (Ron <ronljohnsonjr@gmail.com>)
Список pgsql-general
Both can handle concurrent writes.  auto-increment is nothing but serial or sequence cols and they can handle unique concurrent request.  That is why sometimes you may have gaps.
UUID is not only unique, but is also unique across space. You can have two different databases generate UUID at the same time and it will still be unique. So that will help if you are consolidating different databases into one big data mart and they can all can go to the same table without conflict. With Sequence or Serial that will be a problem.
Finally UUID results in write amplication in wal logs.  Keep that in mind if your app does lot of writes.

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

Предыдущее
От: "pgml@gmx.de"
Дата:
Сообщение: SQL Question about like
Следующее
От: Ron
Дата:
Сообщение: Re: SQL Question about like