Postgres Pro
Downloads
Home   >   mailing lists

Re: How to change query planner configuration paramerters - Mailing list pgsql-admin

From Raghavendra
Subject Re: How to change query planner configuration paramerters
Date
Msg-id CA+h6Ahhb6SyXt55YgsWmKOJkQ-opKpDHJv_rWJ_WejF=F+0GTw@mail.gmail.com
Whole thread Raw
In response to How to change query planner configuration paramerters  (Melaka Gunasekara <donmelaka@gmail.com>)
Responses Re: How to change query planner configuration paramerters  (Melaka Gunasekara <donmelaka@gmail.com>)
List pgsql-admin
Tree view
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



On Sun, Sep 18, 2011 at 2:55 PM, Melaka Gunasekara <donmelaka@gmail.com> wrote:
Hi all,
 
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


pgsql-admin by date:

Previous
From: Richard Shaw
Date:
Subject: Re: Problem of LD_LIBRARY_PATH
Next
From: Melaka Gunasekara
Date:
Subject: Re: How to change query planner configuration paramerters