Re: Storing images in PostgreSQL databases (again)

From: Bill Moran <wmoran(at)collaborativefusion(dot)com>
To: Michelle Konzack <linux4michelle(at)freenet(dot)de>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: Storing images in PostgreSQL databases (again)
Date: 2006-10-12 17:38:37
Message-ID: 20061012133837.c6099e92.wmoran@collaborativefusion.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

In response to Michelle Konzack <linux4michelle(at)freenet(dot)de>:

> Am 2006-10-05 21:22:04, schrieb Gregory S. Williamson:
>
> > a sufficiently large hash (MD5 for instance). Of course, there's
>
> I do this already but have problems since I have
> stored arround 130 million files on a server...
>
> > time to create the hash which might be an issue in a high volume
> > system. Extending a hash with some other data (date ?) can
>
> MD5 hashes are 32 Bytes long, maybe they change
> it to 64 Bytes?
>
> I have already over 2000 collisions and checked
> it, that the files are NOT the same.

Try sha1 or sha256.

--
Bill Moran
Collaborative Fusion Inc.

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Tim Tassonis 2006-10-12 17:40:42 Re: more anti-postgresql FUD
Previous Message David Fetter 2006-10-12 17:37:42 Re: Override system-defined cast?