"Canceling query because of high VMEM usage. Used: xxxMB, available xxxMB" Displayed When Greenplum Is Running SQL Statements

Symptom

Before KAEzip is enabled, the message "Canceling query because of high VMEM usage. Used: xxxMB, available xxxMB" is displayed Greenplum is running SQL statements.

Key Process and Cause Analysis

Greenplum uses the ORCA plugin by default, which may occupy more memory during optimization.

Conclusion and Solution

If a message is displayed indicating that the memory is insufficient or the running of application is slow, while other parameters remain normal, you can disable the query optimizer to reduce the memory usage and improve the application running time.

Set optimizer of Greenplum to off.

gpconfig -c optimizer -v off