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

From Scott Ribe
Subject Re: UUID column as pimrary key?
Date
Msg-id 1395F6F7-B084-4C00-922D-D36FE22E6A84@elevated-dev.com
Whole thread Raw
In response to Re: UUID column as pimrary key?  (Stuart Bishop <stuart@stuartbishop.net>)
Responses Re: UUID column as pimrary key?  (Bill Moran <wmoran@potentialtech.com>)
List pgsql-general
On Jan 6, 2011, at 1:52 AM, Stuart Bishop wrote:

> If you are looking at these extreme
> improbabilities, your SERIAL isn't guaranteed unique either when you
> take into account cosmic rays flipping the right bits in your ECC
> memory or on your disk platter.

Yes, that's rather the point, the probability is so extremely low that it in most cases it should be treated as 0. Some
peopleseem to have a problem wrapping their heads around relative magnitudes that extreme. 

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





pgsql-general by date:

Previous
From: Scott Marlowe
Date:
Subject: Re: linux server configuration
Next
From: "Marc Mamin"
Date:
Subject: commit delay with dblink.