Ravi Kiran <ravi.kolanp...@gmail.com> writes: > yes sir, I did try the pg_ctl reload command, 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
Does "show enable_hashjoin" say it's off? If not, I think you must've fat-fingered the postgresql.conf change somehow. 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