Re: How to change query planner configuration paramerters

[Raghavendra <raghavendra.rao@xxxxxxxxxxxxxxxx>]

postgres=# set enable_hashjoin to off;

SET

postgres=# show enable_hashjoin;

 enable_hashjoin

-----------------

 off

(1 row)

Above, changes applies for the current session (its Session-Level). If you want to do at Database-level use ALTER DATABASE and for entire Cluster-level edit postgresql.conf and do changes as per your requirement.

---

Regards,

Raghavendra

EnterpriseDB Corporation

Blog: http://raghavt.blogspot.com/

On Sun, Sep 18, 2011 at 2:55 PM, Melaka Gunasekara <donmelaka@xxxxxxxxx> wrote:

Hi all,

 

I came across  http://www.postgresql.org/docs/8.4/static/runtime-config-query.html which describes

how to change query planner configuration paramerters.

 

I need to know how I can change these parameters.

For example if I need to turn off enable_hashjoin, how can I do that?

Best Regards, 

Melaka