Thanks All! It worked. From: Xiang Sheng [mailto:[email protected]] Sent: Tuesday, January 17, 2017 9:46 AM To: [email protected] 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 <[email protected]<mailto:[email protected]>> 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.
