Which is faster: md5() or hashtext()?

Поиск
Список
Период
Сортировка
От Henry C.
Тема Which is faster: md5() or hashtext()?
Дата
Msg-id 59df37f0b52657a0f5114684fe96a9cb.squirrel@zenmail.co.za
обсуждение исходный текст
Ответы Re: Which is faster: md5() or hashtext()?  (Grzegorz Jaśkiewicz <gryzman@gmail.com>)
Список pgsql-general
G'day,

I need to do a mass update on about 550 million rows (I will be breaking it up
into chunks based on id value so I can monitor progress).

Hashing one of the columns is part of the process and I was wondering which is
more efficient/faster:  md5() or hashtext()?

hashtext() produces a nice tight integer value, whereas md5() produces a fixed
string.  My instinct says hashtext(), but there may be a lot more to hashext()
than meets the eye.

Any ideas?

Thanks
Henry


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

Предыдущее
От: hubert depesz lubaczewski
Дата:
Сообщение: Re: How do you control IMMUTABLE PG PROC results?
Следующее
От: Grzegorz Jaśkiewicz
Дата:
Сообщение: Re: Which is faster: md5() or hashtext()?