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