Known Issues
To write a rule that performs a Greenplum Database action (gpdb_record
, pg_terminate_backend
, host:throttle_gpdb_query
), the condition must include a session_id
, even when the intended condition is based solely on process information. For example, the following rule appears to terminate any query that uses more than 20% of system memory:
pg_terminate_backend() when host:pid:resident_size_pct > 20
However, because this rule contains no session_id
, Workload Manager cannot infer the query to terminate, and the rule will not be added. To get the desired behavior, add an always-true session_id
condition to the rule, for example:
pg_terminate_backend() when host:pid:program_size_pct > 20
and session_id:host:pid:runtime > 0