Greenplum® settings
For Managed Service for Greenplum® clusters, you can configure Greenplum® settings.
The label next to the setting name helps determine which interface is used to set the value of this setting: the management console, CLI, API, SQL, or Terraform. The All interfaces
label means that all of the above interfaces are supported.
Depending on the selected interface, the same setting may be represented in a different way. For example, Max connections in the management console is:
max_connections
in the gRPC APImaxConnections
in the REST API
Settings depending on the storage size
The values of some Greenplum® settings may be automatically adjusted when you change the storage size:
- If the values were not specified or are not suitable for the new size, the default settings for this size will apply.
- If the settings you specified manually are suitable for the new size, they will be preserved.
The settings that depend on the storage size are:
Cluster-level DBMS settings
You can use the following settings:
-
Gp workfile compression
Management console
API
This setting determines whether temporary files created on the disk during a hash connection or hash aggregation will be compressed.
By default, it is disabled, i.e., temporary files are not compressed.
For more information, see the Greenplum® documentation
. -
Gp workfile limits per query
Management console
API
The maximum amount of disk space (in bytes) the temporary files of an active query can occupy in every segment.
The maximum value is
1099511627776
(1 TB), the minimum one is0
(unlimited amount), and the default one is also0
.For more information, see the Greenplum® documentation
. -
Gp workfile limit files per query
Management console
API
The maximum number of temporary files the service creates in a segment to process a single query. If the limit is exceeded, the query will be canceled.
The maximum value is
100000
, the minimum one is0
(unlimited number of temporary files), and the default one is10000
.For more information, see the Greenplum® documentation
. -
Gp workfile limit per segment
Management console
API
The maximum amount of disk space (in bytes) the temporary files of all active queries can occupy in every segment.
The maximum value is
1099511627776
(1 TB), the minimum one is0
(unlimited amount). The default value depends on the segment host storage size and is calculated by the formula:0.1 × <segment_host_storage_size> / <number_of_segments_per_host>
For more information, see the Greenplum® documentation
. -
Log statement
Management console
API
Filter for SQL statements that will be written to the Greenplum® log:
NONE
: The filter is disabled and SQL statements are not logged.DDL
: SQL statements that change data definitions are logged (such asCREATE
,ALTER
, andDROP
).MOD
: SQL statements that fall under theDDL
filter and statements that allow you to change data (INSERT
,UPDATE
,DELETE
,TRUNCATE
, andCOPY FROM
) are logged.ALL
: All SQL statements are logged.
The default value is
ALL
.The
PREPARE
andEXPLAIN ANALYZE
expressions are also logged if they contain the relevant types of commands.For more information, see the Greenplum® documentation
. -
Max connections
Management console
API
The maximum number of simultaneous connections to a master host.
The maximum value is
1000
, the minimum one is250
, and the default one is350
. For segment hosts, this value is automatically multiplied by five.If you increase this value, we recommend increasing Max prepared transactions as well.
For more information, see the Greenplum® documentation
. -
Max prepared transactions
Management console
API
Maximum number of concurrent prepared
transactions.The maximum value is
10000
, the minimum one is350
, and the default one is350
. The values for master hosts and segment hosts are the same.We recommend choosing a value higher than Max connections.
For more information, see the Greenplum® documentation
. -
Max slot wal keep size
Management console
API
The maximum Write-Ahead Log (WAL)
file size in bytes allowed for replication.The minimum value is
0
(no logging), the maximum one is214748364800
(200 GB). The default value depends on the segment host storage size and is calculated by the formula:0.1 × <segment_host_storage_size> / <number_of_segments_per_host>
For more information, see the Greenplum® documentation
. -
Max statement mem
Management console
API
The maximum amount of memory (in bytes) allocated for query processing.
The minimum value is
134217728
(128 MB), the maximum one is1099511627776
(1 TB), and the default one is2097152000
(2000 MB).For more information, see the Greenplum® documentation
.