Re: Question regarding fast-hashing in PGSQL

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



This should work perfectly for me.  Thank you so much!

On Wed, Sep 18, 2019 at 12:50 PM Adam Brusselback <adambrusselback@xxxxxxxxx> wrote:
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

[Postgresql General]     [Postgresql PHP]     [PHP Users]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Books]     [PHP Databases]     [Yosemite]

  Powered by Linux