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

Reply via email to