Postgres Pro
Downloads
Home   >   mailing lists

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

From Leif Biberg Kristensen
Subject Re: UUID column as pimrary key?
Date
Msg-id 201101051719.22141.leif@solumslekt.org
Whole thread Raw
In response to Re: UUID column as pimrary key?  (Bill Moran <wmoran@potentialtech.com>)
Responses Re: UUID column as pimrary key?
List pgsql-general
Tree view 
On Wednesday 5. January 2011 16.05.29 Bill Moran wrote:

> Beyond that, the namespace size for a UUID is so incomprehensibly huge
> that the chance of two randomly generated UUIDs having the same value
> is incomprehensibly unlikely ... it is, however, not a 100% guarantee.

I can't help thinking of the «Birthday Paradox»:

http://en.wikipedia.org/wiki/Birthday_problem

regards, Leif

pgsql-general by date:

Previous
From: Scott Ribe
Date:
Subject: Re: UUID column as pimrary key?
Next
From: Scott Ribe
Date:
Subject: Re: UUID column as pimrary key?