Re: Creating large database of MD5 hash values

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: Creating large database of MD5 hash values
Дата
Msg-id 11406.1212018106@sss.pgh.pa.us
обсуждение исходный текст
Ответ на Re: Creating large database of MD5 hash values  (Bruce Momjian <bruce@momjian.us>)
Список pgsql-performance
Bruce Momjian <bruce@momjian.us> writes:
> Decibel! wrote:
>> If you do this *please* post it. I really think it would be worth
>> while for us to have fixed-size data types for common forms of binary
>> data; MD5, SHA1 and SHA256 come to mind.

> Why do you think it would be worth while?

Given that the overhead for short bytea values is now only one byte
not four-plus-padding, the argument for such types is surely a lot
weaker than it was before 8.3.

            regards, tom lane

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

Предыдущее
От: Bruce Momjian
Дата:
Сообщение: Re: Creating large database of MD5 hash values
Следующее
От: Josh Berkus
Дата:
Сообщение: 2GB or not 2GB