Engine Configuration
- Log Statement
There are 4 values: none/ddl/mod/all
HENGSHI_HOME=/opt/hengshi
source ${HENGSHI_HOME}/engine-cluster/export-cluster.sh
gpconfig -c log_statement -v mod
gpstop -u
- Memory Limit
The vmem needs to be calculated based on the server's memory and segment_num
VMEM_LIMIT=((SWAP + RAM) - (7.5GB + 0.05 * RAM)) / 1.7 / MAXIMUM_ACTING_PRIMARY_SEGMENTS
HENGSHI_HOME=/opt/hengshi
source ${HENGSHI_HOME}/engine-cluster/export-cluster.sh
gpconfig -c gp_vmem_protect_limit -v $VMEM_LIMIT