Converting Nested loop to hashjoin for not is distinct from case

From: Narendra Pradeep U U <narendra(dot)pradeep(at)zohocorp(dot)com>
To: "pgsql-hackers" <pgsql-hackers(at)postgresql(dot)org>
Subject: Converting Nested loop to hashjoin for not is distinct from case
Date: 2019-08-28 10:49:08
Message-ID: 16cd7d7f07b.121fe586711535.5055012891666205806@zohocorp.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

Hi,

     

          I have a  join query with is not distinct from criteria (select * from table1 join table2 on a is not  distinct from b). on examining,  it was the  nested loop join that makes the query slow.  For join with ' is not distinct from ' qual can't the planner choose  hash-join over nested loop  or will there be any problem by doing so. Kindly enlighten me about the same.

Thanks
Pradeep

Browse pgsql-hackers by date

  From Date Subject
Next Message Etsuro Fujita 2019-08-28 10:49:17 Re: A problem about partitionwise join
Previous Message Heikki Linnakangas 2019-08-28 10:39:13 Re: Comment in ginpostinglist.c doesn't match code