Re: Question regarding fast-hashing in PGSQL
Stephen Conley <[email protected]>
| Newsgroups | gmane.comp.db.postgresql.performance |
|---|---|
| Message-ID | <CAFbQXuFuToNoTkC3o=G_8KfU-3gtw1SyrMGPaFaQiieaSt=DMA@mail.gmail.com> |
This should work perfectly for me. Thank you so much! On Wed, Sep 18, 2019 at 12:50 PM Adam Brusselback <[email protected]> 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 >