Обсуждение: Selection of join algorithm
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.If you specify joining condition other than equality then nested loop join is invoked.
Example Query : explain analyze select name from student,takes where student.id > takes.idOn Sat, Mar 8, 2014 at 7:50 PM, Ishaya Bhatt <ishayabhatt@gmail.com> wrote:
IshayaThanks and Regards,Can anyone please tell me under which conditions merge join or nested loop join is invoked?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.