Re: Indexes for hashes

From: Ivan Voras <ivoras(at)gmail(dot)com>
To: Claudio Freire <klaussfreire(at)gmail(dot)com>
Cc: Julyanto Sutandang <julyanto(at)equnix(dot)co(dot)id>, postgres performance list <pgsql-performance(at)postgresql(dot)org>
Subject: Re: Indexes for hashes
Date: 2016-06-17 08:32:09
Message-ID: CAF-QHFVRBp=_Vo5jmpkaNac_t1fwkiPLGuX0FHe0R29cYkgaCQ@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-performance

And in any case, there's no crc32 in the built-in pgcrypto module.

On 17 June 2016 at 06:18, Claudio Freire <klaussfreire(at)gmail(dot)com> wrote:

> 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 julyanto SUTANDANG 2016-06-17 08:48:56 Re: Indexes for hashes
Previous Message Claudio Freire 2016-06-17 04:18:52 Re: Indexes for hashes