Re: UUID column as pimrary key?

Поиск
Список
Период
Сортировка
От Scott Ribe
Тема Re: UUID column as pimrary key?
Дата
Msg-id A6A6ABF5-71F7-4941-9D0B-D1CEE5C8ED0D@elevated-dev.com
обсуждение исходный текст
Ответ на Re: UUID column as pimrary key?  (Bill Moran <wmoran@potentialtech.com>)
Ответы Re: UUID column as pimrary key?
Список pgsql-general
On Jan 5, 2011, at 8:55 AM, Bill Moran wrote:

> That statement demonstrates a lack of investigation and/or consideration
> of the circumstances.

No, it doesn't.

> However, if there are 5000 devices generating 100 UUIDs per hour, and you'll
> be keeping those records for 10+ years, the chances of collisions near
> the end of that 10 year span get high enough to actually make developers
> nervous.

No, they don't. At the end of your hypothetical 10-year period, you will have used about 43,000,000,000 UUIDs, or about
1/100,000,000,000,000,000,000,000,000thof the UUID space (assuming random UUIDs). Leaving you with a chance of a single
collisionof about 1/18,000,000,000,000,000. 

Assuming of course good entropy. If the generation of random numbers is bad, then UUIDs are not so useful ;-)

--
Scott Ribe
scott_ribe@elevated-dev.com
http://www.elevated-dev.com/
(303) 722-0567 voice





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

Предыдущее
От: Andreas Kretschmer
Дата:
Сообщение: Re: Archive command and used size of wal
Следующее
От: Leif Biberg Kristensen
Дата:
Сообщение: Re: UUID column as pimrary key?