Re: Creating large database of MD5 hash values - Mailing list pgsql-performance

From Decibel!
Subject Re: Creating large database of MD5 hash values
Date
Msg-id FDB7BBE9-6DC0-4E31-9082-AA68F2ABB7E9@decibel.org
Whole thread Raw
In response to Re: Creating large database of MD5 hash values  (Alvaro Herrera <alvherre@commandprompt.com>)
Responses Re: Creating large database of MD5 hash values
List pgsql-performance
On Apr 11, 2008, at 10:25 AM, Alvaro Herrera wrote:

Sorry, yes, I'm behind on email... :(

> If MD5 values will be your primary data and you'll be storing millions
> of them, it would be wise to create your own datatype and operators
> with
> the most compact and efficient representation possible.


If you do this *please* post it. I really think it would be worth
while for us to have fixed-size data types for common forms of binary
data; MD5, SHA1 and SHA256 come to mind.
--
Decibel!, aka Jim C. Nasby, Database Architect  decibel@decibel.org
Give your computer some brain candy! www.distributed.net Team #1828



Attachment

pgsql-performance by date:

Previous
From: Andrzej Zawadzki
Date:
Subject: Re: Quad Xeon or Quad Opteron?
Next
From: Decibel!
Date:
Subject: Re: shared_buffers performance