Managed Service for Greenplum® API, REST: Cluster.list
Retrieves a list of Greenplum® clusters that belong to the specified folder.
HTTP request
GET https://mdb.api.cloud.yandex.net/managed-greenplum/v1/clusters
Query parameters
Parameter | Description |
---|---|
folderId | Required. ID of the folder to list Greenplum® clusters in. To get the folder ID, use a list request. The maximum string length in characters is 50. |
pageSize | The maximum number of results per page to return. If the number of available results is larger than pageSize, the service returns a nextPageToken that can be used to get the next page of results in subsequent list requests. The maximum value is 1000. |
pageToken | Page token. To get the next page of results, set pageToken to the nextPageToken returned by the previous list request. The maximum string length in characters is 100. |
filter | A filter expression that filters resources listed in the response. The expression must specify:
The maximum string length in characters is 1000. |
Response
HTTP Code: 200 - OK
{
"clusters": [
{
"id": "string",
"folderId": "string",
"createdAt": "string",
"name": "string",
"config": {
"version": "string",
"backupWindowStart": {
"hours": "integer",
"minutes": "integer",
"seconds": "integer",
"nanos": "integer"
},
"backupRetainPeriodDays": "integer",
"access": {
"dataLens": true,
"webSql": true,
"dataTransfer": true,
"yandexQuery": true
},
"zoneId": "string",
"subnetId": "string",
"assignPublicIp": true
},
"description": "string",
"labels": "object",
"environment": "string",
"monitoring": [
{
"name": "string",
"description": "string",
"link": "string"
}
],
"masterConfig": {
"resources": {
"resourcePresetId": "string",
"diskSize": "string",
"diskTypeId": "string"
}
},
"segmentConfig": {
"resources": {
"resourcePresetId": "string",
"diskSize": "string",
"diskTypeId": "string"
}
},
"masterHostCount": "string",
"segmentHostCount": "string",
"segmentInHost": "string",
"networkId": "string",
"health": "string",
"status": "string",
"maintenanceWindow": {
// `clusters[].maintenanceWindow` includes only one of the fields `anytime`, `weeklyMaintenanceWindow`
"anytime": {},
"weeklyMaintenanceWindow": {
"day": "string",
"hour": "string"
},
// end of the list of possible fields`clusters[].maintenanceWindow`
},
"plannedOperation": {
"info": "string",
"delayedUntil": "string"
},
"securityGroupIds": [
"string"
],
"userName": "string",
"deletionProtection": true,
"hostGroupIds": [
"string"
],
"clusterConfig": {
"pool": {
"effectiveConfig": {
"mode": "string",
"size": "integer",
"clientIdleTimeout": "integer"
},
"userConfig": {
"mode": "string",
"size": "integer",
"clientIdleTimeout": "integer"
},
"defaultConfig": {
"mode": "string",
"size": "integer",
"clientIdleTimeout": "integer"
}
},
"backgroundActivities": {
"tableSizes": {
"starts": [
{
"hours": "string",
"minutes": "string"
}
]
},
"analyzeAndVacuum": {
"start": {
"hours": "string",
"minutes": "string"
},
"analyzeTimeout": "integer",
"vacuumTimeout": "integer"
},
"queryKillerScripts": {
"idle": {
"enable": true,
"maxAge": "integer",
"ignoreUsers": [
"string"
]
},
"idleInTransaction": {
"enable": true,
"maxAge": "integer",
"ignoreUsers": [
"string"
]
},
"longRunning": {
"enable": true,
"maxAge": "integer",
"ignoreUsers": [
"string"
]
}
}
},
"pxfConfig": {
"effectiveConfig": {
"connectionTimeout": "integer",
"uploadTimeout": "integer",
"maxThreads": "integer",
"poolAllowCoreThreadTimeout": true,
"poolCoreSize": "integer",
"poolQueueCapacity": "integer",
"poolMaxSize": "integer",
"xmx": "integer",
"xms": "integer"
},
"userConfig": {
"connectionTimeout": "integer",
"uploadTimeout": "integer",
"maxThreads": "integer",
"poolAllowCoreThreadTimeout": true,
"poolCoreSize": "integer",
"poolQueueCapacity": "integer",
"poolMaxSize": "integer",
"xmx": "integer",
"xms": "integer"
},
"defaultConfig": {
"connectionTimeout": "integer",
"uploadTimeout": "integer",
"maxThreads": "integer",
"poolAllowCoreThreadTimeout": true,
"poolCoreSize": "integer",
"poolQueueCapacity": "integer",
"poolMaxSize": "integer",
"xmx": "integer",
"xms": "integer"
}
},
// `clusters[].clusterConfig` includes only one of the fields `greenplumConfigSet_6_17`, `greenplumConfigSet_6_19`, `greenplumConfigSet_6_21`, `greenplumConfigSet_6_22`, `greenplumConfigSet_6`
"greenplumConfigSet_6_17": {
"effectiveConfig": {
"maxConnections": "integer",
"maxSlotWalKeepSize": "integer",
"gpWorkfileLimitPerSegment": "integer",
"gpWorkfileLimitPerQuery": "integer",
"gpWorkfileLimitFilesPerQuery": "integer",
"maxPreparedTransactions": "integer",
"gpWorkfileCompression": true
},
"userConfig": {
"maxConnections": "integer",
"maxSlotWalKeepSize": "integer",
"gpWorkfileLimitPerSegment": "integer",
"gpWorkfileLimitPerQuery": "integer",
"gpWorkfileLimitFilesPerQuery": "integer",
"maxPreparedTransactions": "integer",
"gpWorkfileCompression": true
},
"defaultConfig": {
"maxConnections": "integer",
"maxSlotWalKeepSize": "integer",
"gpWorkfileLimitPerSegment": "integer",
"gpWorkfileLimitPerQuery": "integer",
"gpWorkfileLimitFilesPerQuery": "integer",
"maxPreparedTransactions": "integer",
"gpWorkfileCompression": true
}
},
"greenplumConfigSet_6_19": {
"effectiveConfig": {
"maxConnections": "integer",
"maxSlotWalKeepSize": "integer",
"gpWorkfileLimitPerSegment": "integer",
"gpWorkfileLimitPerQuery": "integer",
"gpWorkfileLimitFilesPerQuery": "integer",
"maxPreparedTransactions": "integer",
"gpWorkfileCompression": true,
"maxStatementMem": "integer",
"logStatement": "string"
},
"userConfig": {
"maxConnections": "integer",
"maxSlotWalKeepSize": "integer",
"gpWorkfileLimitPerSegment": "integer",
"gpWorkfileLimitPerQuery": "integer",
"gpWorkfileLimitFilesPerQuery": "integer",
"maxPreparedTransactions": "integer",
"gpWorkfileCompression": true,
"maxStatementMem": "integer",
"logStatement": "string"
},
"defaultConfig": {
"maxConnections": "integer",
"maxSlotWalKeepSize": "integer",
"gpWorkfileLimitPerSegment": "integer",
"gpWorkfileLimitPerQuery": "integer",
"gpWorkfileLimitFilesPerQuery": "integer",
"maxPreparedTransactions": "integer",
"gpWorkfileCompression": true,
"maxStatementMem": "integer",
"logStatement": "string"
}
},
"greenplumConfigSet_6_21": {
"effectiveConfig": {
"maxConnections": "integer",
"maxSlotWalKeepSize": "integer",
"gpWorkfileLimitPerSegment": "integer",
"gpWorkfileLimitPerQuery": "integer",
"gpWorkfileLimitFilesPerQuery": "integer",
"maxPreparedTransactions": "integer",
"gpWorkfileCompression": true,
"maxStatementMem": "integer",
"logStatement": "string",
"gpAddColumnInheritsTableSetting": true
},
"userConfig": {
"maxConnections": "integer",
"maxSlotWalKeepSize": "integer",
"gpWorkfileLimitPerSegment": "integer",
"gpWorkfileLimitPerQuery": "integer",
"gpWorkfileLimitFilesPerQuery": "integer",
"maxPreparedTransactions": "integer",
"gpWorkfileCompression": true,
"maxStatementMem": "integer",
"logStatement": "string",
"gpAddColumnInheritsTableSetting": true
},
"defaultConfig": {
"maxConnections": "integer",
"maxSlotWalKeepSize": "integer",
"gpWorkfileLimitPerSegment": "integer",
"gpWorkfileLimitPerQuery": "integer",
"gpWorkfileLimitFilesPerQuery": "integer",
"maxPreparedTransactions": "integer",
"gpWorkfileCompression": true,
"maxStatementMem": "integer",
"logStatement": "string",
"gpAddColumnInheritsTableSetting": true
}
},
"greenplumConfigSet_6_22": {
"effectiveConfig": {
"maxConnections": "integer",
"maxSlotWalKeepSize": "integer",
"gpWorkfileLimitPerSegment": "integer",
"gpWorkfileLimitPerQuery": "integer",
"gpWorkfileLimitFilesPerQuery": "integer",
"maxPreparedTransactions": "integer",
"gpWorkfileCompression": true,
"maxStatementMem": "integer",
"logStatement": "string",
"gpAddColumnInheritsTableSetting": true
},
"userConfig": {
"maxConnections": "integer",
"maxSlotWalKeepSize": "integer",
"gpWorkfileLimitPerSegment": "integer",
"gpWorkfileLimitPerQuery": "integer",
"gpWorkfileLimitFilesPerQuery": "integer",
"maxPreparedTransactions": "integer",
"gpWorkfileCompression": true,
"maxStatementMem": "integer",
"logStatement": "string",
"gpAddColumnInheritsTableSetting": true
},
"defaultConfig": {
"maxConnections": "integer",
"maxSlotWalKeepSize": "integer",
"gpWorkfileLimitPerSegment": "integer",
"gpWorkfileLimitPerQuery": "integer",
"gpWorkfileLimitFilesPerQuery": "integer",
"maxPreparedTransactions": "integer",
"gpWorkfileCompression": true,
"maxStatementMem": "integer",
"logStatement": "string",
"gpAddColumnInheritsTableSetting": true
}
},
"greenplumConfigSet_6": {
"effectiveConfig": {
"maxConnections": "integer",
"maxSlotWalKeepSize": "integer",
"gpWorkfileLimitPerSegment": "integer",
"gpWorkfileLimitPerQuery": "integer",
"gpWorkfileLimitFilesPerQuery": "integer",
"maxPreparedTransactions": "integer",
"gpWorkfileCompression": true,
"maxStatementMem": "integer",
"logStatement": "string",
"gpAddColumnInheritsTableSetting": true
},
"userConfig": {
"maxConnections": "integer",
"maxSlotWalKeepSize": "integer",
"gpWorkfileLimitPerSegment": "integer",
"gpWorkfileLimitPerQuery": "integer",
"gpWorkfileLimitFilesPerQuery": "integer",
"maxPreparedTransactions": "integer",
"gpWorkfileCompression": true,
"maxStatementMem": "integer",
"logStatement": "string",
"gpAddColumnInheritsTableSetting": true
},
"defaultConfig": {
"maxConnections": "integer",
"maxSlotWalKeepSize": "integer",
"gpWorkfileLimitPerSegment": "integer",
"gpWorkfileLimitPerQuery": "integer",
"gpWorkfileLimitFilesPerQuery": "integer",
"maxPreparedTransactions": "integer",
"gpWorkfileCompression": true,
"maxStatementMem": "integer",
"logStatement": "string",
"gpAddColumnInheritsTableSetting": true
}
},
// end of the list of possible fields`clusters[].clusterConfig`
},
"cloudStorage": {
"enable": true
},
"masterHostGroupIds": [
"string"
],
"segmentHostGroupIds": [
"string"
]
}
],
"nextPageToken": "string"
}
Field | Description |
---|---|
clusters[] | object List of Greenplum® cluster resources. |
clusters[]. id |
string ID of the Greenplum® cluster. This ID is assigned by the platform at the moment of cluster creation. |
clusters[]. folderId |
string ID of the folder that the Greenplum® cluster belongs to. |
clusters[]. createdAt |
string (date-time) Time when the cluster was created. String in RFC3339 text format. The range of possible values is from To work with values in this field, use the APIs described in the Protocol Buffers reference. In some languages, built-in datetime utilities do not support nanosecond precision (9 digits). |
clusters[]. name |
string Required. Name of the Greenplum® cluster. The name is unique within the folder. The maximum string length in characters is 63. |
clusters[]. config |
object Greenplum® cluster configuration. |
clusters[]. config. version |
string Version of the Greenplum® server software. |
clusters[]. config. backupWindowStart |
object Time to start the daily backup, in the UTC timezone. Represents a time of day. The date and time zone are either not significant or are specified elsewhere. An API may choose to allow leap seconds. Related types are google.type.Date and google.protobuf.Timestamp. |
clusters[]. config. backupWindowStart. hours |
integer (int32) Hours of day in 24 hour format. Should be from 0 to 23. An API may choose to allow the value "24:00:00" for scenarios like business closing time. |
clusters[]. config. backupWindowStart. minutes |
integer (int32) Minutes of hour of day. Must be from 0 to 59. |
clusters[]. config. backupWindowStart. seconds |
integer (int32) Seconds of minutes of the time. Must normally be from 0 to 59. An API may allow the value 60 if it allows leap-seconds. |
clusters[]. config. backupWindowStart. nanos |
integer (int32) Fractions of seconds in nanoseconds. Must be from 0 to 999,999,999. |
clusters[]. config. backupRetainPeriodDays |
integer (int64) Retention policy of automated backups. Acceptable values are 1 to 60, inclusive. |
clusters[]. config. access |
object Access policy for external services. |
clusters[]. config. access. dataLens |
boolean (boolean) Allows data export from the cluster to DataLens. |
clusters[]. config. access. webSql |
boolean (boolean) Allows SQL queries to the cluster databases from the management console. |
clusters[]. config. access. dataTransfer |
boolean (boolean) Allows access for DataTransfer. |
clusters[]. config. access. yandexQuery |
boolean (boolean) Allow access for YandexQuery. |
clusters[]. config. zoneId |
string ID of the availability zone the cluster belongs to. To get a list of available zones, use the list request. The maximum string length in characters is 50. |
clusters[]. config. subnetId |
string ID of the subnet the cluster belongs to. This subnet should be a part of the cloud network the cluster belongs to (see Cluster.networkId). The maximum string length in characters is 50. |
clusters[]. config. assignPublicIp |
boolean (boolean) Determines whether the cluster has a public IP address. After the cluster has been created, this setting cannot be changed. |
clusters[]. description |
string Description of the Greenplum® cluster. The maximum string length in characters is 256. |
clusters[]. labels |
object Custom labels for the Greenplum® cluster as |
clusters[]. environment |
string Deployment environment of the Greenplum® cluster.
|
clusters[]. monitoring[] |
object Description of monitoring systems relevant to the Greenplum® cluster. |
clusters[]. monitoring[]. name |
string Name of the monitoring system. |
clusters[]. monitoring[]. description |
string Description of the monitoring system. |
clusters[]. monitoring[]. link |
string Link to the monitoring system charts for the Greenplum® cluster. |
clusters[]. masterConfig |
object Configuration of the Greenplum® master subcluster. |
clusters[]. masterConfig. resources |
object Computational resources allocated to Greenplum® master subcluster hosts. |
clusters[]. masterConfig. resources. resourcePresetId |
string ID of the preset for computational resources allocated to a host. Available presets are listed in the documentation. |
clusters[]. masterConfig. resources. diskSize |
string (int64) Volume of the storage used by the host, in bytes. |
clusters[]. masterConfig. resources. diskTypeId |
string Type of the storage used by the host: |
clusters[]. segmentConfig |
object Configuration of the Greenplum® segment subcluster. |
clusters[]. segmentConfig. resources |
object Computational resources allocated to Greenplum® segment subcluster hosts. |
clusters[]. segmentConfig. resources. resourcePresetId |
string ID of the preset for computational resources allocated to a host. Available presets are listed in the documentation. |
clusters[]. segmentConfig. resources. diskSize |
string (int64) Volume of the storage used by the host, in bytes. |
clusters[]. segmentConfig. resources. diskTypeId |
string Type of the storage used by the host: |
clusters[]. masterHostCount |
string (int64) Number of hosts in the master subcluster. |
clusters[]. segmentHostCount |
string (int64) Number of hosts in the segment subcluster. |
clusters[]. segmentInHost |
string (int64) Number of segments per host. |
clusters[]. networkId |
string ID of the cloud network that the cluster belongs to. |
clusters[]. health |
string Aggregated cluster health.
|
clusters[]. status |
string Current state of the cluster.
|
clusters[]. maintenanceWindow |
object A Greenplum® cluster maintenance window. Should be defined by either one of the two options. |
clusters[]. maintenanceWindow. anytime |
object An any-time maintenance window. clusters[].maintenanceWindow includes only one of the fields anytime , weeklyMaintenanceWindow |
clusters[]. maintenanceWindow. weeklyMaintenanceWindow |
object A weekly maintenance window. clusters[].maintenanceWindow includes only one of the fields anytime , weeklyMaintenanceWindow |
clusters[]. maintenanceWindow. weeklyMaintenanceWindow. day |
string Day of the week.
|
clusters[]. maintenanceWindow. weeklyMaintenanceWindow. hour |
string (int64) Hour of the day in the UTC timezone. Acceptable values are 1 to 24, inclusive. |
clusters[]. plannedOperation |
object Maintenance operation planned at nearest maintenanceWindow. |
clusters[]. plannedOperation. info |
string The description of the operation. The maximum string length in characters is 256. |
clusters[]. plannedOperation. delayedUntil |
string (date-time) Delay time for the maintenance operation. String in RFC3339 text format. The range of possible values is from To work with values in this field, use the APIs described in the Protocol Buffers reference. In some languages, built-in datetime utilities do not support nanosecond precision (9 digits). |
clusters[]. securityGroupIds[] |
string User security groups. |
clusters[]. userName |
string Owner user name. |
clusters[]. deletionProtection |
boolean (boolean) Determines whether the cluster is protected from being deleted. |
clusters[]. hostGroupIds[] |
string Host groups hosting VMs of the cluster. |
clusters[]. clusterConfig |
object Greenplum® and Odyssey® configuration. |
clusters[]. clusterConfig. pool |
object Odyssey® pool settings. |
clusters[]. clusterConfig. pool. effectiveConfig |
object Required. Effective settings for an Odyssey® pooler (a combination of settings defined in |
clusters[]. clusterConfig. pool. effectiveConfig. mode |
string Route server pool mode.
|
clusters[]. clusterConfig. pool. effectiveConfig. size |
integer (int64) The number of servers in the server pool. Clients are placed in a wait queue when all servers are busy. Set to zero to disable the limit. |
clusters[]. clusterConfig. pool. effectiveConfig. clientIdleTimeout |
integer (int64) Server pool idle timeout, in seconds. A server connection closes after being idle for the specified time. Set to zero to disable the limit. |
clusters[]. clusterConfig. pool. userConfig |
object User-defined settings for an Odyssey® pooler. |
clusters[]. clusterConfig. pool. userConfig. mode |
string Route server pool mode.
|
clusters[]. clusterConfig. pool. userConfig. size |
integer (int64) The number of servers in the server pool. Clients are placed in a wait queue when all servers are busy. Set to zero to disable the limit. |
clusters[]. clusterConfig. pool. userConfig. clientIdleTimeout |
integer (int64) Server pool idle timeout, in seconds. A server connection closes after being idle for the specified time. Set to zero to disable the limit. |
clusters[]. clusterConfig. pool. defaultConfig |
object Default configuration for an Odyssey® pooler. |
clusters[]. clusterConfig. pool. defaultConfig. mode |
string Route server pool mode.
|
clusters[]. clusterConfig. pool. defaultConfig. size |
integer (int64) The number of servers in the server pool. Clients are placed in a wait queue when all servers are busy. Set to zero to disable the limit. |
clusters[]. clusterConfig. pool. defaultConfig. clientIdleTimeout |
integer (int64) Server pool idle timeout, in seconds. A server connection closes after being idle for the specified time. Set to zero to disable the limit. |
clusters[]. clusterConfig. backgroundActivities |
object Managed Greenplum® background tasks configuration. |
clusters[]. clusterConfig. backgroundActivities. tableSizes |
object Enables scripts that collects tables sizes to |
clusters[]. clusterConfig. backgroundActivities. tableSizes. starts[] |
object The maximum number of elements is 4. |
clusters[]. clusterConfig. backgroundActivities. tableSizes. starts[]. hours |
string (int64) Acceptable values are 0 to 23, inclusive. |
clusters[]. clusterConfig. backgroundActivities. tableSizes. starts[]. minutes |
string (int64) Acceptable values are 0 to 59, inclusive. |
clusters[]. clusterConfig. backgroundActivities. analyzeAndVacuum |
object Configuration for |
clusters[]. clusterConfig. backgroundActivities. analyzeAndVacuum. start |
object |
clusters[]. clusterConfig. backgroundActivities. analyzeAndVacuum. start. hours |
string (int64) Acceptable values are 0 to 23, inclusive. |
clusters[]. clusterConfig. backgroundActivities. analyzeAndVacuum. start. minutes |
string (int64) Acceptable values are 0 to 59, inclusive. |
clusters[]. clusterConfig. backgroundActivities. analyzeAndVacuum. analyzeTimeout |
integer (int64) Maximum duration of the Acceptable values are 7200 to 86399, inclusive. |
clusters[]. clusterConfig. backgroundActivities. analyzeAndVacuum. vacuumTimeout |
integer (int64) Maximum duration of the Acceptable values are 7200 to 86399, inclusive. |
clusters[]. clusterConfig. backgroundActivities. queryKillerScripts |
object Configuration for long running queries killer. |
clusters[]. clusterConfig. backgroundActivities. queryKillerScripts. idle |
object Configuration of script that kills long running queries that are in |
clusters[]. clusterConfig. backgroundActivities. queryKillerScripts. idle. enable |
boolean (boolean) |
clusters[]. clusterConfig. backgroundActivities. queryKillerScripts. idle. maxAge |
integer (int64) Maximum duration for this type of queries (in seconds). Acceptable values are 1 to 86400, inclusive. |
clusters[]. clusterConfig. backgroundActivities. queryKillerScripts. idle. ignoreUsers[] |
string Ignore these users when considering queries to terminate |
clusters[]. clusterConfig. backgroundActivities. queryKillerScripts. idleInTransaction |
object Configuration of script that kills long running queries that are in |
clusters[]. clusterConfig. backgroundActivities. queryKillerScripts. idleInTransaction. enable |
boolean (boolean) |
clusters[]. clusterConfig. backgroundActivities. queryKillerScripts. idleInTransaction. maxAge |
integer (int64) Maximum duration for this type of queries (in seconds). Acceptable values are 1 to 86400, inclusive. |
clusters[]. clusterConfig. backgroundActivities. queryKillerScripts. idleInTransaction. ignoreUsers[] |
string Ignore these users when considering queries to terminate |
clusters[]. clusterConfig. backgroundActivities. queryKillerScripts. longRunning |
object Configuration of script that kills long running queries (in any state). |
clusters[]. clusterConfig. backgroundActivities. queryKillerScripts. longRunning. enable |
boolean (boolean) |
clusters[]. clusterConfig. backgroundActivities. queryKillerScripts. longRunning. maxAge |
integer (int64) Maximum duration for this type of queries (in seconds). Acceptable values are 1 to 86400, inclusive. |
clusters[]. clusterConfig. backgroundActivities. queryKillerScripts. longRunning. ignoreUsers[] |
string Ignore these users when considering queries to terminate |
clusters[]. clusterConfig. pxfConfig |
object |
clusters[]. clusterConfig. pxfConfig. effectiveConfig |
object Required. |
clusters[]. clusterConfig. pxfConfig. effectiveConfig. connectionTimeout |
integer (int64) Timeout for connection to the Apache Tomcat® server when making read requests. Specify values in seconds. Acceptable values are 5 to 600, inclusive. |
clusters[]. clusterConfig. pxfConfig. effectiveConfig. uploadTimeout |
integer (int64) Timeout for connection to the Apache Tomcat® server when making write requests. Specify the values in seconds. Acceptable values are 5 to 600, inclusive. |
clusters[]. clusterConfig. pxfConfig. effectiveConfig. maxThreads |
integer (int64) Maximum number of the Apache Tomcat® threads. To prevent situations when requests get stuck or fail due to running out of memory or malfunctioning of the Java garbage collector, specify the number of the Apache Tomcat® threads. Learn more about adjusting the number of threads in the VMware Greenplum® Platform Extension Framework documentation. Acceptable values are 1 to 1024, inclusive. |
clusters[]. clusterConfig. pxfConfig. effectiveConfig. poolAllowCoreThreadTimeout |
boolean (boolean) Determines whether the timeout for core streaming threads is permitted. |
clusters[]. clusterConfig. pxfConfig. effectiveConfig. poolCoreSize |
integer (int64) Number of core streaming threads per pool. Acceptable values are 1 to 1024, inclusive. |
clusters[]. clusterConfig. pxfConfig. effectiveConfig. poolQueueCapacity |
integer (int64) Maximum number of requests you can add to a pool queue for core streaming threads. If The minimum value is 0. |
clusters[]. clusterConfig. pxfConfig. effectiveConfig. poolMaxSize |
integer (int64) Maximum allowed number of core streaming threads. Acceptable values are 1 to 1024, inclusive. |
clusters[]. clusterConfig. pxfConfig. effectiveConfig. xmx |
integer (int64) Initial size, in megabytes, of the JVM heap for the PXF daemon. The minimum value is 64. |
clusters[]. clusterConfig. pxfConfig. effectiveConfig. xms |
integer (int64) Maximum size, in megabytes, of the JVM heap for the PXF daemon. The minimum value is 64. |
clusters[]. clusterConfig. pxfConfig. userConfig |
object User-defined settings. |
clusters[]. clusterConfig. pxfConfig. userConfig. connectionTimeout |
integer (int64) Timeout for connection to the Apache Tomcat® server when making read requests. Specify values in seconds. Acceptable values are 5 to 600, inclusive. |
clusters[]. clusterConfig. pxfConfig. userConfig. uploadTimeout |
integer (int64) Timeout for connection to the Apache Tomcat® server when making write requests. Specify the values in seconds. Acceptable values are 5 to 600, inclusive. |
clusters[]. clusterConfig. pxfConfig. userConfig. maxThreads |
integer (int64) Maximum number of the Apache Tomcat® threads. To prevent situations when requests get stuck or fail due to running out of memory or malfunctioning of the Java garbage collector, specify the number of the Apache Tomcat® threads. Learn more about adjusting the number of threads in the VMware Greenplum® Platform Extension Framework documentation. Acceptable values are 1 to 1024, inclusive. |
clusters[]. clusterConfig. pxfConfig. userConfig. poolAllowCoreThreadTimeout |
boolean (boolean) Determines whether the timeout for core streaming threads is permitted. |
clusters[]. clusterConfig. pxfConfig. userConfig. poolCoreSize |
integer (int64) Number of core streaming threads per pool. Acceptable values are 1 to 1024, inclusive. |
clusters[]. clusterConfig. pxfConfig. userConfig. poolQueueCapacity |
integer (int64) Maximum number of requests you can add to a pool queue for core streaming threads. If The minimum value is 0. |
clusters[]. clusterConfig. pxfConfig. userConfig. poolMaxSize |
integer (int64) Maximum allowed number of core streaming threads. Acceptable values are 1 to 1024, inclusive. |
clusters[]. clusterConfig. pxfConfig. userConfig. xmx |
integer (int64) Initial size, in megabytes, of the JVM heap for the PXF daemon. The minimum value is 64. |
clusters[]. clusterConfig. pxfConfig. userConfig. xms |
integer (int64) Maximum size, in megabytes, of the JVM heap for the PXF daemon. The minimum value is 64. |
clusters[]. clusterConfig. pxfConfig. defaultConfig |
object Default configuration. |
clusters[]. clusterConfig. pxfConfig. defaultConfig. connectionTimeout |
integer (int64) Timeout for connection to the Apache Tomcat® server when making read requests. Specify values in seconds. Acceptable values are 5 to 600, inclusive. |
clusters[]. clusterConfig. pxfConfig. defaultConfig. uploadTimeout |
integer (int64) Timeout for connection to the Apache Tomcat® server when making write requests. Specify the values in seconds. Acceptable values are 5 to 600, inclusive. |
clusters[]. clusterConfig. pxfConfig. defaultConfig. maxThreads |
integer (int64) Maximum number of the Apache Tomcat® threads. To prevent situations when requests get stuck or fail due to running out of memory or malfunctioning of the Java garbage collector, specify the number of the Apache Tomcat® threads. Learn more about adjusting the number of threads in the VMware Greenplum® Platform Extension Framework documentation. Acceptable values are 1 to 1024, inclusive. |
clusters[]. clusterConfig. pxfConfig. defaultConfig. poolAllowCoreThreadTimeout |
boolean (boolean) Determines whether the timeout for core streaming threads is permitted. |
clusters[]. clusterConfig. pxfConfig. defaultConfig. poolCoreSize |
integer (int64) Number of core streaming threads per pool. Acceptable values are 1 to 1024, inclusive. |
clusters[]. clusterConfig. pxfConfig. defaultConfig. poolQueueCapacity |
integer (int64) Maximum number of requests you can add to a pool queue for core streaming threads. If The minimum value is 0. |
clusters[]. clusterConfig. pxfConfig. defaultConfig. poolMaxSize |
integer (int64) Maximum allowed number of core streaming threads. Acceptable values are 1 to 1024, inclusive. |
clusters[]. clusterConfig. pxfConfig. defaultConfig. xmx |
integer (int64) Initial size, in megabytes, of the JVM heap for the PXF daemon. The minimum value is 64. |
clusters[]. clusterConfig. pxfConfig. defaultConfig. xms |
integer (int64) Maximum size, in megabytes, of the JVM heap for the PXF daemon. The minimum value is 64. |
clusters[]. clusterConfig. greenplumConfigSet_6_17 |
object clusters[].clusterConfig includes only one of the fields greenplumConfigSet_6_17 , greenplumConfigSet_6_19 , greenplumConfigSet_6_21 , greenplumConfigSet_6_22 , greenplumConfigSet_6 Configuration settings version 6.17 |
clusters[]. clusterConfig. greenplumConfigSet_6_17. effectiveConfig |
object Required. Effective settings for a Greenplum® cluster (a combination of settings defined in |
clusters[]. clusterConfig. greenplumConfigSet_6_17. effectiveConfig. maxConnections |
integer (int64) Maximum number of inbound connections on master segment. |
clusters[]. clusterConfig. greenplumConfigSet_6_17. effectiveConfig. maxSlotWalKeepSize |
integer (int64) The maximum size of WAL files that replication slots are allowed to retain in the More info in PostgreSQL® documentation. |
clusters[]. clusterConfig. greenplumConfigSet_6_17. effectiveConfig. gpWorkfileLimitPerSegment |
integer (int64) The maximum total disk size that all running queries are allowed to use for creating temporary spill files at each segment. The default value is 0 (no limit). More info in Greenplum® documentation. |
clusters[]. clusterConfig. greenplumConfigSet_6_17. effectiveConfig. gpWorkfileLimitPerQuery |
integer (int64) The maximum disk size that an individual query is allowed to use for creating temporary spill files at each segment. The default value is 0 (no limit). More info in Greenplum® documentation. |
clusters[]. clusterConfig. greenplumConfigSet_6_17. effectiveConfig. gpWorkfileLimitFilesPerQuery |
integer (int64) The maximum number of temporary spill files allowed per query at each segment. Spill files, also known as workfiles, are created when a query requires more memory than there is allocated. The current query is terminated if the limit is exceeded. Set to zero to disable the limit. Master session reloads if the parameter changes. Default value is 10000. More info in Greenplum® documentation. |
clusters[]. clusterConfig. greenplumConfigSet_6_17. effectiveConfig. maxPreparedTransactions |
integer (int64) The maximum number of transactions that can be in the More info in PostgreSQL® documentation. |
clusters[]. clusterConfig. greenplumConfigSet_6_17. effectiveConfig. gpWorkfileCompression |
boolean (boolean) Whether the spill files are compressed or not. More info in Greenplum® documentation. |
clusters[]. clusterConfig. greenplumConfigSet_6_17. userConfig |
object User-defined settings for a Greenplum® cluster. |
clusters[]. clusterConfig. greenplumConfigSet_6_17. userConfig. maxConnections |
integer (int64) Maximum number of inbound connections on master segment. |
clusters[]. clusterConfig. greenplumConfigSet_6_17. userConfig. maxSlotWalKeepSize |
integer (int64) The maximum size of WAL files that replication slots are allowed to retain in the More info in PostgreSQL® documentation. |
clusters[]. clusterConfig. greenplumConfigSet_6_17. userConfig. gpWorkfileLimitPerSegment |
integer (int64) The maximum total disk size that all running queries are allowed to use for creating temporary spill files at each segment. The default value is 0 (no limit). More info in Greenplum® documentation. |
clusters[]. clusterConfig. greenplumConfigSet_6_17. userConfig. gpWorkfileLimitPerQuery |
integer (int64) The maximum disk size that an individual query is allowed to use for creating temporary spill files at each segment. The default value is 0 (no limit). More info in Greenplum® documentation. |
clusters[]. clusterConfig. greenplumConfigSet_6_17. userConfig. gpWorkfileLimitFilesPerQuery |
integer (int64) The maximum number of temporary spill files allowed per query at each segment. Spill files, also known as workfiles, are created when a query requires more memory than there is allocated. The current query is terminated if the limit is exceeded. Set to zero to disable the limit. Master session reloads if the parameter changes. Default value is 10000. More info in Greenplum® documentation. |
clusters[]. clusterConfig. greenplumConfigSet_6_17. userConfig. maxPreparedTransactions |
integer (int64) The maximum number of transactions that can be in the More info in PostgreSQL® documentation. |
clusters[]. clusterConfig. greenplumConfigSet_6_17. userConfig. gpWorkfileCompression |
boolean (boolean) Whether the spill files are compressed or not. More info in Greenplum® documentation. |
clusters[]. clusterConfig. greenplumConfigSet_6_17. defaultConfig |
object Default configuration for a Greenplum® cluster. |
clusters[]. clusterConfig. greenplumConfigSet_6_17. defaultConfig. maxConnections |
integer (int64) Maximum number of inbound connections on master segment. |
clusters[]. clusterConfig. greenplumConfigSet_6_17. defaultConfig. maxSlotWalKeepSize |
integer (int64) The maximum size of WAL files that replication slots are allowed to retain in the More info in PostgreSQL® documentation. |
clusters[]. clusterConfig. greenplumConfigSet_6_17. defaultConfig. gpWorkfileLimitPerSegment |
integer (int64) The maximum total disk size that all running queries are allowed to use for creating temporary spill files at each segment. The default value is 0 (no limit). More info in Greenplum® documentation. |
clusters[]. clusterConfig. greenplumConfigSet_6_17. defaultConfig. gpWorkfileLimitPerQuery |
integer (int64) The maximum disk size that an individual query is allowed to use for creating temporary spill files at each segment. The default value is 0 (no limit). More info in Greenplum® documentation. |
clusters[]. clusterConfig. greenplumConfigSet_6_17. defaultConfig. gpWorkfileLimitFilesPerQuery |
integer (int64) The maximum number of temporary spill files allowed per query at each segment. Spill files, also known as workfiles, are created when a query requires more memory than there is allocated. The current query is terminated if the limit is exceeded. Set to zero to disable the limit. Master session reloads if the parameter changes. Default value is 10000. More info in Greenplum® documentation. |
clusters[]. clusterConfig. greenplumConfigSet_6_17. defaultConfig. maxPreparedTransactions |
integer (int64) The maximum number of transactions that can be in the More info in PostgreSQL® documentation. |
clusters[]. clusterConfig. greenplumConfigSet_6_17. defaultConfig. gpWorkfileCompression |
boolean (boolean) Whether the spill files are compressed or not. More info in Greenplum® documentation. |
clusters[]. clusterConfig. greenplumConfigSet_6_19 |
object clusters[].clusterConfig includes only one of the fields greenplumConfigSet_6_17 , greenplumConfigSet_6_19 , greenplumConfigSet_6_21 , greenplumConfigSet_6_22 , greenplumConfigSet_6 Configuration settings version 6.19 |
clusters[]. clusterConfig. greenplumConfigSet_6_19. effectiveConfig |
object Required. Effective settings for a Greenplum® cluster (a combination of settings defined in |
clusters[]. clusterConfig. greenplumConfigSet_6_19. effectiveConfig. maxConnections |
integer (int64) Maximum number of inbound connections on master segment. |
clusters[]. clusterConfig. greenplumConfigSet_6_19. effectiveConfig. maxSlotWalKeepSize |
integer (int64) The maximum size of WAL files that replication slots are allowed to retain in the More info in PostgreSQL® documentation. |
clusters[]. clusterConfig. greenplumConfigSet_6_19. effectiveConfig. gpWorkfileLimitPerSegment |
integer (int64) The maximum total disk size that all running queries are allowed to use for creating temporary spill files at each segment. The default value is 0 (no limit). More info in Greenplum® documentation. |
clusters[]. clusterConfig. greenplumConfigSet_6_19. effectiveConfig. gpWorkfileLimitPerQuery |
integer (int64) The maximum disk size that an individual query is allowed to use for creating temporary spill files at each segment. The default value is 0 (no limit). More info in Greenplum® documentation. |
clusters[]. clusterConfig. greenplumConfigSet_6_19. effectiveConfig. gpWorkfileLimitFilesPerQuery |
integer (int64) The maximum number of temporary spill files allowed per query at each segment. Spill files, also known as workfiles, are created when a query requires more memory than there is allocated. The current query is terminated if the limit is exceeded. Set to zero to disable the limit. Master session reloads if the parameter changes. Default value is 10000. More info in Greenplum® documentation. |
clusters[]. clusterConfig. greenplumConfigSet_6_19. effectiveConfig. maxPreparedTransactions |
integer (int64) The maximum number of transactions that can be in the More info in PostgreSQL® documentation. |
clusters[]. clusterConfig. greenplumConfigSet_6_19. effectiveConfig. gpWorkfileCompression |
boolean (boolean) Whether the spill files are compressed or not. More info in Greenplum® documentation. |
clusters[]. clusterConfig. greenplumConfigSet_6_19. effectiveConfig. maxStatementMem |
integer (int64) The maximum memory limit for a query, in bytes. Helps to avoid out-of-memory errors on a segment host during query processing as a result of setting Taking into account the configuration of a single segment host, calculate When changing both Default value is 2097152000 (2000 MB). More info in Greenplum® documentation. |
clusters[]. clusterConfig. greenplumConfigSet_6_19. effectiveConfig. logStatement |
string Logged SQL statements.
More info in Greenplum® documentation.
|
clusters[]. clusterConfig. greenplumConfigSet_6_19. userConfig |
object User-defined settings for a Greenplum® cluster. |
clusters[]. clusterConfig. greenplumConfigSet_6_19. userConfig. maxConnections |
integer (int64) Maximum number of inbound connections on master segment. |
clusters[]. clusterConfig. greenplumConfigSet_6_19. userConfig. maxSlotWalKeepSize |
integer (int64) The maximum size of WAL files that replication slots are allowed to retain in the More info in PostgreSQL® documentation. |
clusters[]. clusterConfig. greenplumConfigSet_6_19. userConfig. gpWorkfileLimitPerSegment |
integer (int64) The maximum total disk size that all running queries are allowed to use for creating temporary spill files at each segment. The default value is 0 (no limit). More info in Greenplum® documentation. |
clusters[]. clusterConfig. greenplumConfigSet_6_19. userConfig. gpWorkfileLimitPerQuery |
integer (int64) The maximum disk size that an individual query is allowed to use for creating temporary spill files at each segment. The default value is 0 (no limit). More info in Greenplum® documentation. |
clusters[]. clusterConfig. greenplumConfigSet_6_19. userConfig. gpWorkfileLimitFilesPerQuery |
integer (int64) The maximum number of temporary spill files allowed per query at each segment. Spill files, also known as workfiles, are created when a query requires more memory than there is allocated. The current query is terminated if the limit is exceeded. Set to zero to disable the limit. Master session reloads if the parameter changes. Default value is 10000. More info in Greenplum® documentation. |
clusters[]. clusterConfig. greenplumConfigSet_6_19. userConfig. maxPreparedTransactions |
integer (int64) The maximum number of transactions that can be in the More info in PostgreSQL® documentation. |
clusters[]. clusterConfig. greenplumConfigSet_6_19. userConfig. gpWorkfileCompression |
boolean (boolean) Whether the spill files are compressed or not. More info in Greenplum® documentation. |
clusters[]. clusterConfig. greenplumConfigSet_6_19. userConfig. maxStatementMem |
integer (int64) The maximum memory limit for a query, in bytes. Helps to avoid out-of-memory errors on a segment host during query processing as a result of setting Taking into account the configuration of a single segment host, calculate When changing both Default value is 2097152000 (2000 MB). More info in Greenplum® documentation. |
clusters[]. clusterConfig. greenplumConfigSet_6_19. userConfig. logStatement |
string Logged SQL statements.
More info in Greenplum® documentation.
|
clusters[]. clusterConfig. greenplumConfigSet_6_19. defaultConfig |
object Default configuration for a Greenplum® cluster. |
clusters[]. clusterConfig. greenplumConfigSet_6_19. defaultConfig. maxConnections |
integer (int64) Maximum number of inbound connections on master segment. |
clusters[]. clusterConfig. greenplumConfigSet_6_19. defaultConfig. maxSlotWalKeepSize |
integer (int64) The maximum size of WAL files that replication slots are allowed to retain in the More info in PostgreSQL® documentation. |
clusters[]. clusterConfig. greenplumConfigSet_6_19. defaultConfig. gpWorkfileLimitPerSegment |
integer (int64) The maximum total disk size that all running queries are allowed to use for creating temporary spill files at each segment. The default value is 0 (no limit). More info in Greenplum® documentation. |
clusters[]. clusterConfig. greenplumConfigSet_6_19. defaultConfig. gpWorkfileLimitPerQuery |
integer (int64) The maximum disk size that an individual query is allowed to use for creating temporary spill files at each segment. The default value is 0 (no limit). More info in Greenplum® documentation. |
clusters[]. clusterConfig. greenplumConfigSet_6_19. defaultConfig. gpWorkfileLimitFilesPerQuery |
integer (int64) The maximum number of temporary spill files allowed per query at each segment. Spill files, also known as workfiles, are created when a query requires more memory than there is allocated. The current query is terminated if the limit is exceeded. Set to zero to disable the limit. Master session reloads if the parameter changes. Default value is 10000. More info in Greenplum® documentation. |
clusters[]. clusterConfig. greenplumConfigSet_6_19. defaultConfig. maxPreparedTransactions |
integer (int64) The maximum number of transactions that can be in the More info in PostgreSQL® documentation. |
clusters[]. clusterConfig. greenplumConfigSet_6_19. defaultConfig. gpWorkfileCompression |
boolean (boolean) Whether the spill files are compressed or not. More info in Greenplum® documentation. |
clusters[]. clusterConfig. greenplumConfigSet_6_19. defaultConfig. maxStatementMem |
integer (int64) The maximum memory limit for a query, in bytes. Helps to avoid out-of-memory errors on a segment host during query processing as a result of setting Taking into account the configuration of a single segment host, calculate When changing both Default value is 2097152000 (2000 MB). More info in Greenplum® documentation. |
clusters[]. clusterConfig. greenplumConfigSet_6_19. defaultConfig. logStatement |
string Logged SQL statements.
More info in Greenplum® documentation.
|
clusters[]. clusterConfig. greenplumConfigSet_6_21 |
object clusters[].clusterConfig includes only one of the fields greenplumConfigSet_6_17 , greenplumConfigSet_6_19 , greenplumConfigSet_6_21 , greenplumConfigSet_6_22 , greenplumConfigSet_6 |
clusters[]. clusterConfig. greenplumConfigSet_6_21. effectiveConfig |
object Required. Effective settings for a Greenplum® cluster (a combination of settings defined in |
clusters[]. clusterConfig. greenplumConfigSet_6_21. effectiveConfig. maxConnections |
integer (int64) Maximum number of inbound connections on master segment |
clusters[]. clusterConfig. greenplumConfigSet_6_21. effectiveConfig. maxSlotWalKeepSize |
integer (int64) Specify the maximum size of WAL files that replication slots are allowed to retain in the pg_wal directory at checkpoint time. https://www.postgresql.org/docs/current/runtime-config-replication.html |
clusters[]. clusterConfig. greenplumConfigSet_6_21. effectiveConfig. gpWorkfileLimitPerSegment |
integer (int64) Sets the maximum total disk size that all running queries are allowed to use for creating temporary spill files at each segment. The default value is 0, which means a limit is not enforced. https://docs.vmware.com/en/VMware-Greenplum/6/greenplum-database/ref_guide-config_params-guc-list.html#gp_workfile_limit_per_segment |
clusters[]. clusterConfig. greenplumConfigSet_6_21. effectiveConfig. gpWorkfileLimitPerQuery |
integer (int64) Sets the maximum disk size an individual query is allowed to use for creating temporary spill files at each segment. The default value is 0, which means a limit is not enforced. https://docs.vmware.com/en/VMware-Greenplum/6/greenplum-database/ref_guide-config_params-guc-list.html#gp_workfile_limit_per_query |
clusters[]. clusterConfig. greenplumConfigSet_6_21. effectiveConfig. gpWorkfileLimitFilesPerQuery |
integer (int64) Sets the maximum number of temporary spill files (also known as workfiles) allowed per query per segment. Spill files are created when executing a query that requires more memory than it is allocated. The current query is terminated when the limit is exceeded. Set the value to 0 (zero) to allow an unlimited number of spill files. master session reload https://docs.vmware.com/en/VMware-Greenplum/6/greenplum-database/ref_guide-config_params-guc-list.html#gp_workfile_limit_files_per_query Default value is 10000 |
clusters[]. clusterConfig. greenplumConfigSet_6_21. effectiveConfig. maxPreparedTransactions |
integer (int64) Sets the maximum number of transactions that can be in the "prepared" state simultaneously https://www.postgresql.org/docs/9.6/runtime-config-resource.html |
clusters[]. clusterConfig. greenplumConfigSet_6_21. effectiveConfig. gpWorkfileCompression |
boolean (boolean) Specifies whether the temporary files created, when a hash aggregation or hash join operation spills to disk, are compressed. https://docs.vmware.com/en/VMware-Greenplum/6/greenplum-database/ref_guide-config_params-guc-list.html#gp_workfile_compression |
clusters[]. clusterConfig. greenplumConfigSet_6_21. effectiveConfig. maxStatementMem |
integer (int64) Sets the maximum memory limit for a query. Helps avoid out-of-memory errors on a segment host during query processing as a result of setting statement_mem too high. Taking into account the configuration of a single segment host, calculate max_statement_mem as follows: (seghost_physical_memory) / (average_number_concurrent_queries) When changing both max_statement_mem and statement_mem, max_statement_mem must be changed first, or listed first in the postgresql.conf file. https://greenplum.docs.pivotal.io/6-19/ref_guide/config_params/guc-list.html#max_statement_mem Default value is 2097152000 (2000MB) |
clusters[]. clusterConfig. greenplumConfigSet_6_21. effectiveConfig. logStatement |
string Controls which SQL statements are logged. DDL logs all data definition commands like CREATE, ALTER, and DROP commands. MOD logs all DDL statements, plus INSERT, UPDATE, DELETE, TRUNCATE, and COPY FROM. PREPARE and EXPLAIN ANALYZE statements are also logged if their contained command is of an appropriate type. https://docs.vmware.com/en/VMware-Greenplum/6/greenplum-database/ref_guide-config_params-guc-list.html#log_statement Default value is ddl
|
clusters[]. clusterConfig. greenplumConfigSet_6_21. effectiveConfig. gpAddColumnInheritsTableSetting |
boolean (boolean) https://docs.vmware.com/en/VMware-Tanzu-Greenplum/6/greenplum-database/GUID-ref_guide-config_params-guc-list.html#gp_add_column_inherits_table_setting |
clusters[]. clusterConfig. greenplumConfigSet_6_21. userConfig |
object User-defined settings for a Greenplum® cluster. |
clusters[]. clusterConfig. greenplumConfigSet_6_21. userConfig. maxConnections |
integer (int64) Maximum number of inbound connections on master segment |
clusters[]. clusterConfig. greenplumConfigSet_6_21. userConfig. maxSlotWalKeepSize |
integer (int64) Specify the maximum size of WAL files that replication slots are allowed to retain in the pg_wal directory at checkpoint time. https://www.postgresql.org/docs/current/runtime-config-replication.html |
clusters[]. clusterConfig. greenplumConfigSet_6_21. userConfig. gpWorkfileLimitPerSegment |
integer (int64) Sets the maximum total disk size that all running queries are allowed to use for creating temporary spill files at each segment. The default value is 0, which means a limit is not enforced. https://docs.vmware.com/en/VMware-Greenplum/6/greenplum-database/ref_guide-config_params-guc-list.html#gp_workfile_limit_per_segment |
clusters[]. clusterConfig. greenplumConfigSet_6_21. userConfig. gpWorkfileLimitPerQuery |
integer (int64) Sets the maximum disk size an individual query is allowed to use for creating temporary spill files at each segment. The default value is 0, which means a limit is not enforced. https://docs.vmware.com/en/VMware-Greenplum/6/greenplum-database/ref_guide-config_params-guc-list.html#gp_workfile_limit_per_query |
clusters[]. clusterConfig. greenplumConfigSet_6_21. userConfig. gpWorkfileLimitFilesPerQuery |
integer (int64) Sets the maximum number of temporary spill files (also known as workfiles) allowed per query per segment. Spill files are created when executing a query that requires more memory than it is allocated. The current query is terminated when the limit is exceeded. Set the value to 0 (zero) to allow an unlimited number of spill files. master session reload https://docs.vmware.com/en/VMware-Greenplum/6/greenplum-database/ref_guide-config_params-guc-list.html#gp_workfile_limit_files_per_query Default value is 10000 |
clusters[]. clusterConfig. greenplumConfigSet_6_21. userConfig. maxPreparedTransactions |
integer (int64) Sets the maximum number of transactions that can be in the "prepared" state simultaneously https://www.postgresql.org/docs/9.6/runtime-config-resource.html |
clusters[]. clusterConfig. greenplumConfigSet_6_21. userConfig. gpWorkfileCompression |
boolean (boolean) Specifies whether the temporary files created, when a hash aggregation or hash join operation spills to disk, are compressed. https://docs.vmware.com/en/VMware-Greenplum/6/greenplum-database/ref_guide-config_params-guc-list.html#gp_workfile_compression |
clusters[]. clusterConfig. greenplumConfigSet_6_21. userConfig. maxStatementMem |
integer (int64) Sets the maximum memory limit for a query. Helps avoid out-of-memory errors on a segment host during query processing as a result of setting statement_mem too high. Taking into account the configuration of a single segment host, calculate max_statement_mem as follows: (seghost_physical_memory) / (average_number_concurrent_queries) When changing both max_statement_mem and statement_mem, max_statement_mem must be changed first, or listed first in the postgresql.conf file. https://greenplum.docs.pivotal.io/6-19/ref_guide/config_params/guc-list.html#max_statement_mem Default value is 2097152000 (2000MB) |
clusters[]. clusterConfig. greenplumConfigSet_6_21. userConfig. logStatement |
string Controls which SQL statements are logged. DDL logs all data definition commands like CREATE, ALTER, and DROP commands. MOD logs all DDL statements, plus INSERT, UPDATE, DELETE, TRUNCATE, and COPY FROM. PREPARE and EXPLAIN ANALYZE statements are also logged if their contained command is of an appropriate type. https://docs.vmware.com/en/VMware-Greenplum/6/greenplum-database/ref_guide-config_params-guc-list.html#log_statement Default value is ddl
|
clusters[]. clusterConfig. greenplumConfigSet_6_21. userConfig. gpAddColumnInheritsTableSetting |
boolean (boolean) https://docs.vmware.com/en/VMware-Tanzu-Greenplum/6/greenplum-database/GUID-ref_guide-config_params-guc-list.html#gp_add_column_inherits_table_setting |
clusters[]. clusterConfig. greenplumConfigSet_6_21. defaultConfig |
object Default configuration for a Greenplum® cluster. |
clusters[]. clusterConfig. greenplumConfigSet_6_21. defaultConfig. maxConnections |
integer (int64) Maximum number of inbound connections on master segment |
clusters[]. clusterConfig. greenplumConfigSet_6_21. defaultConfig. maxSlotWalKeepSize |
integer (int64) Specify the maximum size of WAL files that replication slots are allowed to retain in the pg_wal directory at checkpoint time. https://www.postgresql.org/docs/current/runtime-config-replication.html |
clusters[]. clusterConfig. greenplumConfigSet_6_21. defaultConfig. gpWorkfileLimitPerSegment |
integer (int64) Sets the maximum total disk size that all running queries are allowed to use for creating temporary spill files at each segment. The default value is 0, which means a limit is not enforced. https://docs.vmware.com/en/VMware-Greenplum/6/greenplum-database/ref_guide-config_params-guc-list.html#gp_workfile_limit_per_segment |
clusters[]. clusterConfig. greenplumConfigSet_6_21. defaultConfig. gpWorkfileLimitPerQuery |
integer (int64) Sets the maximum disk size an individual query is allowed to use for creating temporary spill files at each segment. The default value is 0, which means a limit is not enforced. https://docs.vmware.com/en/VMware-Greenplum/6/greenplum-database/ref_guide-config_params-guc-list.html#gp_workfile_limit_per_query |
clusters[]. clusterConfig. greenplumConfigSet_6_21. defaultConfig. gpWorkfileLimitFilesPerQuery |
integer (int64) Sets the maximum number of temporary spill files (also known as workfiles) allowed per query per segment. Spill files are created when executing a query that requires more memory than it is allocated. The current query is terminated when the limit is exceeded. Set the value to 0 (zero) to allow an unlimited number of spill files. master session reload https://docs.vmware.com/en/VMware-Greenplum/6/greenplum-database/ref_guide-config_params-guc-list.html#gp_workfile_limit_files_per_query Default value is 10000 |
clusters[]. clusterConfig. greenplumConfigSet_6_21. defaultConfig. maxPreparedTransactions |
integer (int64) Sets the maximum number of transactions that can be in the "prepared" state simultaneously https://www.postgresql.org/docs/9.6/runtime-config-resource.html |
clusters[]. clusterConfig. greenplumConfigSet_6_21. defaultConfig. gpWorkfileCompression |
boolean (boolean) Specifies whether the temporary files created, when a hash aggregation or hash join operation spills to disk, are compressed. https://docs.vmware.com/en/VMware-Greenplum/6/greenplum-database/ref_guide-config_params-guc-list.html#gp_workfile_compression |
clusters[]. clusterConfig. greenplumConfigSet_6_21. defaultConfig. maxStatementMem |
integer (int64) Sets the maximum memory limit for a query. Helps avoid out-of-memory errors on a segment host during query processing as a result of setting statement_mem too high. Taking into account the configuration of a single segment host, calculate max_statement_mem as follows: (seghost_physical_memory) / (average_number_concurrent_queries) When changing both max_statement_mem and statement_mem, max_statement_mem must be changed first, or listed first in the postgresql.conf file. https://greenplum.docs.pivotal.io/6-19/ref_guide/config_params/guc-list.html#max_statement_mem Default value is 2097152000 (2000MB) |
clusters[]. clusterConfig. greenplumConfigSet_6_21. defaultConfig. logStatement |
string Controls which SQL statements are logged. DDL logs all data definition commands like CREATE, ALTER, and DROP commands. MOD logs all DDL statements, plus INSERT, UPDATE, DELETE, TRUNCATE, and COPY FROM. PREPARE and EXPLAIN ANALYZE statements are also logged if their contained command is of an appropriate type. https://docs.vmware.com/en/VMware-Greenplum/6/greenplum-database/ref_guide-config_params-guc-list.html#log_statement Default value is ddl
|
clusters[]. clusterConfig. greenplumConfigSet_6_21. defaultConfig. gpAddColumnInheritsTableSetting |
boolean (boolean) https://docs.vmware.com/en/VMware-Tanzu-Greenplum/6/greenplum-database/GUID-ref_guide-config_params-guc-list.html#gp_add_column_inherits_table_setting |
clusters[]. clusterConfig. greenplumConfigSet_6_22 |
object clusters[].clusterConfig includes only one of the fields greenplumConfigSet_6_17 , greenplumConfigSet_6_19 , greenplumConfigSet_6_21 , greenplumConfigSet_6_22 , greenplumConfigSet_6 |
clusters[]. clusterConfig. greenplumConfigSet_6_22. effectiveConfig |
object Required. Effective settings for a Greenplum® cluster (a combination of settings defined in |
clusters[]. clusterConfig. greenplumConfigSet_6_22. effectiveConfig. maxConnections |
integer (int64) Maximum number of inbound connections on master segment |
clusters[]. clusterConfig. greenplumConfigSet_6_22. effectiveConfig. maxSlotWalKeepSize |
integer (int64) Specify the maximum size of WAL files that replication slots are allowed to retain in the pg_wal directory at checkpoint time. https://www.postgresql.org/docs/current/runtime-config-replication.html |
clusters[]. clusterConfig. greenplumConfigSet_6_22. effectiveConfig. gpWorkfileLimitPerSegment |
integer (int64) Sets the maximum total disk size that all running queries are allowed to use for creating temporary spill files at each segment. The default value is 0, which means a limit is not enforced. https://docs.vmware.com/en/VMware-Greenplum/6/greenplum-database/ref_guide-config_params-guc-list.html#gp_workfile_limit_per_segment |
clusters[]. clusterConfig. greenplumConfigSet_6_22. effectiveConfig. gpWorkfileLimitPerQuery |
integer (int64) Sets the maximum disk size an individual query is allowed to use for creating temporary spill files at each segment. The default value is 0, which means a limit is not enforced. https://docs.vmware.com/en/VMware-Greenplum/6/greenplum-database/ref_guide-config_params-guc-list.html#gp_workfile_limit_per_query |
clusters[]. clusterConfig. greenplumConfigSet_6_22. effectiveConfig. gpWorkfileLimitFilesPerQuery |
integer (int64) Sets the maximum number of temporary spill files (also known as workfiles) allowed per query per segment. Spill files are created when executing a query that requires more memory than it is allocated. The current query is terminated when the limit is exceeded. Set the value to 0 (zero) to allow an unlimited number of spill files. master session reload https://docs.vmware.com/en/VMware-Greenplum/6/greenplum-database/ref_guide-config_params-guc-list.html#gp_workfile_limit_files_per_query Default value is 10000 |
clusters[]. clusterConfig. greenplumConfigSet_6_22. effectiveConfig. maxPreparedTransactions |
integer (int64) Sets the maximum number of transactions that can be in the "prepared" state simultaneously https://www.postgresql.org/docs/9.6/runtime-config-resource.html |
clusters[]. clusterConfig. greenplumConfigSet_6_22. effectiveConfig. gpWorkfileCompression |
boolean (boolean) Specifies whether the temporary files created, when a hash aggregation or hash join operation spills to disk, are compressed. https://docs.vmware.com/en/VMware-Greenplum/6/greenplum-database/ref_guide-config_params-guc-list.html#gp_workfile_compression |
clusters[]. clusterConfig. greenplumConfigSet_6_22. effectiveConfig. maxStatementMem |
integer (int64) Sets the maximum memory limit for a query. Helps avoid out-of-memory errors on a segment host during query processing as a result of setting statement_mem too high. Taking into account the configuration of a single segment host, calculate max_statement_mem as follows: (seghost_physical_memory) / (average_number_concurrent_queries) When changing both max_statement_mem and statement_mem, max_statement_mem must be changed first, or listed first in the postgresql.conf file. https://greenplum.docs.pivotal.io/6-19/ref_guide/config_params/guc-list.html#max_statement_mem Default value is 2097152000 (2000MB) |
clusters[]. clusterConfig. greenplumConfigSet_6_22. effectiveConfig. logStatement |
string Controls which SQL statements are logged. DDL logs all data definition commands like CREATE, ALTER, and DROP commands. MOD logs all DDL statements, plus INSERT, UPDATE, DELETE, TRUNCATE, and COPY FROM. PREPARE and EXPLAIN ANALYZE statements are also logged if their contained command is of an appropriate type. https://docs.vmware.com/en/VMware-Greenplum/6/greenplum-database/ref_guide-config_params-guc-list.html#log_statement Default value is ddl
|
clusters[]. clusterConfig. greenplumConfigSet_6_22. effectiveConfig. gpAddColumnInheritsTableSetting |
boolean (boolean) https://docs.vmware.com/en/VMware-Tanzu-Greenplum/6/greenplum-database/GUID-ref_guide-config_params-guc-list.html#gp_add_column_inherits_table_setting |
clusters[]. clusterConfig. greenplumConfigSet_6_22. userConfig |
object User-defined settings for a Greenplum® cluster. |
clusters[]. clusterConfig. greenplumConfigSet_6_22. userConfig. maxConnections |
integer (int64) Maximum number of inbound connections on master segment |
clusters[]. clusterConfig. greenplumConfigSet_6_22. userConfig. maxSlotWalKeepSize |
integer (int64) Specify the maximum size of WAL files that replication slots are allowed to retain in the pg_wal directory at checkpoint time. https://www.postgresql.org/docs/current/runtime-config-replication.html |
clusters[]. clusterConfig. greenplumConfigSet_6_22. userConfig. gpWorkfileLimitPerSegment |
integer (int64) Sets the maximum total disk size that all running queries are allowed to use for creating temporary spill files at each segment. The default value is 0, which means a limit is not enforced. https://docs.vmware.com/en/VMware-Greenplum/6/greenplum-database/ref_guide-config_params-guc-list.html#gp_workfile_limit_per_segment |
clusters[]. clusterConfig. greenplumConfigSet_6_22. userConfig. gpWorkfileLimitPerQuery |
integer (int64) Sets the maximum disk size an individual query is allowed to use for creating temporary spill files at each segment. The default value is 0, which means a limit is not enforced. https://docs.vmware.com/en/VMware-Greenplum/6/greenplum-database/ref_guide-config_params-guc-list.html#gp_workfile_limit_per_query |
clusters[]. clusterConfig. greenplumConfigSet_6_22. userConfig. gpWorkfileLimitFilesPerQuery |
integer (int64) Sets the maximum number of temporary spill files (also known as workfiles) allowed per query per segment. Spill files are created when executing a query that requires more memory than it is allocated. The current query is terminated when the limit is exceeded. Set the value to 0 (zero) to allow an unlimited number of spill files. master session reload https://docs.vmware.com/en/VMware-Greenplum/6/greenplum-database/ref_guide-config_params-guc-list.html#gp_workfile_limit_files_per_query Default value is 10000 |
clusters[]. clusterConfig. greenplumConfigSet_6_22. userConfig. maxPreparedTransactions |
integer (int64) Sets the maximum number of transactions that can be in the "prepared" state simultaneously https://www.postgresql.org/docs/9.6/runtime-config-resource.html |
clusters[]. clusterConfig. greenplumConfigSet_6_22. userConfig. gpWorkfileCompression |
boolean (boolean) Specifies whether the temporary files created, when a hash aggregation or hash join operation spills to disk, are compressed. https://docs.vmware.com/en/VMware-Greenplum/6/greenplum-database/ref_guide-config_params-guc-list.html#gp_workfile_compression |
clusters[]. clusterConfig. greenplumConfigSet_6_22. userConfig. maxStatementMem |
integer (int64) Sets the maximum memory limit for a query. Helps avoid out-of-memory errors on a segment host during query processing as a result of setting statement_mem too high. Taking into account the configuration of a single segment host, calculate max_statement_mem as follows: (seghost_physical_memory) / (average_number_concurrent_queries) When changing both max_statement_mem and statement_mem, max_statement_mem must be changed first, or listed first in the postgresql.conf file. https://greenplum.docs.pivotal.io/6-19/ref_guide/config_params/guc-list.html#max_statement_mem Default value is 2097152000 (2000MB) |
clusters[]. clusterConfig. greenplumConfigSet_6_22. userConfig. logStatement |
string Controls which SQL statements are logged. DDL logs all data definition commands like CREATE, ALTER, and DROP commands. MOD logs all DDL statements, plus INSERT, UPDATE, DELETE, TRUNCATE, and COPY FROM. PREPARE and EXPLAIN ANALYZE statements are also logged if their contained command is of an appropriate type. https://docs.vmware.com/en/VMware-Greenplum/6/greenplum-database/ref_guide-config_params-guc-list.html#log_statement Default value is ddl
|
clusters[]. clusterConfig. greenplumConfigSet_6_22. userConfig. gpAddColumnInheritsTableSetting |
boolean (boolean) https://docs.vmware.com/en/VMware-Tanzu-Greenplum/6/greenplum-database/GUID-ref_guide-config_params-guc-list.html#gp_add_column_inherits_table_setting |
clusters[]. clusterConfig. greenplumConfigSet_6_22. defaultConfig |
object Default configuration for a Greenplum® cluster. |
clusters[]. clusterConfig. greenplumConfigSet_6_22. defaultConfig. maxConnections |
integer (int64) Maximum number of inbound connections on master segment |
clusters[]. clusterConfig. greenplumConfigSet_6_22. defaultConfig. maxSlotWalKeepSize |
integer (int64) Specify the maximum size of WAL files that replication slots are allowed to retain in the pg_wal directory at checkpoint time. https://www.postgresql.org/docs/current/runtime-config-replication.html |
clusters[]. clusterConfig. greenplumConfigSet_6_22. defaultConfig. gpWorkfileLimitPerSegment |
integer (int64) Sets the maximum total disk size that all running queries are allowed to use for creating temporary spill files at each segment. The default value is 0, which means a limit is not enforced. https://docs.vmware.com/en/VMware-Greenplum/6/greenplum-database/ref_guide-config_params-guc-list.html#gp_workfile_limit_per_segment |
clusters[]. clusterConfig. greenplumConfigSet_6_22. defaultConfig. gpWorkfileLimitPerQuery |
integer (int64) Sets the maximum disk size an individual query is allowed to use for creating temporary spill files at each segment. The default value is 0, which means a limit is not enforced. https://docs.vmware.com/en/VMware-Greenplum/6/greenplum-database/ref_guide-config_params-guc-list.html#gp_workfile_limit_per_query |
clusters[]. clusterConfig. greenplumConfigSet_6_22. defaultConfig. gpWorkfileLimitFilesPerQuery |
integer (int64) Sets the maximum number of temporary spill files (also known as workfiles) allowed per query per segment. Spill files are created when executing a query that requires more memory than it is allocated. The current query is terminated when the limit is exceeded. Set the value to 0 (zero) to allow an unlimited number of spill files. master session reload https://docs.vmware.com/en/VMware-Greenplum/6/greenplum-database/ref_guide-config_params-guc-list.html#gp_workfile_limit_files_per_query Default value is 10000 |
clusters[]. clusterConfig. greenplumConfigSet_6_22. defaultConfig. maxPreparedTransactions |
integer (int64) Sets the maximum number of transactions that can be in the "prepared" state simultaneously https://www.postgresql.org/docs/9.6/runtime-config-resource.html |
clusters[]. clusterConfig. greenplumConfigSet_6_22. defaultConfig. gpWorkfileCompression |
boolean (boolean) Specifies whether the temporary files created, when a hash aggregation or hash join operation spills to disk, are compressed. https://docs.vmware.com/en/VMware-Greenplum/6/greenplum-database/ref_guide-config_params-guc-list.html#gp_workfile_compression |
clusters[]. clusterConfig. greenplumConfigSet_6_22. defaultConfig. maxStatementMem |
integer (int64) Sets the maximum memory limit for a query. Helps avoid out-of-memory errors on a segment host during query processing as a result of setting statement_mem too high. Taking into account the configuration of a single segment host, calculate max_statement_mem as follows: (seghost_physical_memory) / (average_number_concurrent_queries) When changing both max_statement_mem and statement_mem, max_statement_mem must be changed first, or listed first in the postgresql.conf file. https://greenplum.docs.pivotal.io/6-19/ref_guide/config_params/guc-list.html#max_statement_mem Default value is 2097152000 (2000MB) |
clusters[]. clusterConfig. greenplumConfigSet_6_22. defaultConfig. logStatement |
string Controls which SQL statements are logged. DDL logs all data definition commands like CREATE, ALTER, and DROP commands. MOD logs all DDL statements, plus INSERT, UPDATE, DELETE, TRUNCATE, and COPY FROM. PREPARE and EXPLAIN ANALYZE statements are also logged if their contained command is of an appropriate type. https://docs.vmware.com/en/VMware-Greenplum/6/greenplum-database/ref_guide-config_params-guc-list.html#log_statement Default value is ddl
|
clusters[]. clusterConfig. greenplumConfigSet_6_22. defaultConfig. gpAddColumnInheritsTableSetting |
boolean (boolean) https://docs.vmware.com/en/VMware-Tanzu-Greenplum/6/greenplum-database/GUID-ref_guide-config_params-guc-list.html#gp_add_column_inherits_table_setting |
clusters[]. clusterConfig. greenplumConfigSet_6 |
object clusters[].clusterConfig includes only one of the fields greenplumConfigSet_6_17 , greenplumConfigSet_6_19 , greenplumConfigSet_6_21 , greenplumConfigSet_6_22 , greenplumConfigSet_6 |
clusters[]. clusterConfig. greenplumConfigSet_6. effectiveConfig |
object Required. Effective settings for a Greenplum (a combination of settings defined in |
clusters[]. clusterConfig. greenplumConfigSet_6. effectiveConfig. maxConnections |
integer (int64) Maximum number of inbound connections on master segment |
clusters[]. clusterConfig. greenplumConfigSet_6. effectiveConfig. maxSlotWalKeepSize |
integer (int64) Specify the maximum size of WAL files that replication slots are allowed to retain in the pg_wal directory at checkpoint time. https://www.postgresql.org/docs/current/runtime-config-replication.html |
clusters[]. clusterConfig. greenplumConfigSet_6. effectiveConfig. gpWorkfileLimitPerSegment |
integer (int64) Sets the maximum total disk size that all running queries are allowed to use for creating temporary spill files at each segment. The default value is 0, which means a limit is not enforced. https://docs.greenplum.org/6-5/ref_guide/config_params/guc-list.html#gp_workfile_limit_per_segment |
clusters[]. clusterConfig. greenplumConfigSet_6. effectiveConfig. gpWorkfileLimitPerQuery |
integer (int64) Sets the maximum disk size an individual query is allowed to use for creating temporary spill files at each segment. The default value is 0, which means a limit is not enforced. https://docs.greenplum.org/6-5/ref_guide/config_params/guc-list.html#gp_workfile_limit_per_query |
clusters[]. clusterConfig. greenplumConfigSet_6. effectiveConfig. gpWorkfileLimitFilesPerQuery |
integer (int64) Sets the maximum number of temporary spill files (also known as workfiles) allowed per query per segment. Spill files are created when executing a query that requires more memory than it is allocated. The current query is terminated when the limit is exceeded. Set the value to 0 (zero) to allow an unlimited number of spill files. master session reload https://docs.greenplum.org/6-5/ref_guide/config_params/guc-list.html#gp_workfile_limit_files_per_query Default value is 10000 |
clusters[]. clusterConfig. greenplumConfigSet_6. effectiveConfig. maxPreparedTransactions |
integer (int64) Sets the maximum number of transactions that can be in the "prepared" state simultaneously https://www.postgresql.org/docs/9.6/runtime-config-resource.html |
clusters[]. clusterConfig. greenplumConfigSet_6. effectiveConfig. gpWorkfileCompression |
boolean (boolean) Specifies whether the temporary files created, when a hash aggregation or hash join operation spills to disk, are compressed. https://docs.greenplum.org/6-5/ref_guide/config_params/guc-list.html#gp_workfile_compression |
clusters[]. clusterConfig. greenplumConfigSet_6. effectiveConfig. maxStatementMem |
integer (int64) Sets the maximum memory limit for a query. Helps avoid out-of-memory errors on a segment host during query processing as a result of setting statement_mem too high. Taking into account the configuration of a single segment host, calculate max_statement_mem as follows: (seghost_physical_memory) / (average_number_concurrent_queries) When changing both max_statement_mem and statement_mem, max_statement_mem must be changed first, or listed first in the postgresql.conf file. https://greenplum.docs.pivotal.io/6-19/ref_guide/config_params/guc-list.html#max_statement_mem Default value is 2097152000 (2000MB) |
clusters[]. clusterConfig. greenplumConfigSet_6. effectiveConfig. logStatement |
string Controls which SQL statements are logged. DDL logs all data definition commands like CREATE, ALTER, and DROP commands. MOD logs all DDL statements, plus INSERT, UPDATE, DELETE, TRUNCATE, and COPY FROM. PREPARE and EXPLAIN ANALYZE statements are also logged if their contained command is of an appropriate type. https://docs.greenplum.org/6-5/ref_guide/config_params/guc-list.html#log_statement Default value is ddl
|
clusters[]. clusterConfig. greenplumConfigSet_6. effectiveConfig. gpAddColumnInheritsTableSetting |
boolean (boolean) https://docs.vmware.com/en/VMware-Tanzu-Greenplum/6/greenplum-database/GUID-ref_guide-config_params-guc-list.html#gp_add_column_inherits_table_setting |
clusters[]. clusterConfig. greenplumConfigSet_6. userConfig |
object User-defined settings for a Greenplum. |
clusters[]. clusterConfig. greenplumConfigSet_6. userConfig. maxConnections |
integer (int64) Maximum number of inbound connections on master segment |
clusters[]. clusterConfig. greenplumConfigSet_6. userConfig. maxSlotWalKeepSize |
integer (int64) Specify the maximum size of WAL files that replication slots are allowed to retain in the pg_wal directory at checkpoint time. https://www.postgresql.org/docs/current/runtime-config-replication.html |
clusters[]. clusterConfig. greenplumConfigSet_6. userConfig. gpWorkfileLimitPerSegment |
integer (int64) Sets the maximum total disk size that all running queries are allowed to use for creating temporary spill files at each segment. The default value is 0, which means a limit is not enforced. https://docs.greenplum.org/6-5/ref_guide/config_params/guc-list.html#gp_workfile_limit_per_segment |
clusters[]. clusterConfig. greenplumConfigSet_6. userConfig. gpWorkfileLimitPerQuery |
integer (int64) Sets the maximum disk size an individual query is allowed to use for creating temporary spill files at each segment. The default value is 0, which means a limit is not enforced. https://docs.greenplum.org/6-5/ref_guide/config_params/guc-list.html#gp_workfile_limit_per_query |
clusters[]. clusterConfig. greenplumConfigSet_6. userConfig. gpWorkfileLimitFilesPerQuery |
integer (int64) Sets the maximum number of temporary spill files (also known as workfiles) allowed per query per segment. Spill files are created when executing a query that requires more memory than it is allocated. The current query is terminated when the limit is exceeded. Set the value to 0 (zero) to allow an unlimited number of spill files. master session reload https://docs.greenplum.org/6-5/ref_guide/config_params/guc-list.html#gp_workfile_limit_files_per_query Default value is 10000 |
clusters[]. clusterConfig. greenplumConfigSet_6. userConfig. maxPreparedTransactions |
integer (int64) Sets the maximum number of transactions that can be in the "prepared" state simultaneously https://www.postgresql.org/docs/9.6/runtime-config-resource.html |
clusters[]. clusterConfig. greenplumConfigSet_6. userConfig. gpWorkfileCompression |
boolean (boolean) Specifies whether the temporary files created, when a hash aggregation or hash join operation spills to disk, are compressed. https://docs.greenplum.org/6-5/ref_guide/config_params/guc-list.html#gp_workfile_compression |
clusters[]. clusterConfig. greenplumConfigSet_6. userConfig. maxStatementMem |
integer (int64) Sets the maximum memory limit for a query. Helps avoid out-of-memory errors on a segment host during query processing as a result of setting statement_mem too high. Taking into account the configuration of a single segment host, calculate max_statement_mem as follows: (seghost_physical_memory) / (average_number_concurrent_queries) When changing both max_statement_mem and statement_mem, max_statement_mem must be changed first, or listed first in the postgresql.conf file. https://greenplum.docs.pivotal.io/6-19/ref_guide/config_params/guc-list.html#max_statement_mem Default value is 2097152000 (2000MB) |
clusters[]. clusterConfig. greenplumConfigSet_6. userConfig. logStatement |
string Controls which SQL statements are logged. DDL logs all data definition commands like CREATE, ALTER, and DROP commands. MOD logs all DDL statements, plus INSERT, UPDATE, DELETE, TRUNCATE, and COPY FROM. PREPARE and EXPLAIN ANALYZE statements are also logged if their contained command is of an appropriate type. https://docs.greenplum.org/6-5/ref_guide/config_params/guc-list.html#log_statement Default value is ddl
|
clusters[]. clusterConfig. greenplumConfigSet_6. userConfig. gpAddColumnInheritsTableSetting |
boolean (boolean) https://docs.vmware.com/en/VMware-Tanzu-Greenplum/6/greenplum-database/GUID-ref_guide-config_params-guc-list.html#gp_add_column_inherits_table_setting |
clusters[]. clusterConfig. greenplumConfigSet_6. defaultConfig |
object Default configuration for a Greenplum. |
clusters[]. clusterConfig. greenplumConfigSet_6. defaultConfig. maxConnections |
integer (int64) Maximum number of inbound connections on master segment |
clusters[]. clusterConfig. greenplumConfigSet_6. defaultConfig. maxSlotWalKeepSize |
integer (int64) Specify the maximum size of WAL files that replication slots are allowed to retain in the pg_wal directory at checkpoint time. https://www.postgresql.org/docs/current/runtime-config-replication.html |
clusters[]. clusterConfig. greenplumConfigSet_6. defaultConfig. gpWorkfileLimitPerSegment |
integer (int64) Sets the maximum total disk size that all running queries are allowed to use for creating temporary spill files at each segment. The default value is 0, which means a limit is not enforced. https://docs.greenplum.org/6-5/ref_guide/config_params/guc-list.html#gp_workfile_limit_per_segment |
clusters[]. clusterConfig. greenplumConfigSet_6. defaultConfig. gpWorkfileLimitPerQuery |
integer (int64) Sets the maximum disk size an individual query is allowed to use for creating temporary spill files at each segment. The default value is 0, which means a limit is not enforced. https://docs.greenplum.org/6-5/ref_guide/config_params/guc-list.html#gp_workfile_limit_per_query |
clusters[]. clusterConfig. greenplumConfigSet_6. defaultConfig. gpWorkfileLimitFilesPerQuery |
integer (int64) Sets the maximum number of temporary spill files (also known as workfiles) allowed per query per segment. Spill files are created when executing a query that requires more memory than it is allocated. The current query is terminated when the limit is exceeded. Set the value to 0 (zero) to allow an unlimited number of spill files. master session reload https://docs.greenplum.org/6-5/ref_guide/config_params/guc-list.html#gp_workfile_limit_files_per_query Default value is 10000 |
clusters[]. clusterConfig. greenplumConfigSet_6. defaultConfig. maxPreparedTransactions |
integer (int64) Sets the maximum number of transactions that can be in the "prepared" state simultaneously https://www.postgresql.org/docs/9.6/runtime-config-resource.html |
clusters[]. clusterConfig. greenplumConfigSet_6. defaultConfig. gpWorkfileCompression |
boolean (boolean) Specifies whether the temporary files created, when a hash aggregation or hash join operation spills to disk, are compressed. https://docs.greenplum.org/6-5/ref_guide/config_params/guc-list.html#gp_workfile_compression |
clusters[]. clusterConfig. greenplumConfigSet_6. defaultConfig. maxStatementMem |
integer (int64) Sets the maximum memory limit for a query. Helps avoid out-of-memory errors on a segment host during query processing as a result of setting statement_mem too high. Taking into account the configuration of a single segment host, calculate max_statement_mem as follows: (seghost_physical_memory) / (average_number_concurrent_queries) When changing both max_statement_mem and statement_mem, max_statement_mem must be changed first, or listed first in the postgresql.conf file. https://greenplum.docs.pivotal.io/6-19/ref_guide/config_params/guc-list.html#max_statement_mem Default value is 2097152000 (2000MB) |
clusters[]. clusterConfig. greenplumConfigSet_6. defaultConfig. logStatement |
string Controls which SQL statements are logged. DDL logs all data definition commands like CREATE, ALTER, and DROP commands. MOD logs all DDL statements, plus INSERT, UPDATE, DELETE, TRUNCATE, and COPY FROM. PREPARE and EXPLAIN ANALYZE statements are also logged if their contained command is of an appropriate type. https://docs.greenplum.org/6-5/ref_guide/config_params/guc-list.html#log_statement Default value is ddl
|
clusters[]. clusterConfig. greenplumConfigSet_6. defaultConfig. gpAddColumnInheritsTableSetting |
boolean (boolean) https://docs.vmware.com/en/VMware-Tanzu-Greenplum/6/greenplum-database/GUID-ref_guide-config_params-guc-list.html#gp_add_column_inherits_table_setting |
clusters[]. cloudStorage |
object Cloud storage settings Cloud Storage Settings |
clusters[]. cloudStorage. enable |
boolean (boolean) enable Cloud Storage for cluster |
clusters[]. masterHostGroupIds[] |
string Host groups hosting VMs of the master subcluster. |
clusters[]. segmentHostGroupIds[] |
string Host groups hosting VMs of the segment subcluster. |
nextPageToken | string This token allows you to get the next page of results for list requests. If the number of results is larger than pageSize, use the nextPageToken as the value for the pageToken parameter in the next list request. Each subsequent list request has its own nextPageToken to continue paging through the results. |