Re: How to change query planner configuration paramerters

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(at)gmail(dot)com>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
>
>