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 <donmel...@gmail.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 > >
