enabling nestedloop and disabling hashjon - Mailing list pgsql-hackers

From Ravi Kiran
Subject enabling nestedloop and disabling hashjon
Date
Msg-id CAOh57xEMb1XuRGJCeEA1uk6vYX77Uicu45mdYbiTunZaaMPznA@mail.gmail.com
Whole thread Raw
Responses Re: enabling nestedloop and disabling hashjon  (Tom Lane <tgl@sss.pgh.pa.us>)
List 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 by date:

Previous
From: Antonin Houska
Date:
Subject: Corner case for add_path_precheck
Next
From: Marc Balmer
Date:
Subject: Re: For cursors, there is FETCH and MOVE, why no TELL?