Re: GUID for postgreSQL

Поиск
Список
Период
Сортировка
От Ron Mayer
Тема Re: GUID for postgreSQL
Дата
Msg-id 42ED3766.5050103@cheapcomplexdevices.com
обсуждение исходный текст
Ответ на Re: GUID for postgreSQL  ("Dann Corbit" <DCorbit@connx.com>)
Список 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 по дате отправления:

Предыдущее
От: Alex Stapleton
Дата:
Сообщение: Re: Real vs Float & 32bit vs 64bit CPU Performance Question
Следующее
От: eoghan
Дата:
Сообщение: postmaster