UUID, performance of primary keys

Поиск
Список
Период
Сортировка
Искать
От
Andreas Junius
Тема
UUID, performance of primary keys
Дата
Msg-id
4A39EBBB.5030205@junius.info
Список
Дерево обсуждения
UUID, performance of primary keys "Andreas Junius" <andreas@junius.info>
Re: UUID, performance of primary keys Sean Davis <sdavis2@mail.nih.gov>
Hi Postgres professionals,

I'd like to use UUID for object id's (java.util.UUID). Such an object 
consists of two long values. I could now use two columns (int8) in a 
table for the primary key or one using the string representation. But I 
don't know which option is the more performant one or if there exist 
another more suitable solution. Does anybody know more about this issue?

Andreas
В списке pgsql-novice по дате отправления
От: MITCHELL CIFUENTES
Дата:
От: Sean Davis
Дата:
FAQ