Selection of join algorithm

From: Ishaya Bhatt <ishayabhatt(at)gmail(dot)com>
To: "pgsql-novice(at)postgresql(dot)org" <pgsql-novice(at)postgresql(dot)org>
Subject: Selection of join algorithm
Date: 2014-03-08 14:20:48
Message-ID: CA+E1M32spRAp0krtwEWm2qf48ydeDtegSqpm3NvA2y7a_Z8jOw@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-novice

Hi,

I am trying to analyze join performance. But I see that even for a table
having 100,000 rows and join attribute as primary key, postgres always
performs hash join.

Can anyone please tell me under which conditions merge join or nested loop
join is invoked?

Thanks and Regards,
Ishaya

Responses

Browse pgsql-novice by date

  From Date Subject
Next Message Amol Bhangdiya 2014-03-08 15:35:05 Re: Selection of join algorithm
Previous Message David Johnston 2014-02-28 20:15:41 Re: XML data