A newer version of this documentation is available. Click here to view the most up-to-date release of the Greenplum 4.x documentation.


Sets the amount of memory a Greenplum server instance uses for shared memory buffers. This setting must be at least 128 kilobytes and at least 16 kilobytes times max_connections.

The value of this parameter cannot exceed the value specified by the operating system parameter SHMMAX that specifies the maximum size of shared memory segment that can be allocated. See the Greenplum Database Installation Guide for information about the value for the parameter SHMMAX.

Value Range Default Set Classifications
integer > 16K * max_connections 125MB local