Re: Drawbacks of using BYTEA for PK?

Поиск
Список
Период
Сортировка
От David Garamond
Тема Re: Drawbacks of using BYTEA for PK?
Дата
Msg-id 4002C2D1.7020202@zara.6.isreserved.com
обсуждение исходный текст
Ответ на Re: Drawbacks of using BYTEA for PK?  (Tom Lane <tgl@sss.pgh.pa.us>)
Ответы Re: Drawbacks of using BYTEA for PK?  ("D. Dante Lorenso" <dante@lorenso.com>)
Список pgsql-general
Tom Lane wrote:
> David Garamond <lists@zara.6.isreserved.com> writes:
>
>>Perhaps I can make a GUID by MD5( two random numbers || a timestamp || a
>>unique seed like MD5 of '/sbin/ifconfig' output)...
>
> Adding an MD5 hash contributes *absolutely zero*, except waste of space,
> to any attempt to make a GUID.  The hash will add no uniqueness that was
> not there before.

Of course, in the above case, MD5 is used to compress the "uniqueness"
(which should be more than 128-bit, comprised of: a) [good] random
number; b) timestamp; c) a "node ID" element, either from /sbin/config
output which contain MAC address, or from the hash of harddisk content,
etc) into a 128-bit space.

--
dave


В списке pgsql-general по дате отправления:

Предыдущее
От: Bruno Wolff III
Дата:
Сообщение: Re: int8 version of NUMERIC?
Следующее
От: Melanie Bergeron
Дата:
Сообщение: unsubscribe