Ravi Kiran <ravi(dot)kolanpaka(at)gmail(dot)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