Re: Indexes for hashes

From: "Joshua D(dot) Drake" <jd(at)commandprompt(dot)com>
To: Ivan Voras <ivoras(at)gmail(dot)com>, julyanto(at)equnix(dot)co(dot)id
Cc: postgres performance list <pgsql-performance(at)postgresql(dot)org>
Subject: Re: Indexes for hashes
Date: 2016-06-15 14:36:13
Message-ID: 576167DD.6060208@commandprompt.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-performance

On 06/15/2016 07:20 AM, Ivan Voras wrote:
> Hi,
>
> Just for testing... is there a fast (i.e. written in C) crc32 or a
> similar small hash function for PostgreSQL?

https://www.postgresql.org/docs/9.5/static/pgcrypto.html

We also have a builtin md5().

JD
--
Command Prompt, Inc. http://the.postgres.company/
+1-503-667-4564
PostgreSQL Centered full stack support, consulting and development.
Everyone appreciates your honesty, until you are honest with them.

In response to

Browse pgsql-performance by date

  From Date Subject
Next Message ktm@rice.edu 2016-06-15 14:53:44 Re: Indexes for hashes
Previous Message Ivan Voras 2016-06-15 14:20:46 Re: Indexes for hashes