Re: GUID for postgreSQL - Mailing list pgsql-general

From Bruno Wolff III
Subject Re: GUID for postgreSQL
Date
Msg-id 20050728192139.GA29472@wolff.to
Whole thread Raw
In response to Re: GUID for postgreSQL  (John DeSoi <desoi@pgedit.com>)
Responses Re: GUID for postgreSQL
List pgsql-general
On Wed, Jul 27, 2005 at 16:57:21 -0400,
  John DeSoi <desoi@pgedit.com> wrote:
>
> On Jul 27, 2005, at 4:46 PM, Scott Marlowe wrote:
>
> >So, how can two databases, not currently talking to one another,
> >guarantee that their GUIDs don't collide? using a large randomly
> >generated name space only reduces the chances of collision, it doesn't
> >actually guarantee it.
>
>
> Like MD5, there is no 100% guarantee, but the collision possibility
> supposed to be is very close to zero.

If you use a large enough space for the number you can reduce that
probability of an accidental collision to much less than that of
catastrophic hardware failure at which point it isn't noticably better
than having no chance of collisions.

pgsql-general by date:

Previous
From: Greg Stark
Date:
Subject: Re: Megabytes of stats saved after every connection
Next
From: Phil Endecott
Date:
Subject: Re: Megabytes of stats saved after every connection