Re: Question regarding fast-hashing in PGSQL

Adam Brusselback <[email protected]> Wed, 18 Sep 2019 12:49:58 -0400

Newsgroups	gmane.comp.db.postgresql.performance
Message-ID	<CAMjNa7cQW4U14VdWVha5cGen9dSOwMkj7JxESmaTzYS1szkqUw@mail.gmail.com>

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