hawq-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Xiang Sheng <xsh...@pivotal.io>
Subject Re: How to enable/disable ORCA CBO?
Date Tue, 17 Jan 2017 14:45:40 GMT
If you build hawq with the option --enable-orca, then the default optimizer
is orca, otherwise the legacy planner.

You could use "show optimizer;" in psql or "hawq config -s optimizer" in
terminal to check the value. If the value is "on" then orca, otherwise
legacy planner.

➜  hawq_devel :  psql -d postgres
psql (8.2.15)
Type "help" for help.

postgres=# show optimizer;
(1 row)

postgres=# \q
➜  hawq_devel hawq config -s optimizer
GUC : optimizer
Value : off


On Tue, Jan 17, 2017 at 10:38 PM, Dmitry Buzolin <Dmitry.Buzolin@theice.com>

> Hi,
> What is default optimizer in Hawq and how to check its value?
> What setting controls the optimizer in HAWQ?
> ------------------------------
> This message may contain confidential information and is intended for
> specific recipients unless explicitly noted otherwise. If you have reason
> to believe you are not an intended recipient of this message, please delete
> it and notify the sender. This message may not represent the opinion of
> Intercontinental Exchange, Inc. (ICE), its subsidiaries or affiliates, and
> does not constitute a contract or guarantee. Unencrypted electronic mail is
> not secure and the recipient of this message is expected to provide
> safeguards from viruses and pursue alternate means of communication where
> privacy or a binding message is desired.

Best Regards,
Xiang Sheng

View raw message