Re: Storing images in PostgreSQL databases (again) - Mailing list pgsql-general

From Alexander Staubo
Subject Re: Storing images in PostgreSQL databases (again)
Date
Msg-id 12A3DF0B-8B3F-4399-ABE5-B506A1B8A21C@purefiction.net
Whole thread Raw
In response to Re: Storing images in PostgreSQL databases (again)  (Robert L Mathews <lists@tigertech.com>)
List pgsql-general
On Oct 13, 2006, at 01:36 , Robert L Mathews wrote:

> Michelle Konzack <linux4michelle@freenet.de> wrote:
>
>> I do this already but have problems since I have
>> stored arround 130 million files on a server...
> > ...
> >
>> 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.
>
> You mean you have 2000 collisions out of the checksums of 130
> million different files? That can't be right.
[...]
> If you have 2000 collisions after 130 million different files (or
> even if you have two collisions), something is almost certainly
> wrong with your code, unfortunately.

Or Michelle is storing a bunch of duplicate images.

Alexander.

pgsql-general by date:

Previous
From: Robert L Mathews
Date:
Subject: Re: Storing images in PostgreSQL databases (again)
Next
From: Christopher Browne
Date:
Subject: Re: more anti-postgresql FUD