hawq-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Dmitry Buzolin <Dmitry.Buzo...@theice.com>
Subject RE: How to enable/disable ORCA CBO?
Date Tue, 17 Jan 2017 14:51:45 GMT
Thanks All! It worked.

From: Xiang Sheng [mailto:xsheng@pivotal.io]
Sent: Tuesday, January 17, 2017 9:46 AM
To: user@hawq.incubator.apache.org
Subject: Re: How to enable/disable ORCA CBO?

WARNING - External email; exercise caution
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;
 optimizer
-----------
 off
(1 row)

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

Thanks.

On Tue, Jan 17, 2017 at 10:38 PM, Dmitry Buzolin <Dmitry.Buzolin@theice.com<mailto:Dmitry.Buzolin@theice.com>>
wrote:
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

________________________________

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.
Mime
View raw message