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]> 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
