| From: | Alexander Staubo <alex(at)purefiction(dot)net> |
|---|---|
| To: | Robert L Mathews <lists(at)tigertech(dot)com> |
| Cc: | pgsql-general(at)postgresql(dot)org |
| Subject: | Re: Storing images in PostgreSQL databases (again) |
| Date: | 2006-10-13 00:01:38 |
| Message-ID: | 12A3DF0B-8B3F-4399-ABE5-B506A1B8A21C@purefiction.net |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
On Oct 13, 2006, at 01:36 , Robert L Mathews wrote:
> Michelle Konzack <linux4michelle(at)freenet(dot)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.
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Niederland | 2006-10-13 01:40:22 | Create Index on Date portion of timestamp |
| Previous Message | Tom Lane | 2006-10-12 23:39:37 | Re: bad error message |