Planner choosing nested loop in place of Hashjoin

Поиск
Список
Период
Сортировка
От Praneel Devisetty
Тема Planner choosing nested loop in place of Hashjoin
Дата
Msg-id CAHnVB4D-VWf8rx17diSj7FJ=gfg7N_qjr2wES9NpN4iVNcbvXw@mail.gmail.com
обсуждение исходный текст
Ответы Re: Planner choosing nested loop in place of Hashjoin  (Samed YILDIRIM <samed@reddoc.net>)
Re: Planner choosing nested loop in place of Hashjoin  (Jeff Janes <jeff.janes@gmail.com>)
Список pgsql-performance
Hi,

I have a query which is taking roughly 10mins to complete and the query planner is choosing a nested loop.

query and query plan with analyze,verbose,buffers

Disabling the nested loop on session is allowing the query planner to choose a better plan and complete it in 2mins.Stats are up to date and analyze was performed a few hours ago.

Any suggestions on what is causing the planner to choose a nested loop in place of hash and how can we get the query to choose a better plan without disabling the enable_nestloopenable_nestloopenable_nestloop enable_nestloopenable_nestloop?

Thanks 
Praneel


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

Предыдущее
От: Andrew Dunstan
Дата:
Сообщение: Re: INSERT statement going in IPC Wait_event
Следующее
От: Samed YILDIRIM
Дата:
Сообщение: Re: Planner choosing nested loop in place of Hashjoin