Re: UUID as primary key

Поиск
Список
Период
Сортировка
От Alvaro Herrera
Тема Re: UUID as primary key
Дата
Msg-id 20091016220156.GJ4505@alvh.no-ip.org
обсуждение исходный текст
Ответ на Re: UUID as primary key  (decibel <decibel@decibel.org>)
Список pgsql-performance
decibel escribió:

> >If you want it to be seemless and fully optimal, you would
> >introduce a new int256 type (or whatever the name of the type you
> >are trying to represent). Adding new types to PostgreSQL is not
> >that hard. This would allow queries (=, <>, <, >) as well.
>
> If you want an example of that, we had Command Prompt create a full
> set of hash datatypes (SHA*, and I think md5). That stuff should be
> on pgFoundry; if it's not drop me a note at jnasby@cashnetusa.com
> and I'll get it added.

It's at project "shatypes".

--
Alvaro Herrera                                http://www.CommandPrompt.com/
The PostgreSQL Company - Command Prompt, Inc.

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

Предыдущее
От: decibel
Дата:
Сообщение: Re: UUID as primary key
Следующее
От: Vikul Khosla
Дата:
Сообщение: Indexes on low cardinality columns