Master host memory exhaustion with high memory consumption by psql processes

Products

• VMware Tanzu Greenplum

Issue/Introduction

Master host memory exhaustion while psql processes are failing with the following message:

failed to acquire resources on one or more segments

Cause

Elevated memory consumption by psql processes is generally a result of large resultset data fetching operation.

Resolution

It is recommended to run psql / client application on a non-active host /machine to avoid exhausting master / segment cluster hosts.