Pivotal Knowledge Base

Follow

Checklist of memory-tuning resources for Pivotal Greenplum

Environment

Product Version
Pivotal Greenplum (GPDB) All Versions

Summary

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

Checklist

Resource Details
Greenplum Virtual Memory Calculator Provides 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
GPDB Shared Memory Allocation Sizes Outlines what is stored in GPDB shared memory and provides a generic way to quantify shared memory usage
OOM ( Out Of Memory ) Errors and Handling resources

 

 

Comments

Powered by Zendesk