Memory-Tuning Resources for Greenplum Database

Products

• VMware Tanzu Greenplum
• Greenplum
• VMware Tanzu Data Suite
• VMware Tanzu Data Suite

Issue/Introduction

This article attempts to consolidate the various nuggets of information pertaining to Greenplum Database (GPDB) memory-tuning references.

Resolution

Checklist:

Resource	Details
Greenplum Virtual Memory Calculator	Provides an Automated value of gp_vmem_protect_limit based on environmental input parameters
Pivotal Greenplum (GPDB) Memory Configuration	Describes common Memory configuration settings providing user with information required to tune memory for optimal query performance
How to Identify Out of Memory (OOM) Errors	OOM ( Out Of Memory ) Errors and Handling resources

Additional Information

Tanzu Greenplum Database (GPDB) all versions