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

From Rodrigo Gonzalez
Subject Re: enabling nestedloop and disabling hashjon
Date
Msg-id 54DD288C.5090101@gmail.com
Whole thread Raw
In response to Re: enabling nestedloop and disabling hashjon  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-hackers
On 12/2/15 18:29, Tom Lane wrote:
> Ravi Kiran <ravi.kolanpaka@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.

Or you changed the wrong postgresql.conf file

Regards

Rodrigo Gonzalez




pgsql-hackers by date:

Previous
From: Jim Nasby
Date:
Subject: Re: enabling nestedloop and disabling hashjon
Next
From: hailong Li
Date:
Subject: Help me! Why did the salve stop suddenly ?