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

From Alban Hertroys
Subject Re: UUID column as pimrary key?
Date
Msg-id 68E9C3DF-8A66-4D0A-9208-E62B2BCEB3DC@solfertje.student.utwente.nl
Whole thread Raw
In response to Re: UUID column as pimrary key?  (Chris Browne <cbbrowne@acm.org>)
List pgsql-general
On 6 Jan 2011, at 17:51, Chris Browne wrote:

> wmoran@potentialtech.com (Bill Moran) writes:
> If your system is sufficiently negligently designed that this particular
> conflict causes it to kill people, then I wouldn't be too inclined to
> point at this issue with UUIDs being the Real Problem with the system.
>
> This is NOT the only risk that the system faces; you can't get *nearly*
> as low probabilities attached to hardware and network issues such as:
> - Disks failing
> - Cosmic rays twiddling bits in memory
> - Network connections failing part way through the work
> - Dumb techs blindly cloning the same "host key" onto every one of the
>   EMTs' data collection devices


Let's say that you actually build a mission critical system for which you'd need to evacuate the country if it fails.
Youpick the best ECC RAM you can find, the most reliable type of disk storage available, your fallback network has a
fallbacknetwork of it's own, etc. Basically you have done everything you could to ensure that the chances of the system
failingare as small as technically possible. 

All those little failure chances add up to a certain number. Using UUID's for your ID's is not required for the design
ofthe system, yet you chose to do so. You added a nearly infinite chance of UUID collisions to the accumulated chance
ofthe system failing. 

Now the system miraculously fails and the country needs evacuating. A committee is going to investigate why it failed.
Ifthe dumb techy above is responsible, they just found themselves a scape-goat. If they didn't, but stumble upon your
unnecessaryusage of UUID's instead... Let's just say I don't want to be that person. 

I have to agree with Bill here, if lives depend on your system then anything that adds to the failure chances is very
hardto defend. In the end it often boils down to responsibility in case of failure, not to mention what it does to your
ownpeace of mind. 

Alban Hertroys

--
If you can't see the forest for the trees,
cut the trees and you'll see there is no forest.


!DSPAM:737,4d260af211541129314545!



pgsql-general by date:

Previous
From: Bill Moran
Date:
Subject: Apology
Next
From: Chris Browne
Date:
Subject: Re: UUID column as pimrary key?