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
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,000th of the UUID space (assuming random UUIDs). Leaving you with a chance of a single collision of 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 ;-)
(303) 722-0567 voice
In response to
pgsql-general by date
|Next:||From: Leif Biberg Kristensen||Date: 2011-01-05 16:19:22|
|Subject: Re: UUID column as pimrary key?|
|Previous:||From: Andreas Kretschmer||Date: 2011-01-05 16:14:26|
|Subject: Re: Archive command and used size of wal|