Re: *****SPAM***** Re: [GENERAL] UUID column as pimrary key?

2011-01-05 Thread Scott Ribe
On Jan 5, 2011, at 10:30 AM, Radosław Smogura wrote: 128bits is huge for now, but what will happen in next 2,3 years? It will still be large. When you get up to around 100 trillion UUIDs, you'll be getting up to around a 1 in a billion chance of a single collision. Before you claim that we'll

Re: *****SPAM***** Re: [GENERAL] UUID column as pimrary key?

2011-01-05 Thread Scott Ribe
On Jan 5, 2011, at 11:31 AM, Radosław Smogura wrote: The true is that probability that in two coin drops we will get two reverses is 1/4, but true is, too, as Newton said, it's 1/3, because if in 1st drop we don't get reverse we don't need to drop again. Nonsense. You don't stop

Re: *****SPAM***** Re: [GENERAL] UUID column as pimrary key?

2011-01-05 Thread Scott Ribe
On Jan 5, 2011, at 1:13 PM, Raymond O'Donnell wrote: Is that taking dark matter into account? :-) It's not clear to me ;-) -- Scott Ribe scott_r...@elevated-dev.com http://www.elevated-dev.com/ (303) 722-0567 voice -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To

Re: *****SPAM***** Re: [GENERAL] UUID column as pimrary key?

2011-01-05 Thread Scott Ribe
On Jan 5, 2011, at 3:03 PM, Andrew Sullivan wrote: ...the example was not that UUIDs are being generated and collected in one place at that rate, but that they're being generated in several independent places at a time... In order for a collision to matter, really in order for there to *be* a

Re: *****SPAM***** Re: [GENERAL] UUID column as pimrary key?

2011-01-05 Thread Scott Ribe
On Jan 5, 2011, at 4:11 PM, Michael Satterwhite wrote: Each machine would have a unique machine_id. This would guarantee uniqueness and be very easy to maintain. And if somebody clones the disk to a new machine, but leaves the old one in service? Or do you use the MAC address and hope that's