Re: UUID column as pimrary key?

Поиск
Список
Период
Сортировка
От Alban Hertroys
Тема Re: UUID column as pimrary key?
Дата
Msg-id BD60A226-95FD-4D13-9F6B-E7CB94602DCB@solfertje.student.utwente.nl
обсуждение исходный текст
Ответ на Re: UUID column as pimrary key?  (Rob Sargent <robjsargent@gmail.com>)
Ответы Re: UUID column as pimrary key?
Список pgsql-general
>> From wikipedia, "only after generating 1 billion UUIDs every second for
> the next 100 years, the probability of creating just one duplicate would
> be about 50%. The probability of one duplicate would be about 50% if
> every person on earth owns 600 million UUIDs."


Even if the chances of one person encountering a UUID collision are about once in say 100 billion years, that could be
tomorrow.It could also not happen at all in that time span. That's how chance works. You can never assume it won't
happen.If the costs incurred by a collision are lower than the costs of preventing it, you can choose to just take the
hit,but that doesn't go for _every_ problem domain. The medical systems mentioned up-thread are an example of that. 

Next to that, UUID's are generated by computers. I have no doubts that the numeric space that makes up a UUID allows
forcollision chances as low as described, but are computers capable of generating those numbers sufficiently random
thatthey actually achieve that low a chance? I think that's pushing it. 

Alban Hertroys

--
If you can't see the forest for the trees,
cut the trees and you'll see there is no forest.


!DSPAM:737,4d24f31d11541020617287!



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

Предыдущее
От: Peter Geoghegan
Дата:
Сообщение: Re: Asynchronous queries with bound data.
Следующее
От: Rob Sargent
Дата:
Сообщение: Re: UUID column as pimrary key?