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
this
would be very much appreciated.
Thanks,
Ishaya Bhatt.
Yes!! Thats exactly what I was looking for !! Thanks :)
On Mon, Nov 11, 2013 at 7:58 PM, Tom Lane wrote:
> Ishaya Bhatt writes:
> > In the sorting code, I need to determine the datatype of my sort
> keys
> > and call some code conditionally based on the datatype. Is
