Converting Nested loop to hashjoin for not is distinct from case

Поиск
Список
Период
Сортировка
От Narendra Pradeep U U
Тема Converting Nested loop to hashjoin for not is distinct from case
Дата
Msg-id 16cd7d7f07b.121fe586711535.5055012891666205806@zohocorp.com
обсуждение исходный текст
Список 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

В списке pgsql-hackers по дате отправления:

Предыдущее
От: Heikki Linnakangas
Дата:
Сообщение: Re: Comment in ginpostinglist.c doesn't match code
Следующее
От: Etsuro Fujita
Дата:
Сообщение: Re: A problem about partitionwise join