Re: Enable using IS NOT DISTINCT FROM in hash and merge joins

2018-09-04 Thread Alexander Kuzmenkov
Hi, I heard from my colleagues that we have an extension that does a similar thing. I'm attaching the source. It creates operator "==" for some data types, that works like "IS NOT DISTINCT FROM". You can then perform hash joins on this operator. Apparently the hash join machinery supports non

Enable using IS NOT DISTINCT FROM in hash and merge joins

2018-09-04 Thread Chi Gao
Hello, We are using PostgreSQL to execute some SQL scripts "auto translated" from HIVE QL, where the join operator "<=>" is heavily used. The semantic same operator in PostgreSQL is "IS NOT DISTINCT FROM". However, we found when "IS NOT DISTINCT FROM" is used in joins, only nested loop plan ca