Re: How to change query planner configuration paramerters

Поиск
Список
Период
Сортировка
От Raghavendra
Тема Re: How to change query planner configuration paramerters
Дата
Msg-id CA+h6Ahhb6SyXt55YgsWmKOJkQ-opKpDHJv_rWJ_WejF=F+0GTw@mail.gmail.com
обсуждение исходный текст
Ответ на How to change query planner configuration paramerters  (Melaka Gunasekara <donmelaka@gmail.com>)
Ответы Re: How to change query planner configuration paramerters  (Melaka Gunasekara <donmelaka@gmail.com>)
Список pgsql-admin
Дерево обсуждения
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 по дате отправления:

Предыдущее
От: Richard Shaw
Дата:
Сообщение: Re: Problem of LD_LIBRARY_PATH
Следующее
От: Melaka Gunasekara
Дата:
Сообщение: Re: How to change query planner configuration paramerters