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

From Michelle Konzack
Subject Re: Storing images in PostgreSQL databases (again)
Date
Msg-id Ywo4XD.A.4k.xtnLFB@t1950ct.private
Whole thread Raw
In response to Re: Storing images in PostgreSQL databases (again)  ("Gregory S. Williamson" <gsw@globexplorer.com>)
Responses Re: Storing images in PostgreSQL databases (again)  (Bill Moran <wmoran@collaborativefusion.com>)
List pgsql-general
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.

> considerably decrease the chance of collisions. It's still a
> longish key, but workable I suspect (untested, we used an
> artificial key, a serial).

Greetings
    Michelle Konzack
    Systemadministrator
    Tamay Dogan Network
    Debian GNU/Linux Consultant


--
Linux-User #280138 with the Linux Counter, http://counter.li.org/
##################### Debian GNU/Linux Consultant #####################
Michelle Konzack   Apt. 917                  ICQ #328449886
                   50, rue de Soultz         MSM LinuxMichi
0033/6/61925193    67100 Strasbourg/France   IRC #Debian (irc.icq.com)


pgsql-general by date:

Previous
From: "William Penberthy"
Date:
Subject: Re: SPAM-LOW: cursors and ASP page
Next
From: David Fetter
Date:
Subject: Re: Override system-defined cast?