Re: Storing images in PostgreSQL databases (again)

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: Raw Message | Whole Thread | 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.

In response to

Responses

Browse pgsql-general by date

  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