On Sat, Mar 8, 2014 at 6:18 AM, Ishaya Bhatt wrote:
> 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
On Saturday, March 8, 2014, Ishaya Bhatt wrote:
> 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 nest
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
