Re: Question regarding fast-hashing in PGSQL

Поиск
Список
Период
Сортировка
От Adam Brusselback
Тема Re: Question regarding fast-hashing in PGSQL
Дата
Msg-id CAMjNa7cQW4U14VdWVha5cGen9dSOwMkj7JxESmaTzYS1szkqUw@mail.gmail.com
обсуждение исходный текст
Ответ на Question regarding fast-hashing in PGSQL  (Stephen Conley <cheetah@tanabi.org>)
Ответы Re: Question regarding fast-hashing in PGSQL  (Stephen Conley <cheetah@tanabi.org>)
Список pgsql-performance
I've had a similar issue in the past.

I used the md5 hash function and stored it in a UUID column for my comparisons. Bigger than a bigint, but still much faster than string comparisons directly for my use case.
UUID works fine for storing md5 hashes and gives you the ability to piggyback on all the index support built for them.

Hope that helps,
-Adam

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

Предыдущее
От: Stephen Conley
Дата:
Сообщение: Question regarding fast-hashing in PGSQL
Следующее
От: Stephen Conley
Дата:
Сообщение: Re: Question regarding fast-hashing in PGSQL