Managed Service for Greenplum® API, gRPC: ClusterService.Expand
- gRPC request
- ExpandRequest
- operation.Operation
- AddClusterHostsMetadata
- Cluster
- GreenplumConfig
- Access
- Monitoring
- MasterSubclusterConfig
- Resources
- SegmentSubclusterConfig
- MaintenanceWindow
- AnytimeMaintenanceWindow
- WeeklyMaintenanceWindow
- MaintenanceOperation
- ClusterConfigSet
- GreenplumConfigSet6_17
- GreenplumConfig6_17
- GreenplumConfigSet6_19
- GreenplumConfig6_19
- GreenplumConfigSet6_21
- GreenplumConfig6_21
- GreenplumConfigSet6_22
- GreenplumConfig6_22
- GreenplumConfigSet6
- GreenplumConfig6
- ConnectionPoolerConfigSet
- ConnectionPoolerConfig
- BackgroundActivitiesConfig
- TableSizes
- BackgroundActivityStartAt
- AnalyzeAndVacuum
- QueryKillerScripts
- QueryKiller
- PXFConfigSet
- PXFConfig
- CloudStorage
Expands the specified Greenplum® cluster.
gRPC request
rpc Expand (ExpandRequest) returns (operation.Operation)
ExpandRequest
{
"clusterId": "string",
"segmentHostCount": "int64",
"addSegmentsPerHostCount": "int64",
"duration": "int64",
"parallel": "int64",
"closeCluster": "bool",
"delayRedistribution": "bool"
}
Field |
Description |
clusterId |
string Required field. ID of the Greenplum Cluster resource to update. |
segmentHostCount |
int64 Number of hosts for add to the segment subcluster |
addSegmentsPerHostCount |
int64 Number of segments per host to add |
duration |
int64 Redistribute duration, in seconds |
parallel |
int64 Redistribute process parallelism, 0 - for automatic detection |
closeCluster |
bool Deny all client connections during the expand operation |
delayRedistribution |
bool Perform redistribution process by small chunks as background activity |
operation.Operation
{
"id": "string",
"description": "string",
"createdAt": "google.protobuf.Timestamp",
"createdBy": "string",
"modifiedAt": "google.protobuf.Timestamp",
"done": "bool",
"metadata": {
"clusterId": "string"
},
// Includes only one of the fields `error`, `response`
"error": "google.rpc.Status",
"response": {
"id": "string",
"folderId": "string",
"createdAt": "google.protobuf.Timestamp",
"name": "string",
"config": {
"version": "string",
"backupWindowStart": "google.type.TimeOfDay",
"backupRetainPeriodDays": "google.protobuf.Int64Value",
"access": {
"dataLens": "bool",
"webSql": "bool",
"dataTransfer": "bool",
"yandexQuery": "bool"
},
"zoneId": "string",
"subnetId": "string",
"assignPublicIp": "bool"
},
"description": "string",
"labels": "string",
"environment": "Environment",
"monitoring": [
{
"name": "string",
"description": "string",
"link": "string"
}
],
"masterConfig": {
"resources": {
"resourcePresetId": "string",
"diskSize": "int64",
"diskTypeId": "string"
}
},
"segmentConfig": {
"resources": {
"resourcePresetId": "string",
"diskSize": "int64",
"diskTypeId": "string"
}
},
"masterHostCount": "int64",
"segmentHostCount": "int64",
"segmentInHost": "int64",
"networkId": "string",
"health": "Health",
"status": "Status",
"maintenanceWindow": {
// Includes only one of the fields `anytime`, `weeklyMaintenanceWindow`
"anytime": "AnytimeMaintenanceWindow",
"weeklyMaintenanceWindow": {
"day": "WeekDay",
"hour": "int64"
}
// end of the list of possible fields
},
"plannedOperation": {
"info": "string",
"delayedUntil": "google.protobuf.Timestamp"
},
"securityGroupIds": [
"string"
],
"userName": "string",
"deletionProtection": "bool",
"hostGroupIds": [
"string"
],
"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": "google.protobuf.Int64Value",
"maxSlotWalKeepSize": "google.protobuf.Int64Value",
"gpWorkfileLimitPerSegment": "google.protobuf.Int64Value",
"gpWorkfileLimitPerQuery": "google.protobuf.Int64Value",
"gpWorkfileLimitFilesPerQuery": "google.protobuf.Int64Value",
"maxPreparedTransactions": "google.protobuf.Int64Value",
"gpWorkfileCompression": "google.protobuf.BoolValue"
},
"userConfig": {
"maxConnections": "google.protobuf.Int64Value",
"maxSlotWalKeepSize": "google.protobuf.Int64Value",
"gpWorkfileLimitPerSegment": "google.protobuf.Int64Value",
"gpWorkfileLimitPerQuery": "google.protobuf.Int64Value",
"gpWorkfileLimitFilesPerQuery": "google.protobuf.Int64Value",
"maxPreparedTransactions": "google.protobuf.Int64Value",
"gpWorkfileCompression": "google.protobuf.BoolValue"
},
"defaultConfig": {
"maxConnections": "google.protobuf.Int64Value",
"maxSlotWalKeepSize": "google.protobuf.Int64Value",
"gpWorkfileLimitPerSegment": "google.protobuf.Int64Value",
"gpWorkfileLimitPerQuery": "google.protobuf.Int64Value",
"gpWorkfileLimitFilesPerQuery": "google.protobuf.Int64Value",
"maxPreparedTransactions": "google.protobuf.Int64Value",
"gpWorkfileCompression": "google.protobuf.BoolValue"
}
},
"greenplumConfigSet_6_19": {
"effectiveConfig": {
"maxConnections": "google.protobuf.Int64Value",
"maxSlotWalKeepSize": "google.protobuf.Int64Value",
"gpWorkfileLimitPerSegment": "google.protobuf.Int64Value",
"gpWorkfileLimitPerQuery": "google.protobuf.Int64Value",
"gpWorkfileLimitFilesPerQuery": "google.protobuf.Int64Value",
"maxPreparedTransactions": "google.protobuf.Int64Value",
"gpWorkfileCompression": "google.protobuf.BoolValue",
"maxStatementMem": "google.protobuf.Int64Value",
"logStatement": "LogStatement"
},
"userConfig": {
"maxConnections": "google.protobuf.Int64Value",
"maxSlotWalKeepSize": "google.protobuf.Int64Value",
"gpWorkfileLimitPerSegment": "google.protobuf.Int64Value",
"gpWorkfileLimitPerQuery": "google.protobuf.Int64Value",
"gpWorkfileLimitFilesPerQuery": "google.protobuf.Int64Value",
"maxPreparedTransactions": "google.protobuf.Int64Value",
"gpWorkfileCompression": "google.protobuf.BoolValue",
"maxStatementMem": "google.protobuf.Int64Value",
"logStatement": "LogStatement"
},
"defaultConfig": {
"maxConnections": "google.protobuf.Int64Value",
"maxSlotWalKeepSize": "google.protobuf.Int64Value",
"gpWorkfileLimitPerSegment": "google.protobuf.Int64Value",
"gpWorkfileLimitPerQuery": "google.protobuf.Int64Value",
"gpWorkfileLimitFilesPerQuery": "google.protobuf.Int64Value",
"maxPreparedTransactions": "google.protobuf.Int64Value",
"gpWorkfileCompression": "google.protobuf.BoolValue",
"maxStatementMem": "google.protobuf.Int64Value",
"logStatement": "LogStatement"
}
},
"greenplumConfigSet_6_21": {
"effectiveConfig": {
"maxConnections": "google.protobuf.Int64Value",
"maxSlotWalKeepSize": "google.protobuf.Int64Value",
"gpWorkfileLimitPerSegment": "google.protobuf.Int64Value",
"gpWorkfileLimitPerQuery": "google.protobuf.Int64Value",
"gpWorkfileLimitFilesPerQuery": "google.protobuf.Int64Value",
"maxPreparedTransactions": "google.protobuf.Int64Value",
"gpWorkfileCompression": "google.protobuf.BoolValue",
"maxStatementMem": "google.protobuf.Int64Value",
"logStatement": "LogStatement",
"gpAddColumnInheritsTableSetting": "google.protobuf.BoolValue"
},
"userConfig": {
"maxConnections": "google.protobuf.Int64Value",
"maxSlotWalKeepSize": "google.protobuf.Int64Value",
"gpWorkfileLimitPerSegment": "google.protobuf.Int64Value",
"gpWorkfileLimitPerQuery": "google.protobuf.Int64Value",
"gpWorkfileLimitFilesPerQuery": "google.protobuf.Int64Value",
"maxPreparedTransactions": "google.protobuf.Int64Value",
"gpWorkfileCompression": "google.protobuf.BoolValue",
"maxStatementMem": "google.protobuf.Int64Value",
"logStatement": "LogStatement",
"gpAddColumnInheritsTableSetting": "google.protobuf.BoolValue"
},
"defaultConfig": {
"maxConnections": "google.protobuf.Int64Value",
"maxSlotWalKeepSize": "google.protobuf.Int64Value",
"gpWorkfileLimitPerSegment": "google.protobuf.Int64Value",
"gpWorkfileLimitPerQuery": "google.protobuf.Int64Value",
"gpWorkfileLimitFilesPerQuery": "google.protobuf.Int64Value",
"maxPreparedTransactions": "google.protobuf.Int64Value",
"gpWorkfileCompression": "google.protobuf.BoolValue",
"maxStatementMem": "google.protobuf.Int64Value",
"logStatement": "LogStatement",
"gpAddColumnInheritsTableSetting": "google.protobuf.BoolValue"
}
},
"greenplumConfigSet_6_22": {
"effectiveConfig": {
"maxConnections": "google.protobuf.Int64Value",
"maxSlotWalKeepSize": "google.protobuf.Int64Value",
"gpWorkfileLimitPerSegment": "google.protobuf.Int64Value",
"gpWorkfileLimitPerQuery": "google.protobuf.Int64Value",
"gpWorkfileLimitFilesPerQuery": "google.protobuf.Int64Value",
"maxPreparedTransactions": "google.protobuf.Int64Value",
"gpWorkfileCompression": "google.protobuf.BoolValue",
"maxStatementMem": "google.protobuf.Int64Value",
"logStatement": "LogStatement",
"gpAddColumnInheritsTableSetting": "google.protobuf.BoolValue"
},
"userConfig": {
"maxConnections": "google.protobuf.Int64Value",
"maxSlotWalKeepSize": "google.protobuf.Int64Value",
"gpWorkfileLimitPerSegment": "google.protobuf.Int64Value",
"gpWorkfileLimitPerQuery": "google.protobuf.Int64Value",
"gpWorkfileLimitFilesPerQuery": "google.protobuf.Int64Value",
"maxPreparedTransactions": "google.protobuf.Int64Value",
"gpWorkfileCompression": "google.protobuf.BoolValue",
"maxStatementMem": "google.protobuf.Int64Value",
"logStatement": "LogStatement",
"gpAddColumnInheritsTableSetting": "google.protobuf.BoolValue"
},
"defaultConfig": {
"maxConnections": "google.protobuf.Int64Value",
"maxSlotWalKeepSize": "google.protobuf.Int64Value",
"gpWorkfileLimitPerSegment": "google.protobuf.Int64Value",
"gpWorkfileLimitPerQuery": "google.protobuf.Int64Value",
"gpWorkfileLimitFilesPerQuery": "google.protobuf.Int64Value",
"maxPreparedTransactions": "google.protobuf.Int64Value",
"gpWorkfileCompression": "google.protobuf.BoolValue",
"maxStatementMem": "google.protobuf.Int64Value",
"logStatement": "LogStatement",
"gpAddColumnInheritsTableSetting": "google.protobuf.BoolValue"
}
},
"greenplumConfigSet_6": {
"effectiveConfig": {
"maxConnections": "google.protobuf.Int64Value",
"maxSlotWalKeepSize": "google.protobuf.Int64Value",
"gpWorkfileLimitPerSegment": "google.protobuf.Int64Value",
"gpWorkfileLimitPerQuery": "google.protobuf.Int64Value",
"gpWorkfileLimitFilesPerQuery": "google.protobuf.Int64Value",
"maxPreparedTransactions": "google.protobuf.Int64Value",
"gpWorkfileCompression": "google.protobuf.BoolValue",
"maxStatementMem": "google.protobuf.Int64Value",
"logStatement": "LogStatement",
"gpAddColumnInheritsTableSetting": "google.protobuf.BoolValue"
},
"userConfig": {
"maxConnections": "google.protobuf.Int64Value",
"maxSlotWalKeepSize": "google.protobuf.Int64Value",
"gpWorkfileLimitPerSegment": "google.protobuf.Int64Value",
"gpWorkfileLimitPerQuery": "google.protobuf.Int64Value",
"gpWorkfileLimitFilesPerQuery": "google.protobuf.Int64Value",
"maxPreparedTransactions": "google.protobuf.Int64Value",
"gpWorkfileCompression": "google.protobuf.BoolValue",
"maxStatementMem": "google.protobuf.Int64Value",
"logStatement": "LogStatement",
"gpAddColumnInheritsTableSetting": "google.protobuf.BoolValue"
},
"defaultConfig": {
"maxConnections": "google.protobuf.Int64Value",
"maxSlotWalKeepSize": "google.protobuf.Int64Value",
"gpWorkfileLimitPerSegment": "google.protobuf.Int64Value",
"gpWorkfileLimitPerQuery": "google.protobuf.Int64Value",
"gpWorkfileLimitFilesPerQuery": "google.protobuf.Int64Value",
"maxPreparedTransactions": "google.protobuf.Int64Value",
"gpWorkfileCompression": "google.protobuf.BoolValue",
"maxStatementMem": "google.protobuf.Int64Value",
"logStatement": "LogStatement",
"gpAddColumnInheritsTableSetting": "google.protobuf.BoolValue"
}
},
// end of the list of possible fields
"pool": {
"effectiveConfig": {
"mode": "PoolMode",
"size": "google.protobuf.Int64Value",
"clientIdleTimeout": "google.protobuf.Int64Value"
},
"userConfig": {
"mode": "PoolMode",
"size": "google.protobuf.Int64Value",
"clientIdleTimeout": "google.protobuf.Int64Value"
},
"defaultConfig": {
"mode": "PoolMode",
"size": "google.protobuf.Int64Value",
"clientIdleTimeout": "google.protobuf.Int64Value"
}
},
"backgroundActivities": {
"tableSizes": {
"starts": [
{
"hours": "int64",
"minutes": "int64"
}
]
},
"analyzeAndVacuum": {
"start": {
"hours": "int64",
"minutes": "int64"
},
"analyzeTimeout": "google.protobuf.Int64Value",
"vacuumTimeout": "google.protobuf.Int64Value"
},
"queryKillerScripts": {
"idle": {
"enable": "google.protobuf.BoolValue",
"maxAge": "google.protobuf.Int64Value",
"ignoreUsers": [
"string"
]
},
"idleInTransaction": {
"enable": "google.protobuf.BoolValue",
"maxAge": "google.protobuf.Int64Value",
"ignoreUsers": [
"string"
]
},
"longRunning": {
"enable": "google.protobuf.BoolValue",
"maxAge": "google.protobuf.Int64Value",
"ignoreUsers": [
"string"
]
}
}
},
"pxfConfig": {
"effectiveConfig": {
"connectionTimeout": "google.protobuf.Int64Value",
"uploadTimeout": "google.protobuf.Int64Value",
"maxThreads": "google.protobuf.Int64Value",
"poolAllowCoreThreadTimeout": "google.protobuf.BoolValue",
"poolCoreSize": "google.protobuf.Int64Value",
"poolQueueCapacity": "google.protobuf.Int64Value",
"poolMaxSize": "google.protobuf.Int64Value",
"xmx": "google.protobuf.Int64Value",
"xms": "google.protobuf.Int64Value"
},
"userConfig": {
"connectionTimeout": "google.protobuf.Int64Value",
"uploadTimeout": "google.protobuf.Int64Value",
"maxThreads": "google.protobuf.Int64Value",
"poolAllowCoreThreadTimeout": "google.protobuf.BoolValue",
"poolCoreSize": "google.protobuf.Int64Value",
"poolQueueCapacity": "google.protobuf.Int64Value",
"poolMaxSize": "google.protobuf.Int64Value",
"xmx": "google.protobuf.Int64Value",
"xms": "google.protobuf.Int64Value"
},
"defaultConfig": {
"connectionTimeout": "google.protobuf.Int64Value",
"uploadTimeout": "google.protobuf.Int64Value",
"maxThreads": "google.protobuf.Int64Value",
"poolAllowCoreThreadTimeout": "google.protobuf.BoolValue",
"poolCoreSize": "google.protobuf.Int64Value",
"poolQueueCapacity": "google.protobuf.Int64Value",
"poolMaxSize": "google.protobuf.Int64Value",
"xmx": "google.protobuf.Int64Value",
"xms": "google.protobuf.Int64Value"
}
}
},
"cloudStorage": {
"enable": "bool"
},
"masterHostGroupIds": [
"string"
],
"segmentHostGroupIds": [
"string"
]
}
// end of the list of possible fields
}
An Operation resource. For more information, see Operation.
Field |
Description |
id |
string ID of the operation. |
description |
string Description of the operation. 0-256 characters long. |
createdAt |
Creation timestamp. |
createdBy |
string ID of the user or service account who initiated the operation. |
modifiedAt |
The time when the Operation resource was last modified. |
done |
bool If the value is |
metadata |
Service-specific metadata associated with the operation. |
error |
The error result of the operation in case of failure or cancellation. Includes only one of the fields The operation result. |
response |
The normal response of the operation in case of success. Includes only one of the fields The operation result. |
AddClusterHostsMetadata
Field |
Description |
clusterId |
string ID of the Greenplum Cluster resource that is being updated. |
Cluster
A Greenplum® cluster resource.
Field |
Description |
id |
string ID of the Greenplum® cluster. |
folderId |
string ID of the folder that the Greenplum® cluster belongs to. |
createdAt |
Time when the cluster was created. |
name |
string Required field. Name of the Greenplum® cluster. |
config |
Greenplum® cluster configuration. |
description |
string Description of the Greenplum® cluster. |
labels |
string Custom labels for the Greenplum® cluster as |
environment |
enum Environment Deployment environment of the Greenplum® cluster.
|
monitoring[] |
Description of monitoring systems relevant to the Greenplum® cluster. |
masterConfig |
Configuration of the Greenplum® master subcluster. |
segmentConfig |
Configuration of the Greenplum® segment subcluster. |
masterHostCount |
int64 Number of hosts in the master subcluster. |
segmentHostCount |
int64 Number of hosts in the segment subcluster. |
segmentInHost |
int64 Number of segments per host. |
networkId |
string ID of the cloud network that the cluster belongs to. |
health |
enum Health Aggregated cluster health.
|
status |
enum Status Current state of the cluster.
|
maintenanceWindow |
A Greenplum® cluster maintenance window. Should be defined by either one of the two options. |
plannedOperation |
Maintenance operation planned at nearest |
securityGroupIds[] |
string User security groups. |
userName |
string Owner user name. |
deletionProtection |
bool Determines whether the cluster is protected from being deleted. |
hostGroupIds[] |
string Host groups hosting VMs of the cluster. |
clusterConfig |
Greenplum® and Odyssey® configuration. |
cloudStorage |
Cloud storage settings |
masterHostGroupIds[] |
string Host groups hosting VMs of the master subcluster. |
segmentHostGroupIds[] |
string Host groups hosting VMs of the segment subcluster. |
GreenplumConfig
Field |
Description |
version |
string Version of the Greenplum® server software. |
backupWindowStart |
Time to start the daily backup, in the UTC timezone. |
backupRetainPeriodDays |
Retention policy of automated backups. |
access |
Access policy for external services. |
zoneId |
string ID of the availability zone the cluster belongs to. |
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). |
assignPublicIp |
bool Determines whether the cluster has a public IP address. After the cluster has been created, this setting cannot be changed. |
Access
Field |
Description |
dataLens |
bool Allows data export from the cluster to DataLens. |
webSql |
bool Allows SQL queries to the cluster databases from the management console. |
dataTransfer |
bool Allows access for DataTransfer. |
yandexQuery |
bool Allow access for YandexQuery. |
Monitoring
Monitoring system metadata.
Field |
Description |
name |
string Name of the monitoring system. |
description |
string Description of the monitoring system. |
link |
string Link to the monitoring system charts for the Greenplum® cluster. |
MasterSubclusterConfig
Field |
Description |
resources |
Computational resources allocated to Greenplum® master subcluster hosts. |
Resources
Field |
Description |
resourcePresetId |
string ID of the preset for computational resources allocated to a host. Available presets are listed in the documentation. |
diskSize |
int64 Volume of the storage used by the host, in bytes. |
diskTypeId |
string Type of the storage used by the host: |
SegmentSubclusterConfig
Field |
Description |
resources |
Computational resources allocated to Greenplum® segment subcluster hosts. |
MaintenanceWindow
Field |
Description |
anytime |
An any-time maintenance window. Includes only one of the fields |
weeklyMaintenanceWindow |
A weekly maintenance window. Includes only one of the fields |
AnytimeMaintenanceWindow
An any-time maintenance window.
Field |
Description |
Empty |
WeeklyMaintenanceWindow
A weekly maintenance window.
Field |
Description |
day |
enum WeekDay Day of the week.
|
hour |
int64 Hour of the day in the UTC timezone. |
MaintenanceOperation
Field |
Description |
info |
string The description of the operation. |
delayedUntil |
Delay time for the maintenance operation. |
ClusterConfigSet
Field |
Description |
greenplumConfigSet_6_17 |
Includes only one of the fields |
greenplumConfigSet_6_19 |
Includes only one of the fields |
greenplumConfigSet_6_21 |
Includes only one of the fields |
greenplumConfigSet_6_22 |
Includes only one of the fields |
greenplumConfigSet_6 |
Includes only one of the fields |
pool |
Odyssey® pool settings. |
backgroundActivities |
Managed Greenplum® background tasks configuration. |
pxfConfig |
GreenplumConfigSet6_17
Configuration settings version 6.17
Field |
Description |
effectiveConfig |
Required field. Effective settings for a Greenplum® cluster (a combination of settings defined in |
userConfig |
User-defined settings for a Greenplum® cluster. |
defaultConfig |
Default configuration for a Greenplum® cluster. |
GreenplumConfig6_17
Field |
Description |
maxConnections |
Maximum number of inbound connections on master segment. |
maxSlotWalKeepSize |
The maximum size of WAL files that replication slots are allowed to retain in the More info in PostgreSQL® documentation |
gpWorkfileLimitPerSegment |
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 |
gpWorkfileLimitPerQuery |
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 |
gpWorkfileLimitFilesPerQuery |
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 |
maxPreparedTransactions |
The maximum number of transactions that can be in the More info in PostgreSQL® documentation |
gpWorkfileCompression |
Whether the spill files are compressed or not. More info in Greenplum® documentation |
GreenplumConfigSet6_19
Configuration settings version 6.19
Field |
Description |
effectiveConfig |
Required field. Effective settings for a Greenplum® cluster (a combination of settings defined in |
userConfig |
User-defined settings for a Greenplum® cluster. |
defaultConfig |
Default configuration for a Greenplum® cluster. |
GreenplumConfig6_19
Field |
Description |
maxConnections |
Maximum number of inbound connections on master segment. |
maxSlotWalKeepSize |
The maximum size of WAL files that replication slots are allowed to retain in the More info in PostgreSQL® documentation |
gpWorkfileLimitPerSegment |
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 |
gpWorkfileLimitPerQuery |
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 |
gpWorkfileLimitFilesPerQuery |
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 |
maxPreparedTransactions |
The maximum number of transactions that can be in the More info in PostgreSQL® documentation |
gpWorkfileCompression |
Whether the spill files are compressed or not. More info in Greenplum® documentation |
maxStatementMem |
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 |
logStatement |
enum LogStatement Logged SQL statements.
More info in Greenplum® documentation
|
GreenplumConfigSet6_21
Field |
Description |
effectiveConfig |
Required field. Effective settings for a Greenplum® cluster (a combination of settings defined in |
userConfig |
User-defined settings for a Greenplum® cluster. |
defaultConfig |
Default configuration for a Greenplum® cluster. |
GreenplumConfig6_21
Field |
Description |
maxConnections |
Maximum number of inbound connections on master segment |
maxSlotWalKeepSize |
Specify the maximum size of WAL files that replication slots are allowed to retain in the pg_wal directory at checkpoint time. |
gpWorkfileLimitPerSegment |
Sets the maximum total disk size that all running queries are allowed to use for creating temporary spill files at each segment. |
gpWorkfileLimitPerQuery |
Sets the maximum disk size an individual query is allowed to use for creating temporary spill files at each segment. |
gpWorkfileLimitFilesPerQuery |
Sets the maximum number of temporary spill files (also known as workfiles) allowed per query per segment. |
maxPreparedTransactions |
Sets the maximum number of transactions that can be in the "prepared" state simultaneously |
gpWorkfileCompression |
Specifies whether the temporary files created, when a hash aggregation or hash join operation spills to disk, are compressed. |
maxStatementMem |
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. |
logStatement |
enum LogStatement Controls which SQL statements are logged. DDL logs all data definition commands like CREATE, ALTER, and DROP commands.
|
gpAddColumnInheritsTableSetting |
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 |
GreenplumConfigSet6_22
Field |
Description |
effectiveConfig |
Required field. Effective settings for a Greenplum® cluster (a combination of settings defined in |
userConfig |
User-defined settings for a Greenplum® cluster. |
defaultConfig |
Default configuration for a Greenplum® cluster. |
GreenplumConfig6_22
Field |
Description |
maxConnections |
Maximum number of inbound connections on master segment |
maxSlotWalKeepSize |
Specify the maximum size of WAL files that replication slots are allowed to retain in the pg_wal directory at checkpoint time. |
gpWorkfileLimitPerSegment |
Sets the maximum total disk size that all running queries are allowed to use for creating temporary spill files at each segment. |
gpWorkfileLimitPerQuery |
Sets the maximum disk size an individual query is allowed to use for creating temporary spill files at each segment. |
gpWorkfileLimitFilesPerQuery |
Sets the maximum number of temporary spill files (also known as workfiles) allowed per query per segment. |
maxPreparedTransactions |
Sets the maximum number of transactions that can be in the "prepared" state simultaneously |
gpWorkfileCompression |
Specifies whether the temporary files created, when a hash aggregation or hash join operation spills to disk, are compressed. |
maxStatementMem |
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. |
logStatement |
enum LogStatement Controls which SQL statements are logged. DDL logs all data definition commands like CREATE, ALTER, and DROP commands.
|
gpAddColumnInheritsTableSetting |
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 |
GreenplumConfigSet6
Field |
Description |
effectiveConfig |
Required field. Effective settings for a Greenplum (a combination of settings defined |
userConfig |
User-defined settings for a Greenplum. |
defaultConfig |
Default configuration for a Greenplum. |
GreenplumConfig6
Field |
Description |
maxConnections |
Maximum number of inbound connections on master segment |
maxSlotWalKeepSize |
Specify the maximum size of WAL files that replication slots are allowed to retain in the pg_wal directory at checkpoint time. |
gpWorkfileLimitPerSegment |
Sets the maximum total disk size that all running queries are allowed to use for creating temporary spill files at each segment. |
gpWorkfileLimitPerQuery |
Sets the maximum disk size an individual query is allowed to use for creating temporary spill files at each segment. |
gpWorkfileLimitFilesPerQuery |
Sets the maximum number of temporary spill files (also known as workfiles) allowed per query per segment. |
maxPreparedTransactions |
Sets the maximum number of transactions that can be in the "prepared" state simultaneously |
gpWorkfileCompression |
Specifies whether the temporary files created, when a hash aggregation or hash join operation spills to disk, are compressed. |
maxStatementMem |
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. |
logStatement |
enum LogStatement Controls which SQL statements are logged. DDL logs all data definition commands like CREATE, ALTER, and DROP commands.
|
gpAddColumnInheritsTableSetting |
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 |
ConnectionPoolerConfigSet
Field |
Description |
effectiveConfig |
Required field. Effective settings for an Odyssey® pooler (a combination of settings defined in |
userConfig |
User-defined settings for an Odyssey® pooler. |
defaultConfig |
Default configuration for an Odyssey® pooler. |
ConnectionPoolerConfig
Field |
Description |
mode |
enum PoolMode Route server pool mode.
|
size |
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. |
clientIdleTimeout |
Server pool idle timeout, in seconds. A server connection closes after being idle for the specified time. Set to zero to disable the limit. |
BackgroundActivitiesConfig
Field |
Description |
tableSizes |
Enables scripts that collects tables sizes to |
analyzeAndVacuum |
Configuration for |
queryKillerScripts |
Configuration for long running queries killer. |
TableSizes
Field |
Description |
starts[] |
BackgroundActivityStartAt
Field |
Description |
hours |
int64 |
minutes |
int64 |
AnalyzeAndVacuum
Field |
Description |
start |
|
analyzeTimeout |
Maximum duration of the |
vacuumTimeout |
Maximum duration of the |
QueryKillerScripts
Field |
Description |
idle |
Configuration of script that kills long running queries that are in |
idleInTransaction |
Configuration of script that kills long running queries that are in |
longRunning |
Configuration of script that kills long running queries (in any state). |
QueryKiller
Field |
Description |
enable |
|
maxAge |
Maximum duration for this type of queries (in seconds). |
ignoreUsers[] |
string Ignore these users when considering queries to terminate |
PXFConfigSet
Field |
Description |
effectiveConfig |
Required field. |
userConfig |
User-defined settings. |
defaultConfig |
Default configuration. |
PXFConfig
Field |
Description |
connectionTimeout |
Timeout for connection to the Apache Tomcat® server when making read requests. Specify values in seconds. |
uploadTimeout |
Timeout for connection to the Apache Tomcat® server when making write requests. Specify the values in seconds. |
maxThreads |
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 |
poolAllowCoreThreadTimeout |
Determines whether the timeout for core streaming threads is permitted. |
poolCoreSize |
Number of core streaming threads per pool. |
poolQueueCapacity |
Maximum number of requests you can add to a pool queue for core streaming threads. If |
poolMaxSize |
Maximum allowed number of core streaming threads. |
xmx |
Initial size, in megabytes, of the JVM heap for the PXF daemon. |
xms |
Maximum size, in megabytes, of the JVM heap for the PXF daemon. |
CloudStorage
Cloud Storage Settings
Field |
Description |
enable |
bool enable Cloud Storage for cluster |