14 Dec

How to improve performance via GPDB code generator ? It does not take effect in my test.


I tried to use GPDB code generator, but no improvement. Here is the detail:
Step1: set parameter to enable codegen
set codegen=1;
set codegen_exec_variable_list=1;
set codegen_slot_getattr=1;
set codegen_exec_eval_expr=1;
set codegen_advance_aggregate=1;

Step2: I run the testcase(TPC-H Query 1) posted on http://engineering.pivotal.io/post/codegen-gpdb-qx/. From the debug log, the code generator was executed successfully. But the performance is not improved at all.

Did I missed something? Could you please help give some suggestion?
Thank you so much.