THIS IS A TEST INSTANCE. ALL YOUR CHANGES WILL BE LOST!!!!
...
Make sure HAWQ compilation and installation success.
Check if vexecutor.so is installed into HAWQ execution directory. If not, you can execute "make ;make install" in contrib/vexecutor directory to install it.
Add library name "vexectorvexecutor" to "shared_preload_libraries" in postgresql.conf which has to copies allocated in master and segment data directories respectively. Make sure both of them is assigned. (E.g. postgresql.conf: shared_preload_libraries = 'vexectorvexecutor')
Restart HAWQ cluster
Execute "create_udv.sql" with psql. then some vectorized data types and vectorized aggregate functions will be add to HAWQ.
How to remove Vectorized Execution:
- Delete metadata by executing "clean_udv.sql" in psql.
- Remove 'vexectorvexecutor' from shared_preload_libraries in postgresql.conf
- Restart HAWQ cluster
...