Storing a file hash as primary key

Поиск
Список
Период
Сортировка
От Eduardo Pérez Ureta
Тема Storing a file hash as primary key
Дата
Msg-id 20040507172554.GA10923@localhost.localdomain
обсуждение исходный текст
Ответы Re: Storing a file hash as primary key  (Greg Stark <gsstark@mit.edu>)
Список pgsql-general
I was wondering what the best way is to store a file hash (MD5 or SHA1)
and make it primary key indexed.
I have seen some people storing the hexadecimal encoded MD5 in a
CHAR(32) but it may be a better idea to use a CHAR(16) without encoding
the string, but that may cause some problems.

What do you recommend?
Do you have any experiences storing file hashes in a database?
Do you know any good opensource software that stores file hashes in the
database (to take a look)?

В списке pgsql-general по дате отправления:

Предыдущее
От: Tom Lane
Дата:
Сообщение: Re: Interpreting vacuum verbosity
Следующее
От: Bill Moran
Дата:
Сообщение: Re: any experience with multithreaded pg apps?