Re: Question regarding fast-hashing in PGSQL

From: Adam Brusselback <adambrusselback(at)gmail(dot)com>
To: Stephen Conley <cheetah(at)tanabi(dot)org>
Cc: pgsql-performance <pgsql-performance(at)postgresql(dot)org>
Subject: Re: Question regarding fast-hashing in PGSQL
Date: 2019-09-18 16:49:58
Message-ID: CAMjNa7cQW4U14VdWVha5cGen9dSOwMkj7JxESmaTzYS1szkqUw@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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

In response to

Responses

Browse pgsql-performance by date

  From Date Subject
Next Message Stephen Conley 2019-09-18 16:56:32 Re: Question regarding fast-hashing in PGSQL
Previous Message Stephen Conley 2019-09-18 16:41:28 Question regarding fast-hashing in PGSQL