| From: | Alvaro Herrera <alvherre(at)commandprompt(dot)com> |
|---|---|
| To: | decibel <decibel(at)decibel(dot)org> |
| Cc: | Mark Mielke <mark(at)mark(dot)mielke(dot)cc>, tsuraan <tsuraan(at)gmail(dot)com>, pgsql-performance <pgsql-performance(at)postgresql(dot)org> |
| Subject: | Re: UUID as primary key |
| Date: | 2009-10-16 22:01:56 |
| Message-ID: | 20091016220156.GJ4505@alvh.no-ip.org |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | 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(at)cashnetusa(dot)com
> and I'll get it added.
It's at project "shatypes".
--
Alvaro Herrera http://www.CommandPrompt.com/
The PostgreSQL Company - Command Prompt, Inc.
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Vikul Khosla | 2009-10-16 23:36:57 | Indexes on low cardinality columns |
| Previous Message | miller_2555 | 2009-10-16 21:12:24 | Improving join performance over multiple moderately wide tables |