title: enabling nested loop join and disabling hash join in postgres.
body: <p>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.</p>
  
  <p>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.conf file.</p>
  
  <p>I did try the pg_ctl reload command to reload the configuration files, but its still using the hash join algorithm and not the nested loop algorithm. I even restarted the server, even then its still using the hash join algorithm</p>
  
  <p>can some one tell me what I am doing wrong, or is there any other file where I need to modify to force postgres to use nested loop algorithm.</p>
  
  <p>PS: I already posted this question in pg_hackers mailing list,but I have not got any answer there yet, so I am posting here.</p>
  
  <p>Thanks</p>