Re: UUID column as pimrary key? - Mailing list pgsql-general

From Andrew Sullivan
Subject Re: UUID column as pimrary key?
Date
Msg-id 20110106032648.GB25891@shinkuro.com
Whole thread Raw
In response to Re: *****SPAM***** Re: UUID column as pimrary key?  (Scott Ribe <scott_ribe@elevated-dev.com>)
List pgsql-general
On Wed, Jan 05, 2011 at 07:44:29PM -0700, Scott Ribe wrote:

> In order for a collision to matter, really in order for there to *be* a collision, the duplicate pair has to be
collectedin one place. 

Not at the time of generation, though.  They only have to end up in
the same place at once.  For most cases, the value of the data
compared to the improbably low liklihood of collision means that you
deal with this case by saying, "Yuck.  Well, someone loses."  But if
the data is valuable enough (say, unique identifiers for nuclear
warheads), that's just not an acceptable trade-off.

A

--
Andrew Sullivan
ajs@crankycanuck.ca

pgsql-general by date:

Previous
From: Gordon Shannon
Date:
Subject: walreceiver getting bad data?
Next
From: Andrew Sullivan
Date:
Subject: Re: UUID column as pimrary key?