enabling nestedloop and disabling hashjon

Поиск
Список
Период
Сортировка
От Ravi Kiran
Тема enabling nestedloop and disabling hashjon
Дата
Msg-id CAOh57xEMb1XuRGJCeEA1uk6vYX77Uicu45mdYbiTunZaaMPznA@mail.gmail.com
обсуждение исходный текст
Ответы Re: enabling nestedloop and disabling hashjon  (Tom Lane <tgl@sss.pgh.pa.us>)
Список pgsql-hackers
Hi, 


I want to disable the hashjoin algorithm used by postgres by default, and enable the nested loop join algorithm, can some one tell me how to do that.

I tried modifying the postgresql.conf file where I set the value enable_hashjoin=off and also enable_mergejoin=off, so that I could force postgres to use nested loop.
but postgres is still using the hash join algorithm even after modifying the postgresql code.

can some one tell me what I am doing wrong, or is there any other file where I need to modify to enable nested loop join algorithm.

Thanks

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

Предыдущее
От: Antonin Houska
Дата:
Сообщение: Corner case for add_path_precheck
Следующее
От: Marc Balmer
Дата:
Сообщение: Re: For cursors, there is FETCH and MOVE, why no TELL?