Re: Hash function

From: Lacey Powers <lacey(dot)leanne(at)gmail(dot)com>
To: Ravi Kiran <ravi(dot)kolanpaka(at)gmail(dot)com>
Cc: pgsql-novice(at)postgresql(dot)org
Subject: Re: Hash function
Date: 2015-02-21 18:02:37
Message-ID: CAA7NH1-rGOEeX4mpYqFHmAs74f3o+Ry2P7-nTWehRDzaQwiGMw@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-novice

On Jan 11, 2015 6:53 AM, "Ravi Kiran" <ravi(dot)kolanpaka(at)gmail(dot)com> wrote:
>
> Hi,
>
> I want to know what kind of hash function postgres is using currently,
can someone please explain the algorithm postgres is using for the hash
function in the hash join algorithm.
>
> Thanks,
>
> K.Ravikiran

Hello,

I would start by looking here.

http://git.postgresql.org/gitweb/?p=postgresql.git;a=tree;f=src/backend/access/hash;hb=HEAD

hashfunction.c might be of most interest to you. :)

Otherwise, I would ask internals questions like this on -hackers instead of
-novice

Hope that helps :)

Lacey

In response to

Browse pgsql-novice by date

  From Date Subject
Next Message JORGE MALDONADO 2015-03-04 18:28:25 Split the result of a query in 2 rows
Previous Message s d 2015-02-20 20:08:45 Re: Upgrade from 8.4 to 9.4.1