Ravi Kiran <ravi.kolanp...@gmail.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 -- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-hackers