Re: Drawbacks of using BYTEA for PK?

Поиск
Список
Период
Сортировка
От Alex Satrapa
Тема Re: Drawbacks of using BYTEA for PK?
Дата
Msg-id 4004706E.4020405@lintelsys.com.au
обсуждение исходный текст
Ответ на Re: Drawbacks of using BYTEA for PK?  (David Garamond <lists@zara.6.isreserved.com>)
Ответы Re: Drawbacks of using BYTEA for PK?  ("Nigel J. Andrews" <nandrews@investsystems.co.uk>)
Re: Drawbacks of using BYTEA for PK?  (Karsten Hilbert <Karsten.Hilbert@gmx.net>)
Re: Drawbacks of using BYTEA for PK?  (David Garamond <lists@zara.6.isreserved.com>)
Список pgsql-general
David Garamond wrote:
> Remember that /sbin/ifconfig output usually include MAC address too. Not
> that MAC addresses are 100% unique, but that should increase the
> uniqueness.

How do you increase uniqueness?  Either a value is unique or it isn't -
if you've got multiple hosts on the network with the same network
address, you're in big trouble!

32 bits for an IP address is a huge number space... but why you'd really
need that much space as a base for your GUID is beyond me. The "host"
part of the address (eg: the last 8 bits in a /24 network block) would
be enough to uniquely identify the 254 hosts on your network. Then add a
32 bit timestamp, and you have 24 bits left for uniquely identifying
things that are created within the same second on the same server -
that's 16M things per second. Busy little shop you'd be running to
exhaust that unique space ;)

Adding extra number space doesn't increase the uniqueness of any
particular key - you have to know how little you can get away with to be
unique. Like distinguishing two humans from each other - you don't need
to unravel the DNA to 3,000 base pairs (3k bits!) if you can settle for
"blonde" versus "auburn" (1 bit!).

I can't remember who said it, but there's a nice quote that's relevant
in this situation: "The true mark of a well designed system is not that
there's nothing left to add, it's that there's nothing left to take away!"

Regards
Alex Satrapa


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

Предыдущее
От: Phil Campaigne
Дата:
Сообщение: Incremental Development
Следующее
От: Enrico Weigelt
Дата:
Сообщение: Re: serverless postgresql