Installing GPORCA

GPORCA scales out the planning and optimization capabilities of the traditional Greenplum optimizer. Being scalable, GPORCA achieves better performance in a multi-core environment. GPORCA is used by Greenplum to generate query plans by default.

GPORCA 3.1.0 is recommended for Greenplum 5.11.3, and GPORCA 3.65.3 is recommended for Greenplum 6.0.0. If Greenplum 6.12.1 is installed, you do not need to install GPORCA. This section uses GPORCA 3.1.0 as an example.

1. Go to the directory.

   1	cd /opt/tool

2. Download the GPORCA source code and upload it to /opt/tool.
3. Modify the CStackDescriptor.cpp configuration file.
   1. Open the file.

      1	vim gporca/libgpos/src/common/CStackDescriptor.cpp

   2. Press i to enter the insert mode and comment out line 167.

      

   3. Press Esc, type :wq!, and press Enter to save the file and exit.
4. Compile and install GPORCA.

   1 2 3 4

   mkdir gporca/build cd gporca/build cmake -GNinja .. ninja install

5. Add /usr/local/lib to the /etc/ld.so.conf file.

   1 2 3

   echo /usr/local/lib >> /etc/ld.so.conf echo /usr/local/lib64 >> /etc/ld.so.conf ldconfig