Re: Storing images in PostgreSQL databases (again)

Поиск
Список
Период
Сортировка
От Michelle Konzack
Тема Re: Storing images in PostgreSQL databases (again)
Дата
Msg-id Ywo4XD.A.4k.xtnLFB@t1950ct.private
обсуждение исходный текст
Ответ на Re: Storing images in PostgreSQL databases (again)  ("Gregory S. Williamson" <gsw@globexplorer.com>)
Ответы Re: Storing images in PostgreSQL databases (again)  (Bill Moran <wmoran@collaborativefusion.com>)
Список 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 по дате отправления:

Предыдущее
От: "William Penberthy"
Дата:
Сообщение: Re: SPAM-LOW: cursors and ASP page
Следующее
От: David Fetter
Дата:
Сообщение: Re: Override system-defined cast?