Re: UUID column as pimrary key?

From: Radosław Smogura <mail(at)smogura(dot)eu>
To: pgsql-general(at)postgresql(dot)org
Cc: Scott Ribe <scott_ribe(at)elevated-dev(dot)com>, Leif Biberg Kristensen <leif(at)solumslekt(dot)org>
Subject: Re: UUID column as pimrary key?
Date: 2011-01-05 18:31:37
Message-ID: 201101051931.37534.mail@smogura.eu
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Scott Ribe <scott_ribe(at)elevated-dev(dot)com> Wednesday 05 January 2011 17:33:51
> On Jan 5, 2011, at 9:19 AM, Leif Biberg Kristensen wrote:
> > I can't help thinking of the «Birthday Paradox»:
> Yes, the calculation of the probability of a collision is the same for the
> "birthday paradox" as for random UUID collisions.

Depends on probability measure we will choose. The true is that probability
that in two coin drops we will get two reverses is 1/4, but true is, too, as
Newton said, it's 1/3, because if in 1st drop we don't get reverse we don't
need to drop again.

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Вячеслав Блинников 2011-01-05 18:35:48 Asynchronous queries with bound data.
Previous Message Peter Geoghegan 2011-01-05 18:11:01 Re: Asynchronous queries with callbacks.