Re: UUID as primary key - Mailing list pgsql-performance

From Alvaro Herrera
Subject Re: UUID as primary key
Date
Msg-id 20091016220156.GJ4505@alvh.no-ip.org
Whole thread Raw
In response to Re: UUID as primary key  (decibel <decibel@decibel.org>)
List 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 by date:

Previous
From: decibel
Date:
Subject: Re: UUID as primary key
Next
From: Vikul Khosla
Date:
Subject: Indexes on low cardinality columns