Skip site navigation (1) Skip section navigation (2)

Re: UUID column as pimrary key?

From: Jasen Betts <jasen(at)xnet(dot)co(dot)nz>
To: pgsql-general(at)postgresql(dot)org
Subject: Re: UUID column as pimrary key?
Date: 2011-01-06 09:51:03
Message-ID: ig43a7$2qv$2@reversiblemaps.ath.cx (view raw or flat)
Thread:
Lists: pgsql-general
On 2011-01-05, Scott Ribe <scott_ribe(at)elevated-dev(dot)com> wrote:
> On Jan 5, 2011, at 9:01 AM, Tom Lane wrote:
>
>> In practical use I think the odds of a collision are *far* higher than
>> you are suggesting, unless the UUID generation is being done with a lot
>> more care than is likely if the user takes these sorts of claims at face
>> value.
>
> Eh? The user taking such claims at face value has no bearing whatsoever on the quality of the UUID generation algorithm provided by the OS. So, unless we're talking about users coming up with their own algorithms, it seems reasonable to assume that the generation is done with a great deal of care. (And if we are talking about users coming up with their own algorithms, then all bets are off; feel free to assume the worst.) I know that is the case on OS X & Linux. I would be shocked if it were not the case on Solaris. I would even be surprised if it were not the case on Windows.


> The IETF Network Working Group designed UUIDs to ensure that their
> uniqueness guarantee would be strong enough that no application would
> need to worry about duplicates, ever. Claims that collisions are too
> likely to depend on UUIDs being unique really are claims that the IETF
> Network Working Group didn't know what it was doing, which I find a
> bit ridiculous.     

Who was it that decided on 32 bits for IP addresses?

-- 
⚂⚃ 100% natural

In response to

Responses

pgsql-general by date

Next:From: Sim ZacksDate: 2011-01-06 11:20:54
Subject: linux server configuration
Previous:From: Stuart BishopDate: 2011-01-06 08:52:15
Subject: Re: UUID column as pimrary key?

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group