Postgres Pro
Downloads
Home   >   mailing lists

Re: Indexes for hashes - Mailing list pgsql-performance

From Ivan Voras
Subject Re: Indexes for hashes
Date
Msg-id CAF-QHFVRBp=_Vo5jmpkaNac_t1fwkiPLGuX0FHe0R29cYkgaCQ@mail.gmail.com
Whole thread Raw
In response to Re: Indexes for hashes  (Claudio Freire <klaussfreire@gmail.com>)
Responses Re: Indexes for hashes  (julyanto SUTANDANG <julyanto@equnix.co.id>)
List pgsql-performance
Tree view
And in any case, there's no crc32 in the built-in pgcrypto module.


On 17 June 2016 at 06:18, Claudio Freire <klaussfreire@gmail.com> wrote:
On Fri, Jun 17, 2016 at 1:09 AM, julyanto SUTANDANG
<julyanto@equnix.co.id> wrote:
> This way is doing faster using crc32(data) than hashtext since crc32 is
> hardware accelerated in intel (and others perhaps)
> this way (crc32)  is no way the same as hash, much way faster than others...
>
> Regards,

Sure, but I've had uniformity issues with crc32.

pgsql-performance by date:

Previous
From: Claudio Freire
Date:
Subject: Re: Indexes for hashes
Next
From: julyanto SUTANDANG
Date:
Subject: Re: Indexes for hashes