Ravi Kiran <ravi(dot)kolanpaka(at)gmail(dot)com> writes:
> I am sorry for the late reply, when I disabled the hash join command
> "enable_hashjoin=off" in the postgresql.conf file, it was not working. But
> I when I used the command "set enable_hashjoin=off" command in the back
> end. It worked.
> I am not able to understand why it did not get disabled when I changed it
> in the postgresql file.
The two plausible explanations for that are (1) you didn't do a reload
or (2) you forgot to remove the '#' comment marker in the file's entry.
regards, tom lane