Re: GUID for postgreSQL - Mailing list pgsql-general

From Ron Mayer
Subject Re: GUID for postgreSQL
Date
Msg-id 42ED3766.5050103@cheapcomplexdevices.com
Whole thread Raw
In response to Re: GUID for postgreSQL  ("Dann Corbit" <DCorbit@connx.com>)
List pgsql-general
Dann Corbit wrote:
> There is a "privacy hole" from using the MAC address.  (Read it in the
> WIKI article someone else posted).
>
> Probably, it would be better to use a one way hash of the MAC address.
>

The chances of MAC addresses colliding (through some low-end network
card vendor's sloppy manufacturing process; or through the not
uncommon ability to edit your mac address) is surely much higher than
the chance of big random numbers colliding.   Sure, you won't hurt
anything if you add the MAC address to your entropy sources when
generating a GUID; but thinking a MAC address is more unique than
the bits you'd get from any less human-error-prone source is
almost certainly wrong.

pgsql-general by date:

Previous
From: Alex Stapleton
Date:
Subject: Re: Real vs Float & 32bit vs 64bit CPU Performance Question
Next
From: eoghan
Date:
Subject: postmaster