Re: Question regarding fast-hashing in PGSQL - Mailing list pgsql-performance

From Adam Brusselback
Subject Re: Question regarding fast-hashing in PGSQL
Date
Msg-id CAMjNa7cQW4U14VdWVha5cGen9dSOwMkj7JxESmaTzYS1szkqUw@mail.gmail.com
Whole thread Raw
In response to Question regarding fast-hashing in PGSQL  (Stephen Conley <cheetah@tanabi.org>)
Responses Re: Question regarding fast-hashing in PGSQL  (Stephen Conley <cheetah@tanabi.org>)
List 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 by date:

Previous
From: Stephen Conley
Date:
Subject: Question regarding fast-hashing in PGSQL
Next
From: Stephen Conley
Date:
Subject: Re: Question regarding fast-hashing in PGSQL