Server Configuration Parameters

• Parameter Types and Values describes the parameter data types and values.
• organizes parameters by functionality.

All parameter names are case-insensitive. Every parameter takes a value of one of four types: , integer, floating point, or string. Boolean values may be written as ON, OFF, TRUE, FALSE, YES, NO, 1, 0 (all case-insensitive).

Note: There is no space between the value and the unit names.

Setting Parameters

In Greenplum Database, the master and each segment instance has its own postgresql.conf file (located in their respective data directories). Some parameters are considered local parameters, meaning that each segment instance looks to its own postgresql.conf file to get the value of that parameter. You must set local parameters on every instance in the system (master and segments). Others parameters are considered master parameters. Master parameters need only be set at the master instance.