Recommended Suggestions for LLVM

Currently, the LLVM database kernel side is enabled by default, and users can perform related configurations on it. The overall suggestions are as follows:

1. Set an appropriate value for work_mem and set it as great as possible in allowed conditions. If much data is stored in disks, you are advised to disable the LLVM dynamic compilation and optimization by setting enable_codegen to off).
2. To set an appropriate value for codegen_cost_threshold (The default value is 10000). Ensure that LLVM dynamic compilation and optimization is not used when the data volume is small. After the value is set, the database performance deteriorates due to using of LLVM dynamic compilation and optimization. In this scenario, you are advised to increase the parameter value.
3. If a large amount of C- functions are invoked, you are advised not to use the LLVM dynamic compilation and optimization.
   

   If the resource volume is sufficient, the database performance improves with the volume of data larger.