Re: Indexes for hashes

From: Claudio Freire <klaussfreire(at)gmail(dot)com>
To: julyanto(at)equnix(dot)co(dot)id
Cc: Ivan Voras <ivoras(at)gmail(dot)com>, postgres performance list <pgsql-performance(at)postgresql(dot)org>
Subject: Re: Indexes for hashes
Date: 2016-06-17 04:18:52
Message-ID: CAGTBQpbAYMc96HMDWnJPGr+XTKtB_f_ouv3nXxo_yNZEefDFnA@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-performance

On Fri, Jun 17, 2016 at 1:09 AM, julyanto SUTANDANG
<julyanto(at)equnix(dot)co(dot)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.

In response to

Responses

Browse pgsql-performance by date

  From Date Subject
Next Message Ivan Voras 2016-06-17 08:32:09 Re: Indexes for hashes
Previous Message julyanto SUTANDANG 2016-06-17 04:09:02 Re: Indexes for hashes