Postgres Pro
Downloads
Home   >   mailing lists

Re: enabling nestedloop and disabling hashjon - Mailing list pgsql-hackers

From Tom Lane
Subject Re: enabling nestedloop and disabling hashjon
Date
Msg-id 27485.1423582164@sss.pgh.pa.us
Whole thread Raw
In response to Re: enabling nestedloop and disabling hashjon  (Ravi Kiran <ravi.kolanpaka@gmail.com>)
Responses Re: enabling nestedloop and disabling hashjon  (Jim Nasby <Jim.Nasby@BlueTreble.com>)
List pgsql-hackers
Tree view 
Ravi Kiran <ravi.kolanpaka@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

pgsql-hackers by date:

Previous
From: Pavel Stehule
Date:
Subject: Re: For cursors, there is FETCH and MOVE, why no TELL?
Next
From: Greg Sabino Mullane
Date:
Subject: Better error message on pg_upgrade checksum mismatches