Managed Service for PostgreSQL API, REST: Cluster.update
Updates the specified PostgreSQL cluster.
HTTP request
PATCH https://mdb.api.cloud.yandex.net/managed-postgresql/v1/clusters/{clusterId}
Path parameters
Parameter | Description |
---|---|
clusterId | Required. ID of the PostgreSQL Cluster resource to update. To get the PostgreSQL cluster ID, use a list request. The maximum string length in characters is 50. |
Body parameters
{
"updateMask": "string",
"description": "string",
"labels": "object",
"configSpec": {
"version": "string",
"poolerConfig": {
"poolingMode": "string",
"poolDiscard": true
},
"resources": {
"resourcePresetId": "string",
"diskSize": "string",
"diskTypeId": "string"
},
"autofailover": true,
"backupWindowStart": {
"hours": "integer",
"minutes": "integer",
"seconds": "integer",
"nanos": "integer"
},
"backupRetainPeriodDays": "integer",
"access": {
"dataLens": true,
"webSql": true,
"serverless": true,
"dataTransfer": true
},
"performanceDiagnostics": {
"enabled": true,
"sessionsSamplingInterval": "string",
"statementsSamplingInterval": "string"
},
// `configSpec` includes only one of the fields `postgresqlConfig_9_6`, `postgresqlConfig_10_1C`, `postgresqlConfig_10`, `postgresqlConfig_11`, `postgresqlConfig_11_1C`, `postgresqlConfig_12`, `postgresqlConfig_12_1C`, `postgresqlConfig_13`, `postgresqlConfig_13_1C`, `postgresqlConfig_14`, `postgresqlConfig_14_1C`, `postgresqlConfig_15`, `postgresqlConfig_15_1C`
"postgresqlConfig_9_6": {
"maxConnections": "integer",
"sharedBuffers": "integer",
"tempBuffers": "integer",
"maxPreparedTransactions": "integer",
"workMem": "integer",
"maintenanceWorkMem": "integer",
"replacementSortTuples": "integer",
"autovacuumWorkMem": "integer",
"tempFileLimit": "integer",
"vacuumCostDelay": "integer",
"vacuumCostPageHit": "integer",
"vacuumCostPageMiss": "integer",
"vacuumCostPageDirty": "integer",
"vacuumCostLimit": "integer",
"bgwriterDelay": "integer",
"bgwriterLruMaxpages": "integer",
"bgwriterLruMultiplier": "number",
"bgwriterFlushAfter": "integer",
"backendFlushAfter": "integer",
"oldSnapshotThreshold": "integer",
"walLevel": "string",
"synchronousCommit": "string",
"checkpointTimeout": "integer",
"checkpointCompletionTarget": "number",
"checkpointFlushAfter": "integer",
"maxWalSize": "integer",
"minWalSize": "integer",
"maxStandbyStreamingDelay": "integer",
"defaultStatisticsTarget": "integer",
"constraintExclusion": "string",
"cursorTupleFraction": "number",
"fromCollapseLimit": "integer",
"joinCollapseLimit": "integer",
"forceParallelMode": "string",
"clientMinMessages": "string",
"logMinMessages": "string",
"logMinErrorStatement": "string",
"logMinDurationStatement": "integer",
"logCheckpoints": true,
"logConnections": true,
"logDisconnections": true,
"logDuration": true,
"logErrorVerbosity": "string",
"logLockWaits": true,
"logStatement": "string",
"logTempFiles": "integer",
"searchPath": "string",
"rowSecurity": true,
"defaultTransactionIsolation": "string",
"statementTimeout": "integer",
"lockTimeout": "integer",
"idleInTransactionSessionTimeout": "integer",
"byteaOutput": "string",
"xmlbinary": "string",
"xmloption": "string",
"ginPendingListLimit": "integer",
"deadlockTimeout": "integer",
"maxLocksPerTransaction": "integer",
"maxPredLocksPerTransaction": "integer",
"arrayNulls": true,
"backslashQuote": "string",
"defaultWithOids": true,
"escapeStringWarning": true,
"loCompatPrivileges": true,
"operatorPrecedenceWarning": true,
"quoteAllIdentifiers": true,
"standardConformingStrings": true,
"synchronizeSeqscans": true,
"transformNullEquals": true,
"exitOnError": true,
"seqPageCost": "number",
"randomPageCost": "number",
"sqlInheritance": true,
"autovacuumMaxWorkers": "integer",
"autovacuumVacuumCostDelay": "integer",
"autovacuumVacuumCostLimit": "integer",
"autovacuumNaptime": "integer",
"archiveTimeout": "integer",
"trackActivityQuerySize": "integer",
"effectiveIoConcurrency": "integer",
"effectiveCacheSize": "integer"
},
"postgresqlConfig_10_1C": {
"maxConnections": "integer",
"sharedBuffers": "integer",
"tempBuffers": "integer",
"maxPreparedTransactions": "integer",
"workMem": "integer",
"maintenanceWorkMem": "integer",
"replacementSortTuples": "integer",
"autovacuumWorkMem": "integer",
"tempFileLimit": "integer",
"vacuumCostDelay": "integer",
"vacuumCostPageHit": "integer",
"vacuumCostPageMiss": "integer",
"vacuumCostPageDirty": "integer",
"vacuumCostLimit": "integer",
"bgwriterDelay": "integer",
"bgwriterLruMaxpages": "integer",
"bgwriterLruMultiplier": "number",
"bgwriterFlushAfter": "integer",
"backendFlushAfter": "integer",
"oldSnapshotThreshold": "integer",
"walLevel": "string",
"synchronousCommit": "string",
"checkpointTimeout": "integer",
"checkpointCompletionTarget": "number",
"checkpointFlushAfter": "integer",
"maxWalSize": "integer",
"minWalSize": "integer",
"maxStandbyStreamingDelay": "integer",
"defaultStatisticsTarget": "integer",
"constraintExclusion": "string",
"cursorTupleFraction": "number",
"fromCollapseLimit": "integer",
"joinCollapseLimit": "integer",
"forceParallelMode": "string",
"clientMinMessages": "string",
"logMinMessages": "string",
"logMinErrorStatement": "string",
"logMinDurationStatement": "integer",
"logCheckpoints": true,
"logConnections": true,
"logDisconnections": true,
"logDuration": true,
"logErrorVerbosity": "string",
"logLockWaits": true,
"logStatement": "string",
"logTempFiles": "integer",
"searchPath": "string",
"rowSecurity": true,
"defaultTransactionIsolation": "string",
"statementTimeout": "integer",
"lockTimeout": "integer",
"idleInTransactionSessionTimeout": "integer",
"byteaOutput": "string",
"xmlbinary": "string",
"xmloption": "string",
"ginPendingListLimit": "integer",
"deadlockTimeout": "integer",
"maxLocksPerTransaction": "integer",
"maxPredLocksPerTransaction": "integer",
"arrayNulls": true,
"backslashQuote": "string",
"defaultWithOids": true,
"escapeStringWarning": true,
"loCompatPrivileges": true,
"operatorPrecedenceWarning": true,
"quoteAllIdentifiers": true,
"standardConformingStrings": true,
"synchronizeSeqscans": true,
"transformNullEquals": true,
"exitOnError": true,
"seqPageCost": "number",
"randomPageCost": "number",
"autovacuumMaxWorkers": "integer",
"autovacuumVacuumCostDelay": "integer",
"autovacuumVacuumCostLimit": "integer",
"autovacuumNaptime": "integer",
"archiveTimeout": "integer",
"trackActivityQuerySize": "integer",
"enableBitmapscan": true,
"enableHashagg": true,
"enableHashjoin": true,
"enableIndexscan": true,
"enableIndexonlyscan": true,
"enableMaterial": true,
"enableMergejoin": true,
"enableNestloop": true,
"enableSeqscan": true,
"enableSort": true,
"enableTidscan": true,
"maxWorkerProcesses": "integer",
"maxParallelWorkers": "integer",
"maxParallelWorkersPerGather": "integer",
"autovacuumVacuumScaleFactor": "number",
"autovacuumAnalyzeScaleFactor": "number",
"defaultTransactionReadOnly": true,
"timezone": "string",
"effectiveIoConcurrency": "integer",
"effectiveCacheSize": "integer",
"sharedPreloadLibraries": [
"string"
],
"autoExplainLogMinDuration": "integer",
"autoExplainLogAnalyze": true,
"autoExplainLogBuffers": true,
"autoExplainLogTiming": true,
"autoExplainLogTriggers": true,
"autoExplainLogVerbose": true,
"autoExplainLogNestedStatements": true,
"autoExplainSampleRate": "number",
"pgHintPlanEnableHint": true,
"pgHintPlanEnableHintTable": true,
"pgHintPlanDebugPrint": "string",
"pgHintPlanMessageLevel": "string",
"onlineAnalyzeEnable": true,
"plantunerFixEmptyTable": true,
"pgQualstatsEnabled": true,
"pgQualstatsTrackConstants": true,
"pgQualstatsMax": "integer",
"pgQualstatsResolveOids": true,
"pgQualstatsSampleRate": "number",
"maxStackDepth": "integer",
"geqo": true,
"geqoThreshold": "integer",
"geqoEffort": "integer",
"geqoPoolSize": "integer",
"geqoGenerations": "integer",
"geqoSelectionBias": "number",
"geqoSeed": "number"
},
"postgresqlConfig_10": {
"maxConnections": "integer",
"sharedBuffers": "integer",
"tempBuffers": "integer",
"maxPreparedTransactions": "integer",
"workMem": "integer",
"maintenanceWorkMem": "integer",
"replacementSortTuples": "integer",
"autovacuumWorkMem": "integer",
"tempFileLimit": "integer",
"vacuumCostDelay": "integer",
"vacuumCostPageHit": "integer",
"vacuumCostPageMiss": "integer",
"vacuumCostPageDirty": "integer",
"vacuumCostLimit": "integer",
"bgwriterDelay": "integer",
"bgwriterLruMaxpages": "integer",
"bgwriterLruMultiplier": "number",
"bgwriterFlushAfter": "integer",
"backendFlushAfter": "integer",
"oldSnapshotThreshold": "integer",
"walLevel": "string",
"synchronousCommit": "string",
"checkpointTimeout": "integer",
"checkpointCompletionTarget": "number",
"checkpointFlushAfter": "integer",
"maxWalSize": "integer",
"minWalSize": "integer",
"maxStandbyStreamingDelay": "integer",
"defaultStatisticsTarget": "integer",
"constraintExclusion": "string",
"cursorTupleFraction": "number",
"fromCollapseLimit": "integer",
"joinCollapseLimit": "integer",
"forceParallelMode": "string",
"clientMinMessages": "string",
"logMinMessages": "string",
"logMinErrorStatement": "string",
"logMinDurationStatement": "integer",
"logCheckpoints": true,
"logConnections": true,
"logDisconnections": true,
"logDuration": true,
"logErrorVerbosity": "string",
"logLockWaits": true,
"logStatement": "string",
"logTempFiles": "integer",
"searchPath": "string",
"rowSecurity": true,
"defaultTransactionIsolation": "string",
"statementTimeout": "integer",
"lockTimeout": "integer",
"idleInTransactionSessionTimeout": "integer",
"byteaOutput": "string",
"xmlbinary": "string",
"xmloption": "string",
"ginPendingListLimit": "integer",
"deadlockTimeout": "integer",
"maxLocksPerTransaction": "integer",
"maxPredLocksPerTransaction": "integer",
"arrayNulls": true,
"backslashQuote": "string",
"defaultWithOids": true,
"escapeStringWarning": true,
"loCompatPrivileges": true,
"operatorPrecedenceWarning": true,
"quoteAllIdentifiers": true,
"standardConformingStrings": true,
"synchronizeSeqscans": true,
"transformNullEquals": true,
"exitOnError": true,
"seqPageCost": "number",
"randomPageCost": "number",
"autovacuumMaxWorkers": "integer",
"autovacuumVacuumCostDelay": "integer",
"autovacuumVacuumCostLimit": "integer",
"autovacuumNaptime": "integer",
"archiveTimeout": "integer",
"trackActivityQuerySize": "integer",
"enableBitmapscan": true,
"enableHashagg": true,
"enableHashjoin": true,
"enableIndexscan": true,
"enableIndexonlyscan": true,
"enableMaterial": true,
"enableMergejoin": true,
"enableNestloop": true,
"enableSeqscan": true,
"enableSort": true,
"enableTidscan": true,
"maxWorkerProcesses": "integer",
"maxParallelWorkers": "integer",
"maxParallelWorkersPerGather": "integer",
"autovacuumVacuumScaleFactor": "number",
"autovacuumAnalyzeScaleFactor": "number",
"defaultTransactionReadOnly": true,
"timezone": "string",
"effectiveIoConcurrency": "integer",
"effectiveCacheSize": "integer",
"sharedPreloadLibraries": [
"string"
],
"autoExplainLogMinDuration": "integer",
"autoExplainLogAnalyze": true,
"autoExplainLogBuffers": true,
"autoExplainLogTiming": true,
"autoExplainLogTriggers": true,
"autoExplainLogVerbose": true,
"autoExplainLogNestedStatements": true,
"autoExplainSampleRate": "number",
"pgHintPlanEnableHint": true,
"pgHintPlanEnableHintTable": true,
"pgHintPlanDebugPrint": "string",
"pgHintPlanMessageLevel": "string",
"pgQualstatsEnabled": true,
"pgQualstatsTrackConstants": true,
"pgQualstatsMax": "integer",
"pgQualstatsResolveOids": true,
"pgQualstatsSampleRate": "number",
"maxStackDepth": "integer",
"geqo": true,
"geqoThreshold": "integer",
"geqoEffort": "integer",
"geqoPoolSize": "integer",
"geqoGenerations": "integer",
"geqoSelectionBias": "number",
"geqoSeed": "number"
},
"postgresqlConfig_11": {
"maxConnections": "integer",
"sharedBuffers": "integer",
"tempBuffers": "integer",
"maxPreparedTransactions": "integer",
"workMem": "integer",
"maintenanceWorkMem": "integer",
"autovacuumWorkMem": "integer",
"tempFileLimit": "integer",
"vacuumCostDelay": "integer",
"vacuumCostPageHit": "integer",
"vacuumCostPageMiss": "integer",
"vacuumCostPageDirty": "integer",
"vacuumCostLimit": "integer",
"bgwriterDelay": "integer",
"bgwriterLruMaxpages": "integer",
"bgwriterLruMultiplier": "number",
"bgwriterFlushAfter": "integer",
"backendFlushAfter": "integer",
"oldSnapshotThreshold": "integer",
"walLevel": "string",
"synchronousCommit": "string",
"checkpointTimeout": "integer",
"checkpointCompletionTarget": "number",
"checkpointFlushAfter": "integer",
"maxWalSize": "integer",
"minWalSize": "integer",
"maxStandbyStreamingDelay": "integer",
"defaultStatisticsTarget": "integer",
"constraintExclusion": "string",
"cursorTupleFraction": "number",
"fromCollapseLimit": "integer",
"joinCollapseLimit": "integer",
"forceParallelMode": "string",
"clientMinMessages": "string",
"logMinMessages": "string",
"logMinErrorStatement": "string",
"logMinDurationStatement": "integer",
"logCheckpoints": true,
"logConnections": true,
"logDisconnections": true,
"logDuration": true,
"logErrorVerbosity": "string",
"logLockWaits": true,
"logStatement": "string",
"logTempFiles": "integer",
"searchPath": "string",
"rowSecurity": true,
"defaultTransactionIsolation": "string",
"statementTimeout": "integer",
"lockTimeout": "integer",
"idleInTransactionSessionTimeout": "integer",
"byteaOutput": "string",
"xmlbinary": "string",
"xmloption": "string",
"ginPendingListLimit": "integer",
"deadlockTimeout": "integer",
"maxLocksPerTransaction": "integer",
"maxPredLocksPerTransaction": "integer",
"arrayNulls": true,
"backslashQuote": "string",
"defaultWithOids": true,
"escapeStringWarning": true,
"loCompatPrivileges": true,
"operatorPrecedenceWarning": true,
"quoteAllIdentifiers": true,
"standardConformingStrings": true,
"synchronizeSeqscans": true,
"transformNullEquals": true,
"exitOnError": true,
"seqPageCost": "number",
"randomPageCost": "number",
"autovacuumMaxWorkers": "integer",
"autovacuumVacuumCostDelay": "integer",
"autovacuumVacuumCostLimit": "integer",
"autovacuumNaptime": "integer",
"archiveTimeout": "integer",
"trackActivityQuerySize": "integer",
"enableBitmapscan": true,
"enableHashagg": true,
"enableHashjoin": true,
"enableIndexscan": true,
"enableIndexonlyscan": true,
"enableMaterial": true,
"enableMergejoin": true,
"enableNestloop": true,
"enableSeqscan": true,
"enableSort": true,
"enableTidscan": true,
"maxWorkerProcesses": "integer",
"maxParallelWorkers": "integer",
"maxParallelWorkersPerGather": "integer",
"autovacuumVacuumScaleFactor": "number",
"autovacuumAnalyzeScaleFactor": "number",
"defaultTransactionReadOnly": true,
"timezone": "string",
"enableParallelAppend": true,
"enableParallelHash": true,
"enablePartitionPruning": true,
"enablePartitionwiseAggregate": true,
"enablePartitionwiseJoin": true,
"jit": true,
"maxParallelMaintenanceWorkers": "integer",
"parallelLeaderParticipation": true,
"vacuumCleanupIndexScaleFactor": "number",
"effectiveIoConcurrency": "integer",
"effectiveCacheSize": "integer",
"sharedPreloadLibraries": [
"string"
],
"autoExplainLogMinDuration": "integer",
"autoExplainLogAnalyze": true,
"autoExplainLogBuffers": true,
"autoExplainLogTiming": true,
"autoExplainLogTriggers": true,
"autoExplainLogVerbose": true,
"autoExplainLogNestedStatements": true,
"autoExplainSampleRate": "number",
"pgHintPlanEnableHint": true,
"pgHintPlanEnableHintTable": true,
"pgHintPlanDebugPrint": "string",
"pgHintPlanMessageLevel": "string",
"pgQualstatsEnabled": true,
"pgQualstatsTrackConstants": true,
"pgQualstatsMax": "integer",
"pgQualstatsResolveOids": true,
"pgQualstatsSampleRate": "number",
"maxStackDepth": "integer",
"geqo": true,
"geqoThreshold": "integer",
"geqoEffort": "integer",
"geqoPoolSize": "integer",
"geqoGenerations": "integer",
"geqoSelectionBias": "number",
"geqoSeed": "number",
"pgTrgmSimilarityThreshold": "number",
"pgTrgmWordSimilarityThreshold": "number",
"pgTrgmStrictWordSimilarityThreshold": "number"
},
"postgresqlConfig_11_1C": {
"maxConnections": "integer",
"sharedBuffers": "integer",
"tempBuffers": "integer",
"maxPreparedTransactions": "integer",
"workMem": "integer",
"maintenanceWorkMem": "integer",
"autovacuumWorkMem": "integer",
"tempFileLimit": "integer",
"vacuumCostDelay": "integer",
"vacuumCostPageHit": "integer",
"vacuumCostPageMiss": "integer",
"vacuumCostPageDirty": "integer",
"vacuumCostLimit": "integer",
"bgwriterDelay": "integer",
"bgwriterLruMaxpages": "integer",
"bgwriterLruMultiplier": "number",
"bgwriterFlushAfter": "integer",
"backendFlushAfter": "integer",
"oldSnapshotThreshold": "integer",
"walLevel": "string",
"synchronousCommit": "string",
"checkpointTimeout": "integer",
"checkpointCompletionTarget": "number",
"checkpointFlushAfter": "integer",
"maxWalSize": "integer",
"minWalSize": "integer",
"maxStandbyStreamingDelay": "integer",
"defaultStatisticsTarget": "integer",
"constraintExclusion": "string",
"cursorTupleFraction": "number",
"fromCollapseLimit": "integer",
"joinCollapseLimit": "integer",
"forceParallelMode": "string",
"clientMinMessages": "string",
"logMinMessages": "string",
"logMinErrorStatement": "string",
"logMinDurationStatement": "integer",
"logCheckpoints": true,
"logConnections": true,
"logDisconnections": true,
"logDuration": true,
"logErrorVerbosity": "string",
"logLockWaits": true,
"logStatement": "string",
"logTempFiles": "integer",
"searchPath": "string",
"rowSecurity": true,
"defaultTransactionIsolation": "string",
"statementTimeout": "integer",
"lockTimeout": "integer",
"idleInTransactionSessionTimeout": "integer",
"byteaOutput": "string",
"xmlbinary": "string",
"xmloption": "string",
"ginPendingListLimit": "integer",
"deadlockTimeout": "integer",
"maxLocksPerTransaction": "integer",
"maxPredLocksPerTransaction": "integer",
"arrayNulls": true,
"backslashQuote": "string",
"defaultWithOids": true,
"escapeStringWarning": true,
"loCompatPrivileges": true,
"operatorPrecedenceWarning": true,
"quoteAllIdentifiers": true,
"standardConformingStrings": true,
"synchronizeSeqscans": true,
"transformNullEquals": true,
"exitOnError": true,
"seqPageCost": "number",
"randomPageCost": "number",
"autovacuumMaxWorkers": "integer",
"autovacuumVacuumCostDelay": "integer",
"autovacuumVacuumCostLimit": "integer",
"autovacuumNaptime": "integer",
"archiveTimeout": "integer",
"trackActivityQuerySize": "integer",
"onlineAnalyzeEnable": true,
"enableBitmapscan": true,
"enableHashagg": true,
"enableHashjoin": true,
"enableIndexscan": true,
"enableIndexonlyscan": true,
"enableMaterial": true,
"enableMergejoin": true,
"enableNestloop": true,
"enableSeqscan": true,
"enableSort": true,
"enableTidscan": true,
"maxWorkerProcesses": "integer",
"maxParallelWorkers": "integer",
"maxParallelWorkersPerGather": "integer",
"autovacuumVacuumScaleFactor": "number",
"autovacuumAnalyzeScaleFactor": "number",
"defaultTransactionReadOnly": true,
"timezone": "string",
"enableParallelAppend": true,
"enableParallelHash": true,
"enablePartitionPruning": true,
"enablePartitionwiseAggregate": true,
"enablePartitionwiseJoin": true,
"jit": true,
"maxParallelMaintenanceWorkers": "integer",
"parallelLeaderParticipation": true,
"vacuumCleanupIndexScaleFactor": "number",
"effectiveIoConcurrency": "integer",
"effectiveCacheSize": "integer",
"sharedPreloadLibraries": [
"string"
],
"autoExplainLogMinDuration": "integer",
"autoExplainLogAnalyze": true,
"autoExplainLogBuffers": true,
"autoExplainLogTiming": true,
"autoExplainLogTriggers": true,
"autoExplainLogVerbose": true,
"autoExplainLogNestedStatements": true,
"autoExplainSampleRate": "number",
"pgHintPlanEnableHint": true,
"pgHintPlanEnableHintTable": true,
"pgHintPlanDebugPrint": "string",
"pgHintPlanMessageLevel": "string",
"pgQualstatsEnabled": true,
"pgQualstatsTrackConstants": true,
"pgQualstatsMax": "integer",
"pgQualstatsResolveOids": true,
"pgQualstatsSampleRate": "number",
"plantunerFixEmptyTable": true,
"maxStackDepth": "integer",
"geqo": true,
"geqoThreshold": "integer",
"geqoEffort": "integer",
"geqoPoolSize": "integer",
"geqoGenerations": "integer",
"geqoSelectionBias": "number",
"geqoSeed": "number",
"pgTrgmSimilarityThreshold": "number",
"pgTrgmWordSimilarityThreshold": "number",
"pgTrgmStrictWordSimilarityThreshold": "number"
},
"postgresqlConfig_12": {
"maxConnections": "integer",
"sharedBuffers": "integer",
"tempBuffers": "integer",
"maxPreparedTransactions": "integer",
"workMem": "integer",
"maintenanceWorkMem": "integer",
"autovacuumWorkMem": "integer",
"tempFileLimit": "integer",
"vacuumCostDelay": "integer",
"vacuumCostPageHit": "integer",
"vacuumCostPageMiss": "integer",
"vacuumCostPageDirty": "integer",
"vacuumCostLimit": "integer",
"bgwriterDelay": "integer",
"bgwriterLruMaxpages": "integer",
"bgwriterLruMultiplier": "number",
"bgwriterFlushAfter": "integer",
"backendFlushAfter": "integer",
"oldSnapshotThreshold": "integer",
"walLevel": "string",
"synchronousCommit": "string",
"checkpointTimeout": "integer",
"checkpointCompletionTarget": "number",
"checkpointFlushAfter": "integer",
"maxWalSize": "integer",
"minWalSize": "integer",
"maxStandbyStreamingDelay": "integer",
"defaultStatisticsTarget": "integer",
"constraintExclusion": "string",
"cursorTupleFraction": "number",
"fromCollapseLimit": "integer",
"joinCollapseLimit": "integer",
"forceParallelMode": "string",
"clientMinMessages": "string",
"logMinMessages": "string",
"logMinErrorStatement": "string",
"logMinDurationStatement": "integer",
"logCheckpoints": true,
"logConnections": true,
"logDisconnections": true,
"logDuration": true,
"logErrorVerbosity": "string",
"logLockWaits": true,
"logStatement": "string",
"logTempFiles": "integer",
"searchPath": "string",
"rowSecurity": true,
"defaultTransactionIsolation": "string",
"statementTimeout": "integer",
"lockTimeout": "integer",
"idleInTransactionSessionTimeout": "integer",
"byteaOutput": "string",
"xmlbinary": "string",
"xmloption": "string",
"ginPendingListLimit": "integer",
"deadlockTimeout": "integer",
"maxLocksPerTransaction": "integer",
"maxPredLocksPerTransaction": "integer",
"arrayNulls": true,
"backslashQuote": "string",
"defaultWithOids": true,
"escapeStringWarning": true,
"loCompatPrivileges": true,
"operatorPrecedenceWarning": true,
"quoteAllIdentifiers": true,
"standardConformingStrings": true,
"synchronizeSeqscans": true,
"transformNullEquals": true,
"exitOnError": true,
"seqPageCost": "number",
"randomPageCost": "number",
"autovacuumMaxWorkers": "integer",
"autovacuumVacuumCostDelay": "integer",
"autovacuumVacuumCostLimit": "integer",
"autovacuumNaptime": "integer",
"archiveTimeout": "integer",
"trackActivityQuerySize": "integer",
"enableBitmapscan": true,
"enableHashagg": true,
"enableHashjoin": true,
"enableIndexscan": true,
"enableIndexonlyscan": true,
"enableMaterial": true,
"enableMergejoin": true,
"enableNestloop": true,
"enableSeqscan": true,
"enableSort": true,
"enableTidscan": true,
"maxWorkerProcesses": "integer",
"maxParallelWorkers": "integer",
"maxParallelWorkersPerGather": "integer",
"autovacuumVacuumScaleFactor": "number",
"autovacuumAnalyzeScaleFactor": "number",
"defaultTransactionReadOnly": true,
"timezone": "string",
"enableParallelAppend": true,
"enableParallelHash": true,
"enablePartitionPruning": true,
"enablePartitionwiseAggregate": true,
"enablePartitionwiseJoin": true,
"jit": true,
"maxParallelMaintenanceWorkers": "integer",
"parallelLeaderParticipation": true,
"vacuumCleanupIndexScaleFactor": "number",
"logTransactionSampleRate": "number",
"planCacheMode": "string",
"effectiveIoConcurrency": "integer",
"effectiveCacheSize": "integer",
"sharedPreloadLibraries": [
"string"
],
"autoExplainLogMinDuration": "integer",
"autoExplainLogAnalyze": true,
"autoExplainLogBuffers": true,
"autoExplainLogTiming": true,
"autoExplainLogTriggers": true,
"autoExplainLogVerbose": true,
"autoExplainLogNestedStatements": true,
"autoExplainSampleRate": "number",
"pgHintPlanEnableHint": true,
"pgHintPlanEnableHintTable": true,
"pgHintPlanDebugPrint": "string",
"pgHintPlanMessageLevel": "string",
"pgQualstatsEnabled": true,
"pgQualstatsTrackConstants": true,
"pgQualstatsMax": "integer",
"pgQualstatsResolveOids": true,
"pgQualstatsSampleRate": "number",
"maxStackDepth": "integer",
"geqo": true,
"geqoThreshold": "integer",
"geqoEffort": "integer",
"geqoPoolSize": "integer",
"geqoGenerations": "integer",
"geqoSelectionBias": "number",
"geqoSeed": "number",
"pgTrgmSimilarityThreshold": "number",
"pgTrgmWordSimilarityThreshold": "number",
"pgTrgmStrictWordSimilarityThreshold": "number"
},
"postgresqlConfig_12_1C": {
"maxConnections": "integer",
"sharedBuffers": "integer",
"tempBuffers": "integer",
"maxPreparedTransactions": "integer",
"workMem": "integer",
"maintenanceWorkMem": "integer",
"autovacuumWorkMem": "integer",
"tempFileLimit": "integer",
"vacuumCostDelay": "integer",
"vacuumCostPageHit": "integer",
"vacuumCostPageMiss": "integer",
"vacuumCostPageDirty": "integer",
"vacuumCostLimit": "integer",
"bgwriterDelay": "integer",
"bgwriterLruMaxpages": "integer",
"bgwriterLruMultiplier": "number",
"bgwriterFlushAfter": "integer",
"backendFlushAfter": "integer",
"oldSnapshotThreshold": "integer",
"walLevel": "string",
"synchronousCommit": "string",
"checkpointTimeout": "integer",
"checkpointCompletionTarget": "number",
"checkpointFlushAfter": "integer",
"maxWalSize": "integer",
"minWalSize": "integer",
"maxStandbyStreamingDelay": "integer",
"defaultStatisticsTarget": "integer",
"constraintExclusion": "string",
"cursorTupleFraction": "number",
"fromCollapseLimit": "integer",
"joinCollapseLimit": "integer",
"forceParallelMode": "string",
"clientMinMessages": "string",
"logMinMessages": "string",
"logMinErrorStatement": "string",
"logMinDurationStatement": "integer",
"logCheckpoints": true,
"logConnections": true,
"logDisconnections": true,
"logDuration": true,
"logErrorVerbosity": "string",
"logLockWaits": true,
"logStatement": "string",
"logTempFiles": "integer",
"searchPath": "string",
"rowSecurity": true,
"defaultTransactionIsolation": "string",
"statementTimeout": "integer",
"lockTimeout": "integer",
"idleInTransactionSessionTimeout": "integer",
"byteaOutput": "string",
"xmlbinary": "string",
"xmloption": "string",
"ginPendingListLimit": "integer",
"deadlockTimeout": "integer",
"maxLocksPerTransaction": "integer",
"maxPredLocksPerTransaction": "integer",
"arrayNulls": true,
"backslashQuote": "string",
"defaultWithOids": true,
"escapeStringWarning": true,
"loCompatPrivileges": true,
"operatorPrecedenceWarning": true,
"quoteAllIdentifiers": true,
"standardConformingStrings": true,
"synchronizeSeqscans": true,
"transformNullEquals": true,
"exitOnError": true,
"seqPageCost": "number",
"randomPageCost": "number",
"autovacuumMaxWorkers": "integer",
"autovacuumVacuumCostDelay": "integer",
"autovacuumVacuumCostLimit": "integer",
"autovacuumNaptime": "integer",
"archiveTimeout": "integer",
"trackActivityQuerySize": "integer",
"onlineAnalyzeEnable": true,
"enableBitmapscan": true,
"enableHashagg": true,
"enableHashjoin": true,
"enableIndexscan": true,
"enableIndexonlyscan": true,
"enableMaterial": true,
"enableMergejoin": true,
"enableNestloop": true,
"enableSeqscan": true,
"enableSort": true,
"enableTidscan": true,
"maxWorkerProcesses": "integer",
"maxParallelWorkers": "integer",
"maxParallelWorkersPerGather": "integer",
"autovacuumVacuumScaleFactor": "number",
"autovacuumAnalyzeScaleFactor": "number",
"defaultTransactionReadOnly": true,
"timezone": "string",
"enableParallelAppend": true,
"enableParallelHash": true,
"enablePartitionPruning": true,
"enablePartitionwiseAggregate": true,
"enablePartitionwiseJoin": true,
"jit": true,
"maxParallelMaintenanceWorkers": "integer",
"parallelLeaderParticipation": true,
"vacuumCleanupIndexScaleFactor": "number",
"logTransactionSampleRate": "number",
"planCacheMode": "string",
"effectiveIoConcurrency": "integer",
"effectiveCacheSize": "integer",
"sharedPreloadLibraries": [
"string"
],
"autoExplainLogMinDuration": "integer",
"autoExplainLogAnalyze": true,
"autoExplainLogBuffers": true,
"autoExplainLogTiming": true,
"autoExplainLogTriggers": true,
"autoExplainLogVerbose": true,
"autoExplainLogNestedStatements": true,
"autoExplainSampleRate": "number",
"pgHintPlanEnableHint": true,
"pgHintPlanEnableHintTable": true,
"pgHintPlanDebugPrint": "string",
"pgHintPlanMessageLevel": "string",
"pgQualstatsEnabled": true,
"pgQualstatsTrackConstants": true,
"pgQualstatsMax": "integer",
"pgQualstatsResolveOids": true,
"pgQualstatsSampleRate": "number",
"plantunerFixEmptyTable": true,
"maxStackDepth": "integer",
"geqo": true,
"geqoThreshold": "integer",
"geqoEffort": "integer",
"geqoPoolSize": "integer",
"geqoGenerations": "integer",
"geqoSelectionBias": "number",
"geqoSeed": "number",
"pgTrgmSimilarityThreshold": "number",
"pgTrgmWordSimilarityThreshold": "number",
"pgTrgmStrictWordSimilarityThreshold": "number"
},
"postgresqlConfig_13": {
"maxConnections": "integer",
"sharedBuffers": "integer",
"tempBuffers": "integer",
"maxPreparedTransactions": "integer",
"workMem": "integer",
"maintenanceWorkMem": "integer",
"autovacuumWorkMem": "integer",
"tempFileLimit": "integer",
"vacuumCostDelay": "integer",
"vacuumCostPageHit": "integer",
"vacuumCostPageMiss": "integer",
"vacuumCostPageDirty": "integer",
"vacuumCostLimit": "integer",
"bgwriterDelay": "integer",
"bgwriterLruMaxpages": "integer",
"bgwriterLruMultiplier": "number",
"bgwriterFlushAfter": "integer",
"backendFlushAfter": "integer",
"oldSnapshotThreshold": "integer",
"walLevel": "string",
"synchronousCommit": "string",
"checkpointTimeout": "integer",
"checkpointCompletionTarget": "number",
"checkpointFlushAfter": "integer",
"maxWalSize": "integer",
"minWalSize": "integer",
"maxStandbyStreamingDelay": "integer",
"defaultStatisticsTarget": "integer",
"constraintExclusion": "string",
"cursorTupleFraction": "number",
"fromCollapseLimit": "integer",
"joinCollapseLimit": "integer",
"forceParallelMode": "string",
"clientMinMessages": "string",
"logMinMessages": "string",
"logMinErrorStatement": "string",
"logMinDurationStatement": "integer",
"logCheckpoints": true,
"logConnections": true,
"logDisconnections": true,
"logDuration": true,
"logErrorVerbosity": "string",
"logLockWaits": true,
"logStatement": "string",
"logTempFiles": "integer",
"searchPath": "string",
"rowSecurity": true,
"defaultTransactionIsolation": "string",
"statementTimeout": "integer",
"lockTimeout": "integer",
"idleInTransactionSessionTimeout": "integer",
"byteaOutput": "string",
"xmlbinary": "string",
"xmloption": "string",
"ginPendingListLimit": "integer",
"deadlockTimeout": "integer",
"maxLocksPerTransaction": "integer",
"maxPredLocksPerTransaction": "integer",
"arrayNulls": true,
"backslashQuote": "string",
"defaultWithOids": true,
"escapeStringWarning": true,
"loCompatPrivileges": true,
"operatorPrecedenceWarning": true,
"quoteAllIdentifiers": true,
"standardConformingStrings": true,
"synchronizeSeqscans": true,
"transformNullEquals": true,
"exitOnError": true,
"seqPageCost": "number",
"randomPageCost": "number",
"autovacuumMaxWorkers": "integer",
"autovacuumVacuumCostDelay": "integer",
"autovacuumVacuumCostLimit": "integer",
"autovacuumNaptime": "integer",
"archiveTimeout": "integer",
"trackActivityQuerySize": "integer",
"enableBitmapscan": true,
"enableHashagg": true,
"enableHashjoin": true,
"enableIndexscan": true,
"enableIndexonlyscan": true,
"enableMaterial": true,
"enableMergejoin": true,
"enableNestloop": true,
"enableSeqscan": true,
"enableSort": true,
"enableTidscan": true,
"maxWorkerProcesses": "integer",
"maxParallelWorkers": "integer",
"maxParallelWorkersPerGather": "integer",
"autovacuumVacuumScaleFactor": "number",
"autovacuumAnalyzeScaleFactor": "number",
"defaultTransactionReadOnly": true,
"timezone": "string",
"enableParallelAppend": true,
"enableParallelHash": true,
"enablePartitionPruning": true,
"enablePartitionwiseAggregate": true,
"enablePartitionwiseJoin": true,
"jit": true,
"maxParallelMaintenanceWorkers": "integer",
"parallelLeaderParticipation": true,
"vacuumCleanupIndexScaleFactor": "number",
"logTransactionSampleRate": "number",
"planCacheMode": "string",
"effectiveIoConcurrency": "integer",
"effectiveCacheSize": "integer",
"sharedPreloadLibraries": [
"string"
],
"autoExplainLogMinDuration": "integer",
"autoExplainLogAnalyze": true,
"autoExplainLogBuffers": true,
"autoExplainLogTiming": true,
"autoExplainLogTriggers": true,
"autoExplainLogVerbose": true,
"autoExplainLogNestedStatements": true,
"autoExplainSampleRate": "number",
"pgHintPlanEnableHint": true,
"pgHintPlanEnableHintTable": true,
"pgHintPlanDebugPrint": "string",
"pgHintPlanMessageLevel": "string",
"hashMemMultiplier": "number",
"logicalDecodingWorkMem": "integer",
"maintenanceIoConcurrency": "integer",
"maxSlotWalKeepSize": "integer",
"walKeepSize": "integer",
"enableIncrementalSort": true,
"autovacuumVacuumInsertThreshold": "integer",
"autovacuumVacuumInsertScaleFactor": "number",
"logMinDurationSample": "integer",
"logStatementSampleRate": "number",
"logParameterMaxLength": "integer",
"logParameterMaxLengthOnError": "integer",
"pgQualstatsEnabled": true,
"pgQualstatsTrackConstants": true,
"pgQualstatsMax": "integer",
"pgQualstatsResolveOids": true,
"pgQualstatsSampleRate": "number",
"maxStackDepth": "integer",
"geqo": true,
"geqoThreshold": "integer",
"geqoEffort": "integer",
"geqoPoolSize": "integer",
"geqoGenerations": "integer",
"geqoSelectionBias": "number",
"geqoSeed": "number",
"pgTrgmSimilarityThreshold": "number",
"pgTrgmWordSimilarityThreshold": "number",
"pgTrgmStrictWordSimilarityThreshold": "number"
},
"postgresqlConfig_13_1C": {
"maxConnections": "integer",
"sharedBuffers": "integer",
"tempBuffers": "integer",
"maxPreparedTransactions": "integer",
"workMem": "integer",
"maintenanceWorkMem": "integer",
"autovacuumWorkMem": "integer",
"tempFileLimit": "integer",
"vacuumCostDelay": "integer",
"vacuumCostPageHit": "integer",
"vacuumCostPageMiss": "integer",
"vacuumCostPageDirty": "integer",
"vacuumCostLimit": "integer",
"bgwriterDelay": "integer",
"bgwriterLruMaxpages": "integer",
"bgwriterLruMultiplier": "number",
"bgwriterFlushAfter": "integer",
"backendFlushAfter": "integer",
"oldSnapshotThreshold": "integer",
"walLevel": "string",
"synchronousCommit": "string",
"checkpointTimeout": "integer",
"checkpointCompletionTarget": "number",
"checkpointFlushAfter": "integer",
"maxWalSize": "integer",
"minWalSize": "integer",
"maxStandbyStreamingDelay": "integer",
"defaultStatisticsTarget": "integer",
"constraintExclusion": "string",
"cursorTupleFraction": "number",
"fromCollapseLimit": "integer",
"joinCollapseLimit": "integer",
"forceParallelMode": "string",
"clientMinMessages": "string",
"logMinMessages": "string",
"logMinErrorStatement": "string",
"logMinDurationStatement": "integer",
"logCheckpoints": true,
"logConnections": true,
"logDisconnections": true,
"logDuration": true,
"logErrorVerbosity": "string",
"logLockWaits": true,
"logStatement": "string",
"logTempFiles": "integer",
"searchPath": "string",
"rowSecurity": true,
"defaultTransactionIsolation": "string",
"statementTimeout": "integer",
"lockTimeout": "integer",
"idleInTransactionSessionTimeout": "integer",
"byteaOutput": "string",
"xmlbinary": "string",
"xmloption": "string",
"ginPendingListLimit": "integer",
"deadlockTimeout": "integer",
"maxLocksPerTransaction": "integer",
"maxPredLocksPerTransaction": "integer",
"arrayNulls": true,
"backslashQuote": "string",
"defaultWithOids": true,
"escapeStringWarning": true,
"loCompatPrivileges": true,
"operatorPrecedenceWarning": true,
"quoteAllIdentifiers": true,
"standardConformingStrings": true,
"synchronizeSeqscans": true,
"transformNullEquals": true,
"exitOnError": true,
"seqPageCost": "number",
"randomPageCost": "number",
"autovacuumMaxWorkers": "integer",
"autovacuumVacuumCostDelay": "integer",
"autovacuumVacuumCostLimit": "integer",
"autovacuumNaptime": "integer",
"archiveTimeout": "integer",
"trackActivityQuerySize": "integer",
"onlineAnalyzeEnable": true,
"enableBitmapscan": true,
"enableHashagg": true,
"enableHashjoin": true,
"enableIndexscan": true,
"enableIndexonlyscan": true,
"enableMaterial": true,
"enableMergejoin": true,
"enableNestloop": true,
"enableSeqscan": true,
"enableSort": true,
"enableTidscan": true,
"maxWorkerProcesses": "integer",
"maxParallelWorkers": "integer",
"maxParallelWorkersPerGather": "integer",
"autovacuumVacuumScaleFactor": "number",
"autovacuumAnalyzeScaleFactor": "number",
"defaultTransactionReadOnly": true,
"timezone": "string",
"enableParallelAppend": true,
"enableParallelHash": true,
"enablePartitionPruning": true,
"enablePartitionwiseAggregate": true,
"enablePartitionwiseJoin": true,
"jit": true,
"maxParallelMaintenanceWorkers": "integer",
"parallelLeaderParticipation": true,
"vacuumCleanupIndexScaleFactor": "number",
"logTransactionSampleRate": "number",
"planCacheMode": "string",
"effectiveIoConcurrency": "integer",
"effectiveCacheSize": "integer",
"sharedPreloadLibraries": [
"string"
],
"autoExplainLogMinDuration": "integer",
"autoExplainLogAnalyze": true,
"autoExplainLogBuffers": true,
"autoExplainLogTiming": true,
"autoExplainLogTriggers": true,
"autoExplainLogVerbose": true,
"autoExplainLogNestedStatements": true,
"autoExplainSampleRate": "number",
"pgHintPlanEnableHint": true,
"pgHintPlanEnableHintTable": true,
"pgHintPlanDebugPrint": "string",
"pgHintPlanMessageLevel": "string",
"hashMemMultiplier": "number",
"logicalDecodingWorkMem": "integer",
"maintenanceIoConcurrency": "integer",
"maxSlotWalKeepSize": "integer",
"walKeepSize": "integer",
"enableIncrementalSort": true,
"autovacuumVacuumInsertThreshold": "integer",
"autovacuumVacuumInsertScaleFactor": "number",
"logMinDurationSample": "integer",
"logStatementSampleRate": "number",
"logParameterMaxLength": "integer",
"logParameterMaxLengthOnError": "integer",
"pgQualstatsEnabled": true,
"pgQualstatsTrackConstants": true,
"pgQualstatsMax": "integer",
"pgQualstatsResolveOids": true,
"pgQualstatsSampleRate": "number",
"plantunerFixEmptyTable": true,
"geqo": true,
"geqoThreshold": "integer",
"geqoEffort": "integer",
"geqoPoolSize": "integer",
"geqoGenerations": "integer",
"geqoSelectionBias": "number",
"geqoSeed": "number",
"pgTrgmSimilarityThreshold": "number",
"pgTrgmWordSimilarityThreshold": "number",
"pgTrgmStrictWordSimilarityThreshold": "number"
},
"postgresqlConfig_14": {
"maxConnections": "integer",
"sharedBuffers": "integer",
"tempBuffers": "integer",
"maxPreparedTransactions": "integer",
"workMem": "integer",
"maintenanceWorkMem": "integer",
"autovacuumWorkMem": "integer",
"tempFileLimit": "integer",
"vacuumCostDelay": "integer",
"vacuumCostPageHit": "integer",
"vacuumCostPageMiss": "integer",
"vacuumCostPageDirty": "integer",
"vacuumCostLimit": "integer",
"bgwriterDelay": "integer",
"bgwriterLruMaxpages": "integer",
"bgwriterLruMultiplier": "number",
"bgwriterFlushAfter": "integer",
"backendFlushAfter": "integer",
"oldSnapshotThreshold": "integer",
"walLevel": "string",
"synchronousCommit": "string",
"checkpointTimeout": "integer",
"checkpointCompletionTarget": "number",
"checkpointFlushAfter": "integer",
"maxWalSize": "integer",
"minWalSize": "integer",
"maxStandbyStreamingDelay": "integer",
"defaultStatisticsTarget": "integer",
"constraintExclusion": "string",
"cursorTupleFraction": "number",
"fromCollapseLimit": "integer",
"joinCollapseLimit": "integer",
"forceParallelMode": "string",
"clientMinMessages": "string",
"logMinMessages": "string",
"logMinErrorStatement": "string",
"logMinDurationStatement": "integer",
"logCheckpoints": true,
"logConnections": true,
"logDisconnections": true,
"logDuration": true,
"logErrorVerbosity": "string",
"logLockWaits": true,
"logStatement": "string",
"logTempFiles": "integer",
"searchPath": "string",
"rowSecurity": true,
"defaultTransactionIsolation": "string",
"statementTimeout": "integer",
"lockTimeout": "integer",
"idleInTransactionSessionTimeout": "integer",
"byteaOutput": "string",
"xmlbinary": "string",
"xmloption": "string",
"ginPendingListLimit": "integer",
"deadlockTimeout": "integer",
"maxLocksPerTransaction": "integer",
"maxPredLocksPerTransaction": "integer",
"arrayNulls": true,
"backslashQuote": "string",
"defaultWithOids": true,
"escapeStringWarning": true,
"loCompatPrivileges": true,
"quoteAllIdentifiers": true,
"standardConformingStrings": true,
"synchronizeSeqscans": true,
"transformNullEquals": true,
"exitOnError": true,
"seqPageCost": "number",
"randomPageCost": "number",
"autovacuumMaxWorkers": "integer",
"autovacuumVacuumCostDelay": "integer",
"autovacuumVacuumCostLimit": "integer",
"autovacuumNaptime": "integer",
"archiveTimeout": "integer",
"trackActivityQuerySize": "integer",
"enableBitmapscan": true,
"enableHashagg": true,
"enableHashjoin": true,
"enableIndexscan": true,
"enableIndexonlyscan": true,
"enableMaterial": true,
"enableMergejoin": true,
"enableNestloop": true,
"enableSeqscan": true,
"enableSort": true,
"enableTidscan": true,
"maxWorkerProcesses": "integer",
"maxParallelWorkers": "integer",
"maxParallelWorkersPerGather": "integer",
"autovacuumVacuumScaleFactor": "number",
"autovacuumAnalyzeScaleFactor": "number",
"defaultTransactionReadOnly": true,
"timezone": "string",
"enableParallelAppend": true,
"enableParallelHash": true,
"enablePartitionPruning": true,
"enablePartitionwiseAggregate": true,
"enablePartitionwiseJoin": true,
"jit": true,
"maxParallelMaintenanceWorkers": "integer",
"parallelLeaderParticipation": true,
"logTransactionSampleRate": "number",
"planCacheMode": "string",
"effectiveIoConcurrency": "integer",
"effectiveCacheSize": "integer",
"sharedPreloadLibraries": [
"string"
],
"autoExplainLogMinDuration": "integer",
"autoExplainLogAnalyze": true,
"autoExplainLogBuffers": true,
"autoExplainLogTiming": true,
"autoExplainLogTriggers": true,
"autoExplainLogVerbose": true,
"autoExplainLogNestedStatements": true,
"autoExplainSampleRate": "number",
"pgHintPlanEnableHint": true,
"pgHintPlanEnableHintTable": true,
"pgHintPlanDebugPrint": "string",
"pgHintPlanMessageLevel": "string",
"hashMemMultiplier": "number",
"logicalDecodingWorkMem": "integer",
"maintenanceIoConcurrency": "integer",
"maxSlotWalKeepSize": "integer",
"walKeepSize": "integer",
"enableIncrementalSort": true,
"autovacuumVacuumInsertThreshold": "integer",
"autovacuumVacuumInsertScaleFactor": "number",
"logMinDurationSample": "integer",
"logStatementSampleRate": "number",
"logParameterMaxLength": "integer",
"logParameterMaxLengthOnError": "integer",
"clientConnectionCheckInterval": "integer",
"enableAsyncAppend": true,
"enableGathermerge": true,
"enableMemoize": true,
"logRecoveryConflictWaits": true,
"vacuumFailsafeAge": "integer",
"vacuumMultixactFailsafeAge": "integer",
"pgQualstatsEnabled": true,
"pgQualstatsTrackConstants": true,
"pgQualstatsMax": "integer",
"pgQualstatsResolveOids": true,
"pgQualstatsSampleRate": "number",
"maxStackDepth": "integer",
"geqo": true,
"geqoThreshold": "integer",
"geqoEffort": "integer",
"geqoPoolSize": "integer",
"geqoGenerations": "integer",
"geqoSelectionBias": "number",
"geqoSeed": "number",
"pgTrgmSimilarityThreshold": "number",
"pgTrgmWordSimilarityThreshold": "number",
"pgTrgmStrictWordSimilarityThreshold": "number"
},
"postgresqlConfig_14_1C": {
"maxConnections": "integer",
"sharedBuffers": "integer",
"tempBuffers": "integer",
"maxPreparedTransactions": "integer",
"workMem": "integer",
"maintenanceWorkMem": "integer",
"autovacuumWorkMem": "integer",
"tempFileLimit": "integer",
"vacuumCostDelay": "integer",
"vacuumCostPageHit": "integer",
"vacuumCostPageMiss": "integer",
"vacuumCostPageDirty": "integer",
"vacuumCostLimit": "integer",
"bgwriterDelay": "integer",
"bgwriterLruMaxpages": "integer",
"bgwriterLruMultiplier": "number",
"bgwriterFlushAfter": "integer",
"backendFlushAfter": "integer",
"oldSnapshotThreshold": "integer",
"walLevel": "string",
"synchronousCommit": "string",
"checkpointTimeout": "integer",
"checkpointCompletionTarget": "number",
"checkpointFlushAfter": "integer",
"maxWalSize": "integer",
"minWalSize": "integer",
"maxStandbyStreamingDelay": "integer",
"defaultStatisticsTarget": "integer",
"constraintExclusion": "string",
"cursorTupleFraction": "number",
"fromCollapseLimit": "integer",
"joinCollapseLimit": "integer",
"forceParallelMode": "string",
"clientMinMessages": "string",
"logMinMessages": "string",
"logMinErrorStatement": "string",
"logMinDurationStatement": "integer",
"logCheckpoints": true,
"logConnections": true,
"logDisconnections": true,
"logDuration": true,
"logErrorVerbosity": "string",
"logLockWaits": true,
"logStatement": "string",
"logTempFiles": "integer",
"searchPath": "string",
"rowSecurity": true,
"defaultTransactionIsolation": "string",
"statementTimeout": "integer",
"lockTimeout": "integer",
"idleInTransactionSessionTimeout": "integer",
"byteaOutput": "string",
"xmlbinary": "string",
"xmloption": "string",
"ginPendingListLimit": "integer",
"deadlockTimeout": "integer",
"maxLocksPerTransaction": "integer",
"maxPredLocksPerTransaction": "integer",
"arrayNulls": true,
"backslashQuote": "string",
"defaultWithOids": true,
"escapeStringWarning": true,
"loCompatPrivileges": true,
"quoteAllIdentifiers": true,
"standardConformingStrings": true,
"synchronizeSeqscans": true,
"transformNullEquals": true,
"exitOnError": true,
"seqPageCost": "number",
"randomPageCost": "number",
"autovacuumMaxWorkers": "integer",
"autovacuumVacuumCostDelay": "integer",
"autovacuumVacuumCostLimit": "integer",
"autovacuumNaptime": "integer",
"archiveTimeout": "integer",
"trackActivityQuerySize": "integer",
"onlineAnalyzeEnable": true,
"enableBitmapscan": true,
"enableHashagg": true,
"enableHashjoin": true,
"enableIndexscan": true,
"enableIndexonlyscan": true,
"enableMaterial": true,
"enableMergejoin": true,
"enableNestloop": true,
"enableSeqscan": true,
"enableSort": true,
"enableTidscan": true,
"maxWorkerProcesses": "integer",
"maxParallelWorkers": "integer",
"maxParallelWorkersPerGather": "integer",
"autovacuumVacuumScaleFactor": "number",
"autovacuumAnalyzeScaleFactor": "number",
"defaultTransactionReadOnly": true,
"timezone": "string",
"enableParallelAppend": true,
"enableParallelHash": true,
"enablePartitionPruning": true,
"enablePartitionwiseAggregate": true,
"enablePartitionwiseJoin": true,
"jit": true,
"maxParallelMaintenanceWorkers": "integer",
"parallelLeaderParticipation": true,
"logTransactionSampleRate": "number",
"planCacheMode": "string",
"effectiveIoConcurrency": "integer",
"effectiveCacheSize": "integer",
"sharedPreloadLibraries": [
"string"
],
"autoExplainLogMinDuration": "integer",
"autoExplainLogAnalyze": true,
"autoExplainLogBuffers": true,
"autoExplainLogTiming": true,
"autoExplainLogTriggers": true,
"autoExplainLogVerbose": true,
"autoExplainLogNestedStatements": true,
"autoExplainSampleRate": "number",
"pgHintPlanEnableHint": true,
"pgHintPlanEnableHintTable": true,
"pgHintPlanDebugPrint": "string",
"pgHintPlanMessageLevel": "string",
"hashMemMultiplier": "number",
"logicalDecodingWorkMem": "integer",
"maintenanceIoConcurrency": "integer",
"maxSlotWalKeepSize": "integer",
"walKeepSize": "integer",
"enableIncrementalSort": true,
"autovacuumVacuumInsertThreshold": "integer",
"autovacuumVacuumInsertScaleFactor": "number",
"logMinDurationSample": "integer",
"logStatementSampleRate": "number",
"logParameterMaxLength": "integer",
"logParameterMaxLengthOnError": "integer",
"clientConnectionCheckInterval": "integer",
"enableAsyncAppend": true,
"enableGathermerge": true,
"enableMemoize": true,
"logRecoveryConflictWaits": true,
"vacuumFailsafeAge": "integer",
"vacuumMultixactFailsafeAge": "integer",
"pgQualstatsEnabled": true,
"pgQualstatsTrackConstants": true,
"pgQualstatsMax": "integer",
"pgQualstatsResolveOids": true,
"pgQualstatsSampleRate": "number",
"plantunerFixEmptyTable": true,
"geqo": true,
"geqoThreshold": "integer",
"geqoEffort": "integer",
"geqoPoolSize": "integer",
"geqoGenerations": "integer",
"geqoSelectionBias": "number",
"geqoSeed": "number",
"pgTrgmSimilarityThreshold": "number",
"pgTrgmWordSimilarityThreshold": "number",
"pgTrgmStrictWordSimilarityThreshold": "number"
},
"postgresqlConfig_15": {
"maxConnections": "integer",
"sharedBuffers": "integer",
"tempBuffers": "integer",
"maxPreparedTransactions": "integer",
"workMem": "integer",
"maintenanceWorkMem": "integer",
"autovacuumWorkMem": "integer",
"tempFileLimit": "integer",
"vacuumCostDelay": "integer",
"vacuumCostPageHit": "integer",
"vacuumCostPageMiss": "integer",
"vacuumCostPageDirty": "integer",
"vacuumCostLimit": "integer",
"bgwriterDelay": "integer",
"bgwriterLruMaxpages": "integer",
"bgwriterLruMultiplier": "number",
"bgwriterFlushAfter": "integer",
"backendFlushAfter": "integer",
"oldSnapshotThreshold": "integer",
"walLevel": "string",
"synchronousCommit": "string",
"checkpointTimeout": "integer",
"checkpointCompletionTarget": "number",
"checkpointFlushAfter": "integer",
"maxWalSize": "integer",
"minWalSize": "integer",
"maxStandbyStreamingDelay": "integer",
"defaultStatisticsTarget": "integer",
"constraintExclusion": "string",
"cursorTupleFraction": "number",
"fromCollapseLimit": "integer",
"joinCollapseLimit": "integer",
"forceParallelMode": "string",
"clientMinMessages": "string",
"logMinMessages": "string",
"logMinErrorStatement": "string",
"logMinDurationStatement": "integer",
"logCheckpoints": true,
"logConnections": true,
"logDisconnections": true,
"logDuration": true,
"logErrorVerbosity": "string",
"logLockWaits": true,
"logStatement": "string",
"logTempFiles": "integer",
"searchPath": "string",
"rowSecurity": true,
"defaultTransactionIsolation": "string",
"statementTimeout": "integer",
"lockTimeout": "integer",
"idleInTransactionSessionTimeout": "integer",
"byteaOutput": "string",
"xmlbinary": "string",
"xmloption": "string",
"ginPendingListLimit": "integer",
"deadlockTimeout": "integer",
"maxLocksPerTransaction": "integer",
"maxPredLocksPerTransaction": "integer",
"arrayNulls": true,
"backslashQuote": "string",
"defaultWithOids": true,
"escapeStringWarning": true,
"loCompatPrivileges": true,
"quoteAllIdentifiers": true,
"standardConformingStrings": true,
"synchronizeSeqscans": true,
"transformNullEquals": true,
"exitOnError": true,
"seqPageCost": "number",
"randomPageCost": "number",
"autovacuumMaxWorkers": "integer",
"autovacuumVacuumCostDelay": "integer",
"autovacuumVacuumCostLimit": "integer",
"autovacuumNaptime": "integer",
"archiveTimeout": "integer",
"trackActivityQuerySize": "integer",
"enableBitmapscan": true,
"enableHashagg": true,
"enableHashjoin": true,
"enableIndexscan": true,
"enableIndexonlyscan": true,
"enableMaterial": true,
"enableMergejoin": true,
"enableNestloop": true,
"enableSeqscan": true,
"enableSort": true,
"enableTidscan": true,
"maxWorkerProcesses": "integer",
"maxParallelWorkers": "integer",
"maxParallelWorkersPerGather": "integer",
"autovacuumVacuumScaleFactor": "number",
"autovacuumAnalyzeScaleFactor": "number",
"defaultTransactionReadOnly": true,
"timezone": "string",
"enableParallelAppend": true,
"enableParallelHash": true,
"enablePartitionPruning": true,
"enablePartitionwiseAggregate": true,
"enablePartitionwiseJoin": true,
"jit": true,
"maxParallelMaintenanceWorkers": "integer",
"parallelLeaderParticipation": true,
"logTransactionSampleRate": "number",
"planCacheMode": "string",
"effectiveIoConcurrency": "integer",
"effectiveCacheSize": "integer",
"sharedPreloadLibraries": [
"string"
],
"autoExplainLogMinDuration": "integer",
"autoExplainLogAnalyze": true,
"autoExplainLogBuffers": true,
"autoExplainLogTiming": true,
"autoExplainLogTriggers": true,
"autoExplainLogVerbose": true,
"autoExplainLogNestedStatements": true,
"autoExplainSampleRate": "number",
"pgHintPlanEnableHint": true,
"pgHintPlanEnableHintTable": true,
"pgHintPlanDebugPrint": "string",
"pgHintPlanMessageLevel": "string",
"hashMemMultiplier": "number",
"logicalDecodingWorkMem": "integer",
"maintenanceIoConcurrency": "integer",
"maxSlotWalKeepSize": "integer",
"walKeepSize": "integer",
"enableIncrementalSort": true,
"autovacuumVacuumInsertThreshold": "integer",
"autovacuumVacuumInsertScaleFactor": "number",
"logMinDurationSample": "integer",
"logStatementSampleRate": "number",
"logParameterMaxLength": "integer",
"logParameterMaxLengthOnError": "integer",
"clientConnectionCheckInterval": "integer",
"enableAsyncAppend": true,
"enableGathermerge": true,
"enableMemoize": true,
"logRecoveryConflictWaits": true,
"vacuumFailsafeAge": "integer",
"vacuumMultixactFailsafeAge": "integer",
"pgQualstatsEnabled": true,
"pgQualstatsTrackConstants": true,
"pgQualstatsMax": "integer",
"pgQualstatsResolveOids": true,
"pgQualstatsSampleRate": "number",
"maxStackDepth": "integer",
"enableGroupByReordering": true,
"pgTrgmSimilarityThreshold": "number",
"pgTrgmWordSimilarityThreshold": "number",
"pgTrgmStrictWordSimilarityThreshold": "number"
},
"postgresqlConfig_15_1C": {
"maxConnections": "integer",
"sharedBuffers": "integer",
"tempBuffers": "integer",
"maxPreparedTransactions": "integer",
"workMem": "integer",
"maintenanceWorkMem": "integer",
"autovacuumWorkMem": "integer",
"tempFileLimit": "integer",
"vacuumCostDelay": "integer",
"vacuumCostPageHit": "integer",
"vacuumCostPageMiss": "integer",
"vacuumCostPageDirty": "integer",
"vacuumCostLimit": "integer",
"bgwriterDelay": "integer",
"bgwriterLruMaxpages": "integer",
"bgwriterLruMultiplier": "number",
"bgwriterFlushAfter": "integer",
"backendFlushAfter": "integer",
"oldSnapshotThreshold": "integer",
"walLevel": "string",
"synchronousCommit": "string",
"checkpointTimeout": "integer",
"checkpointCompletionTarget": "number",
"checkpointFlushAfter": "integer",
"maxWalSize": "integer",
"minWalSize": "integer",
"maxStandbyStreamingDelay": "integer",
"defaultStatisticsTarget": "integer",
"constraintExclusion": "string",
"cursorTupleFraction": "number",
"fromCollapseLimit": "integer",
"joinCollapseLimit": "integer",
"forceParallelMode": "string",
"clientMinMessages": "string",
"logMinMessages": "string",
"logMinErrorStatement": "string",
"logMinDurationStatement": "integer",
"logCheckpoints": true,
"logConnections": true,
"logDisconnections": true,
"logDuration": true,
"logErrorVerbosity": "string",
"logLockWaits": true,
"logStatement": "string",
"logTempFiles": "integer",
"searchPath": "string",
"rowSecurity": true,
"defaultTransactionIsolation": "string",
"statementTimeout": "integer",
"lockTimeout": "integer",
"idleInTransactionSessionTimeout": "integer",
"byteaOutput": "string",
"xmlbinary": "string",
"xmloption": "string",
"ginPendingListLimit": "integer",
"deadlockTimeout": "integer",
"maxLocksPerTransaction": "integer",
"maxPredLocksPerTransaction": "integer",
"arrayNulls": true,
"backslashQuote": "string",
"defaultWithOids": true,
"escapeStringWarning": true,
"loCompatPrivileges": true,
"quoteAllIdentifiers": true,
"standardConformingStrings": true,
"synchronizeSeqscans": true,
"transformNullEquals": true,
"exitOnError": true,
"seqPageCost": "number",
"randomPageCost": "number",
"autovacuumMaxWorkers": "integer",
"autovacuumVacuumCostDelay": "integer",
"autovacuumVacuumCostLimit": "integer",
"autovacuumNaptime": "integer",
"archiveTimeout": "integer",
"trackActivityQuerySize": "integer",
"onlineAnalyzeEnable": true,
"enableBitmapscan": true,
"enableHashagg": true,
"enableHashjoin": true,
"enableIndexscan": true,
"enableIndexonlyscan": true,
"enableMaterial": true,
"enableMergejoin": true,
"enableNestloop": true,
"enableSeqscan": true,
"enableSort": true,
"enableTidscan": true,
"maxWorkerProcesses": "integer",
"maxParallelWorkers": "integer",
"maxParallelWorkersPerGather": "integer",
"autovacuumVacuumScaleFactor": "number",
"autovacuumAnalyzeScaleFactor": "number",
"defaultTransactionReadOnly": true,
"timezone": "string",
"enableParallelAppend": true,
"enableParallelHash": true,
"enablePartitionPruning": true,
"enablePartitionwiseAggregate": true,
"enablePartitionwiseJoin": true,
"jit": true,
"maxParallelMaintenanceWorkers": "integer",
"parallelLeaderParticipation": true,
"logTransactionSampleRate": "number",
"planCacheMode": "string",
"effectiveIoConcurrency": "integer",
"effectiveCacheSize": "integer",
"sharedPreloadLibraries": [
"string"
],
"autoExplainLogMinDuration": "integer",
"autoExplainLogAnalyze": true,
"autoExplainLogBuffers": true,
"autoExplainLogTiming": true,
"autoExplainLogTriggers": true,
"autoExplainLogVerbose": true,
"autoExplainLogNestedStatements": true,
"autoExplainSampleRate": "number",
"pgHintPlanEnableHint": true,
"pgHintPlanEnableHintTable": true,
"pgHintPlanDebugPrint": "string",
"pgHintPlanMessageLevel": "string",
"hashMemMultiplier": "number",
"logicalDecodingWorkMem": "integer",
"maintenanceIoConcurrency": "integer",
"maxSlotWalKeepSize": "integer",
"walKeepSize": "integer",
"enableIncrementalSort": true,
"autovacuumVacuumInsertThreshold": "integer",
"autovacuumVacuumInsertScaleFactor": "number",
"logMinDurationSample": "integer",
"logStatementSampleRate": "number",
"logParameterMaxLength": "integer",
"logParameterMaxLengthOnError": "integer",
"clientConnectionCheckInterval": "integer",
"enableAsyncAppend": true,
"enableGathermerge": true,
"enableMemoize": true,
"logRecoveryConflictWaits": true,
"vacuumFailsafeAge": "integer",
"vacuumMultixactFailsafeAge": "integer",
"pgQualstatsEnabled": true,
"pgQualstatsTrackConstants": true,
"pgQualstatsMax": "integer",
"pgQualstatsResolveOids": true,
"pgQualstatsSampleRate": "number",
"plantunerFixEmptyTable": true,
"geqo": true,
"geqoThreshold": "integer",
"geqoEffort": "integer",
"geqoPoolSize": "integer",
"geqoGenerations": "integer",
"geqoSelectionBias": "number",
"geqoSeed": "number",
"pgTrgmSimilarityThreshold": "number",
"pgTrgmWordSimilarityThreshold": "number",
"pgTrgmStrictWordSimilarityThreshold": "number"
},
// end of the list of possible fields`configSpec`
},
"name": "string",
"maintenanceWindow": {
// `maintenanceWindow` includes only one of the fields `anytime`, `weeklyMaintenanceWindow`
"anytime": {},
"weeklyMaintenanceWindow": {
"day": "string",
"hour": "string"
},
// end of the list of possible fields`maintenanceWindow`
},
"securityGroupIds": [
"string"
],
"deletionProtection": true
}
Field | Description |
---|---|
updateMask | string Field mask that specifies which fields of the PostgreSQL Cluster resource should be updated. A comma-separated names off ALL fields to be updated. Only the specified fields will be changed. The others will be left untouched. If the field is specified in If |
description | string New description of the PostgreSQL cluster. The maximum string length in characters is 256. |
labels | object Custom labels for the PostgreSQL cluster as The new set of labels will completely replace the old ones. To add a label, request the current set with the get method, then send an update request with the new label added to the set. No more than 64 per resource. The maximum string length in characters for each key is 63. Each key must match the regular expression |
configSpec | object New configuration and resources for hosts in the cluster. |
configSpec. version |
string Version of PostgreSQL used in the cluster. Possible values: |
configSpec. poolerConfig |
object Configuration of the connection pooler. |
configSpec. poolerConfig. poolingMode |
string Mode that the connection pooler is working in. See descriptions of all modes in the documentation for PgBouncer.
|
configSpec. poolerConfig. poolDiscard |
boolean (boolean) Setting |
configSpec. resources |
object Resources allocated to PostgreSQL hosts. |
configSpec. resources. resourcePresetId |
string ID of the preset for computational resources available to a host (CPU, memory etc.). All available presets are listed in the documentation. |
configSpec. resources. diskSize |
string (int64) Volume of the storage available to a host, in bytes. |
configSpec. resources. diskTypeId |
string Type of the storage environment for the host. Possible values:
|
configSpec. autofailover |
boolean (boolean) Configuration setting which enables/disables autofailover in cluster. |
configSpec. backupWindowStart |
object Time to start the daily backup, in the UTC timezone. |
configSpec. 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. |
configSpec. backupWindowStart. minutes |
integer (int32) Minutes of hour of day. Must be from 0 to 59. |
configSpec. 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. |
configSpec. backupWindowStart. nanos |
integer (int32) Fractions of seconds in nanoseconds. Must be from 0 to 999,999,999. |
configSpec. backupRetainPeriodDays |
integer (int64) Retention policy of automated backups. Acceptable values are 7 to 60, inclusive. |
configSpec. access |
object Access policy to DB |
configSpec. access. dataLens |
boolean (boolean) Allow access for DataLens |
configSpec. access. webSql |
boolean (boolean) Allow SQL queries to the cluster databases from the management console. See SQL queries in the management console for more details. |
configSpec. access. serverless |
boolean (boolean) Allow access for Serverless |
configSpec. access. dataTransfer |
boolean (boolean) Allow access for DataTransfer. |
configSpec. performanceDiagnostics |
object Configuration of the performance diagnostics service. |
configSpec. performanceDiagnostics. enabled |
boolean (boolean) Configuration setting which enables/disables performance diagnostics service in cluster. |
configSpec. performanceDiagnostics. sessionsSamplingInterval |
string (int64) Interval (in seconds) for pg_stat_activity sampling Acceptable values are 1 to 86400, inclusive. |
configSpec. performanceDiagnostics. statementsSamplingInterval |
string (int64) Interval (in seconds) for pg_stat_statements sampling Acceptable values are 1 to 86400, inclusive. |
configSpec. postgresqlConfig_9_6 |
object Configuration for a PostgreSQL 9.6 cluster. configSpec includes only one of the fields postgresqlConfig_9_6 , postgresqlConfig_10_1C , postgresqlConfig_10 , postgresqlConfig_11 , postgresqlConfig_11_1C , postgresqlConfig_12 , postgresqlConfig_12_1C , postgresqlConfig_13 , postgresqlConfig_13_1C , postgresqlConfig_14 , postgresqlConfig_14_1C , postgresqlConfig_15 , postgresqlConfig_15_1C |
configSpec. postgresqlConfig_9_6. maxConnections |
integer (int64) |
configSpec. postgresqlConfig_9_6. sharedBuffers |
integer (int64) |
configSpec. postgresqlConfig_9_6. tempBuffers |
integer (int64) |
configSpec. postgresqlConfig_9_6. maxPreparedTransactions |
integer (int64) |
configSpec. postgresqlConfig_9_6. workMem |
integer (int64) |
configSpec. postgresqlConfig_9_6. maintenanceWorkMem |
integer (int64) |
configSpec. postgresqlConfig_9_6. replacementSortTuples |
integer (int64) |
configSpec. postgresqlConfig_9_6. autovacuumWorkMem |
integer (int64) |
configSpec. postgresqlConfig_9_6. tempFileLimit |
integer (int64) |
configSpec. postgresqlConfig_9_6. vacuumCostDelay |
integer (int64) |
configSpec. postgresqlConfig_9_6. vacuumCostPageHit |
integer (int64) |
configSpec. postgresqlConfig_9_6. vacuumCostPageMiss |
integer (int64) |
configSpec. postgresqlConfig_9_6. vacuumCostPageDirty |
integer (int64) |
configSpec. postgresqlConfig_9_6. vacuumCostLimit |
integer (int64) |
configSpec. postgresqlConfig_9_6. bgwriterDelay |
integer (int64) Acceptable values are 10 to 10000, inclusive. |
configSpec. postgresqlConfig_9_6. bgwriterLruMaxpages |
integer (int64) |
configSpec. postgresqlConfig_9_6. bgwriterLruMultiplier |
number (double) |
configSpec. postgresqlConfig_9_6. bgwriterFlushAfter |
integer (int64) Acceptable values are 0 to 2048, inclusive. |
configSpec. postgresqlConfig_9_6. backendFlushAfter |
integer (int64) Acceptable values are 0 to 2048, inclusive. |
configSpec. postgresqlConfig_9_6. oldSnapshotThreshold |
integer (int64) Acceptable values are -1 to 86400000, inclusive. |
configSpec. postgresqlConfig_9_6. walLevel |
string |
configSpec. postgresqlConfig_9_6. synchronousCommit |
string |
configSpec. postgresqlConfig_9_6. checkpointTimeout |
integer (int64) Acceptable values are 30000 to 86400000, inclusive. |
configSpec. postgresqlConfig_9_6. checkpointCompletionTarget |
number (double) |
configSpec. postgresqlConfig_9_6. checkpointFlushAfter |
integer (int64) Acceptable values are 0 to 2048, inclusive. |
configSpec. postgresqlConfig_9_6. maxWalSize |
integer (int64) |
configSpec. postgresqlConfig_9_6. minWalSize |
integer (int64) |
configSpec. postgresqlConfig_9_6. maxStandbyStreamingDelay |
integer (int64) |
configSpec. postgresqlConfig_9_6. defaultStatisticsTarget |
integer (int64) |
configSpec. postgresqlConfig_9_6. constraintExclusion |
string |
configSpec. postgresqlConfig_9_6. cursorTupleFraction |
number (double) |
configSpec. postgresqlConfig_9_6. fromCollapseLimit |
integer (int64) Acceptable values are 1 to 2147483647, inclusive. |
configSpec. postgresqlConfig_9_6. joinCollapseLimit |
integer (int64) Acceptable values are 1 to 2147483647, inclusive. |
configSpec. postgresqlConfig_9_6. forceParallelMode |
string |
configSpec. postgresqlConfig_9_6. clientMinMessages |
string |
configSpec. postgresqlConfig_9_6. logMinMessages |
string |
configSpec. postgresqlConfig_9_6. logMinErrorStatement |
string |
configSpec. postgresqlConfig_9_6. logMinDurationStatement |
integer (int64) |
configSpec. postgresqlConfig_9_6. logCheckpoints |
boolean (boolean) |
configSpec. postgresqlConfig_9_6. logConnections |
boolean (boolean) |
configSpec. postgresqlConfig_9_6. logDisconnections |
boolean (boolean) |
configSpec. postgresqlConfig_9_6. logDuration |
boolean (boolean) |
configSpec. postgresqlConfig_9_6. logErrorVerbosity |
string |
configSpec. postgresqlConfig_9_6. logLockWaits |
boolean (boolean) |
configSpec. postgresqlConfig_9_6. logStatement |
string |
configSpec. postgresqlConfig_9_6. logTempFiles |
integer (int64) |
configSpec. postgresqlConfig_9_6. searchPath |
string |
configSpec. postgresqlConfig_9_6. rowSecurity |
boolean (boolean) |
configSpec. postgresqlConfig_9_6. defaultTransactionIsolation |
string |
configSpec. postgresqlConfig_9_6. statementTimeout |
integer (int64) |
configSpec. postgresqlConfig_9_6. lockTimeout |
integer (int64) |
configSpec. postgresqlConfig_9_6. idleInTransactionSessionTimeout |
integer (int64) |
configSpec. postgresqlConfig_9_6. byteaOutput |
string |
configSpec. postgresqlConfig_9_6. xmlbinary |
string |
configSpec. postgresqlConfig_9_6. xmloption |
string |
configSpec. postgresqlConfig_9_6. ginPendingListLimit |
integer (int64) |
configSpec. postgresqlConfig_9_6. deadlockTimeout |
integer (int64) |
configSpec. postgresqlConfig_9_6. maxLocksPerTransaction |
integer (int64) |
configSpec. postgresqlConfig_9_6. maxPredLocksPerTransaction |
integer (int64) |
configSpec. postgresqlConfig_9_6. arrayNulls |
boolean (boolean) |
configSpec. postgresqlConfig_9_6. backslashQuote |
string |
configSpec. postgresqlConfig_9_6. defaultWithOids |
boolean (boolean) |
configSpec. postgresqlConfig_9_6. escapeStringWarning |
boolean (boolean) |
configSpec. postgresqlConfig_9_6. loCompatPrivileges |
boolean (boolean) |
configSpec. postgresqlConfig_9_6. operatorPrecedenceWarning |
boolean (boolean) |
configSpec. postgresqlConfig_9_6. quoteAllIdentifiers |
boolean (boolean) |
configSpec. postgresqlConfig_9_6. standardConformingStrings |
boolean (boolean) |
configSpec. postgresqlConfig_9_6. synchronizeSeqscans |
boolean (boolean) |
configSpec. postgresqlConfig_9_6. transformNullEquals |
boolean (boolean) |
configSpec. postgresqlConfig_9_6. exitOnError |
boolean (boolean) |
configSpec. postgresqlConfig_9_6. seqPageCost |
number (double) |
configSpec. postgresqlConfig_9_6. randomPageCost |
number (double) |
configSpec. postgresqlConfig_9_6. sqlInheritance |
boolean (boolean) This option has been removed in PostgreSQL 10. |
configSpec. postgresqlConfig_9_6. autovacuumMaxWorkers |
integer (int64) Acceptable values are 1 to 32, inclusive. |
configSpec. postgresqlConfig_9_6. autovacuumVacuumCostDelay |
integer (int64) Acceptable values are -1 to 100, inclusive. |
configSpec. postgresqlConfig_9_6. autovacuumVacuumCostLimit |
integer (int64) Acceptable values are -1 to 10000, inclusive. |
configSpec. postgresqlConfig_9_6. autovacuumNaptime |
integer (int64) Acceptable values are 1000 to 86400000, inclusive. |
configSpec. postgresqlConfig_9_6. archiveTimeout |
integer (int64) Acceptable values are 10000 to 86400000, inclusive. |
configSpec. postgresqlConfig_9_6. trackActivityQuerySize |
integer (int64) Acceptable values are 100 to 102400, inclusive. |
configSpec. postgresqlConfig_9_6. effectiveIoConcurrency |
integer (int64) Acceptable values are 0 to 1000, inclusive. |
configSpec. postgresqlConfig_9_6. effectiveCacheSize |
integer (int64) Acceptable values are 0 to 549755813888, inclusive. |
configSpec. postgresqlConfig_10_1C |
object Configuration for a PostgreSQL 10 1C cluster. configSpec includes only one of the fields postgresqlConfig_9_6 , postgresqlConfig_10_1C , postgresqlConfig_10 , postgresqlConfig_11 , postgresqlConfig_11_1C , postgresqlConfig_12 , postgresqlConfig_12_1C , postgresqlConfig_13 , postgresqlConfig_13_1C , postgresqlConfig_14 , postgresqlConfig_14_1C , postgresqlConfig_15 , postgresqlConfig_15_1C |
configSpec. postgresqlConfig_10_1C. maxConnections |
integer (int64) |
configSpec. postgresqlConfig_10_1C. sharedBuffers |
integer (int64) |
configSpec. postgresqlConfig_10_1C. tempBuffers |
integer (int64) |
configSpec. postgresqlConfig_10_1C. maxPreparedTransactions |
integer (int64) |
configSpec. postgresqlConfig_10_1C. workMem |
integer (int64) |
configSpec. postgresqlConfig_10_1C. maintenanceWorkMem |
integer (int64) |
configSpec. postgresqlConfig_10_1C. replacementSortTuples |
integer (int64) |
configSpec. postgresqlConfig_10_1C. autovacuumWorkMem |
integer (int64) |
configSpec. postgresqlConfig_10_1C. tempFileLimit |
integer (int64) |
configSpec. postgresqlConfig_10_1C. vacuumCostDelay |
integer (int64) |
configSpec. postgresqlConfig_10_1C. vacuumCostPageHit |
integer (int64) |
configSpec. postgresqlConfig_10_1C. vacuumCostPageMiss |
integer (int64) |
configSpec. postgresqlConfig_10_1C. vacuumCostPageDirty |
integer (int64) |
configSpec. postgresqlConfig_10_1C. vacuumCostLimit |
integer (int64) |
configSpec. postgresqlConfig_10_1C. bgwriterDelay |
integer (int64) Acceptable values are 10 to 10000, inclusive. |
configSpec. postgresqlConfig_10_1C. bgwriterLruMaxpages |
integer (int64) |
configSpec. postgresqlConfig_10_1C. bgwriterLruMultiplier |
number (double) |
configSpec. postgresqlConfig_10_1C. bgwriterFlushAfter |
integer (int64) Acceptable values are 0 to 2048, inclusive. |
configSpec. postgresqlConfig_10_1C. backendFlushAfter |
integer (int64) Acceptable values are 0 to 2048, inclusive. |
configSpec. postgresqlConfig_10_1C. oldSnapshotThreshold |
integer (int64) Acceptable values are -1 to 86400000, inclusive. |
configSpec. postgresqlConfig_10_1C. walLevel |
string |
configSpec. postgresqlConfig_10_1C. synchronousCommit |
string |
configSpec. postgresqlConfig_10_1C. checkpointTimeout |
integer (int64) Acceptable values are 30000 to 86400000, inclusive. |
configSpec. postgresqlConfig_10_1C. checkpointCompletionTarget |
number (double) |
configSpec. postgresqlConfig_10_1C. checkpointFlushAfter |
integer (int64) Acceptable values are 0 to 2048, inclusive. |
configSpec. postgresqlConfig_10_1C. maxWalSize |
integer (int64) |
configSpec. postgresqlConfig_10_1C. minWalSize |
integer (int64) |
configSpec. postgresqlConfig_10_1C. maxStandbyStreamingDelay |
integer (int64) |
configSpec. postgresqlConfig_10_1C. defaultStatisticsTarget |
integer (int64) |
configSpec. postgresqlConfig_10_1C. constraintExclusion |
string |
configSpec. postgresqlConfig_10_1C. cursorTupleFraction |
number (double) |
configSpec. postgresqlConfig_10_1C. fromCollapseLimit |
integer (int64) Acceptable values are 1 to 2147483647, inclusive. |
configSpec. postgresqlConfig_10_1C. joinCollapseLimit |
integer (int64) Acceptable values are 1 to 2147483647, inclusive. |
configSpec. postgresqlConfig_10_1C. forceParallelMode |
string |
configSpec. postgresqlConfig_10_1C. clientMinMessages |
string |
configSpec. postgresqlConfig_10_1C. logMinMessages |
string |
configSpec. postgresqlConfig_10_1C. logMinErrorStatement |
string |
configSpec. postgresqlConfig_10_1C. logMinDurationStatement |
integer (int64) |
configSpec. postgresqlConfig_10_1C. logCheckpoints |
boolean (boolean) |
configSpec. postgresqlConfig_10_1C. logConnections |
boolean (boolean) |
configSpec. postgresqlConfig_10_1C. logDisconnections |
boolean (boolean) |
configSpec. postgresqlConfig_10_1C. logDuration |
boolean (boolean) |
configSpec. postgresqlConfig_10_1C. logErrorVerbosity |
string |
configSpec. postgresqlConfig_10_1C. logLockWaits |
boolean (boolean) |
configSpec. postgresqlConfig_10_1C. logStatement |
string |
configSpec. postgresqlConfig_10_1C. logTempFiles |
integer (int64) |
configSpec. postgresqlConfig_10_1C. searchPath |
string |
configSpec. postgresqlConfig_10_1C. rowSecurity |
boolean (boolean) |
configSpec. postgresqlConfig_10_1C. defaultTransactionIsolation |
string |
configSpec. postgresqlConfig_10_1C. statementTimeout |
integer (int64) |
configSpec. postgresqlConfig_10_1C. lockTimeout |
integer (int64) |
configSpec. postgresqlConfig_10_1C. idleInTransactionSessionTimeout |
integer (int64) |
configSpec. postgresqlConfig_10_1C. byteaOutput |
string |
configSpec. postgresqlConfig_10_1C. xmlbinary |
string |
configSpec. postgresqlConfig_10_1C. xmloption |
string |
configSpec. postgresqlConfig_10_1C. ginPendingListLimit |
integer (int64) |
configSpec. postgresqlConfig_10_1C. deadlockTimeout |
integer (int64) |
configSpec. postgresqlConfig_10_1C. maxLocksPerTransaction |
integer (int64) |
configSpec. postgresqlConfig_10_1C. maxPredLocksPerTransaction |
integer (int64) |
configSpec. postgresqlConfig_10_1C. arrayNulls |
boolean (boolean) |
configSpec. postgresqlConfig_10_1C. backslashQuote |
string |
configSpec. postgresqlConfig_10_1C. defaultWithOids |
boolean (boolean) |
configSpec. postgresqlConfig_10_1C. escapeStringWarning |
boolean (boolean) |
configSpec. postgresqlConfig_10_1C. loCompatPrivileges |
boolean (boolean) |
configSpec. postgresqlConfig_10_1C. operatorPrecedenceWarning |
boolean (boolean) |
configSpec. postgresqlConfig_10_1C. quoteAllIdentifiers |
boolean (boolean) |
configSpec. postgresqlConfig_10_1C. standardConformingStrings |
boolean (boolean) |
configSpec. postgresqlConfig_10_1C. synchronizeSeqscans |
boolean (boolean) |
configSpec. postgresqlConfig_10_1C. transformNullEquals |
boolean (boolean) |
configSpec. postgresqlConfig_10_1C. exitOnError |
boolean (boolean) |
configSpec. postgresqlConfig_10_1C. seqPageCost |
number (double) |
configSpec. postgresqlConfig_10_1C. randomPageCost |
number (double) |
configSpec. postgresqlConfig_10_1C. autovacuumMaxWorkers |
integer (int64) Acceptable values are 1 to 32, inclusive. |
configSpec. postgresqlConfig_10_1C. autovacuumVacuumCostDelay |
integer (int64) Acceptable values are -1 to 100, inclusive. |
configSpec. postgresqlConfig_10_1C. autovacuumVacuumCostLimit |
integer (int64) Acceptable values are -1 to 10000, inclusive. |
configSpec. postgresqlConfig_10_1C. autovacuumNaptime |
integer (int64) Acceptable values are 1000 to 86400000, inclusive. |
configSpec. postgresqlConfig_10_1C. archiveTimeout |
integer (int64) Acceptable values are 10000 to 86400000, inclusive. |
configSpec. postgresqlConfig_10_1C. trackActivityQuerySize |
integer (int64) Acceptable values are 100 to 102400, inclusive. |
configSpec. postgresqlConfig_10_1C. enableBitmapscan |
boolean (boolean) |
configSpec. postgresqlConfig_10_1C. enableHashagg |
boolean (boolean) |
configSpec. postgresqlConfig_10_1C. enableHashjoin |
boolean (boolean) |
configSpec. postgresqlConfig_10_1C. enableIndexscan |
boolean (boolean) |
configSpec. postgresqlConfig_10_1C. enableIndexonlyscan |
boolean (boolean) |
configSpec. postgresqlConfig_10_1C. enableMaterial |
boolean (boolean) |
configSpec. postgresqlConfig_10_1C. enableMergejoin |
boolean (boolean) |
configSpec. postgresqlConfig_10_1C. enableNestloop |
boolean (boolean) |
configSpec. postgresqlConfig_10_1C. enableSeqscan |
boolean (boolean) |
configSpec. postgresqlConfig_10_1C. enableSort |
boolean (boolean) |
configSpec. postgresqlConfig_10_1C. enableTidscan |
boolean (boolean) |
configSpec. postgresqlConfig_10_1C. maxWorkerProcesses |
integer (int64) Acceptable values are 0 to 1024, inclusive. |
configSpec. postgresqlConfig_10_1C. maxParallelWorkers |
integer (int64) Acceptable values are 0 to 1024, inclusive. |
configSpec. postgresqlConfig_10_1C. maxParallelWorkersPerGather |
integer (int64) Acceptable values are 0 to 1024, inclusive. |
configSpec. postgresqlConfig_10_1C. autovacuumVacuumScaleFactor |
number (double) Acceptable values are 0 to 1, inclusive. |
configSpec. postgresqlConfig_10_1C. autovacuumAnalyzeScaleFactor |
number (double) Acceptable values are 0 to 1, inclusive. |
configSpec. postgresqlConfig_10_1C. defaultTransactionReadOnly |
boolean (boolean) |
configSpec. postgresqlConfig_10_1C. timezone |
string |
configSpec. postgresqlConfig_10_1C. effectiveIoConcurrency |
integer (int64) Acceptable values are 0 to 1000, inclusive. |
configSpec. postgresqlConfig_10_1C. effectiveCacheSize |
integer (int64) Acceptable values are 0 to 549755813888, inclusive. |
configSpec. postgresqlConfig_10_1C. sharedPreloadLibraries[] |
string |
configSpec. postgresqlConfig_10_1C. autoExplainLogMinDuration |
integer (int64) Acceptable values are -1 to 2147483647, inclusive. |
configSpec. postgresqlConfig_10_1C. autoExplainLogAnalyze |
boolean (boolean) |
configSpec. postgresqlConfig_10_1C. autoExplainLogBuffers |
boolean (boolean) |
configSpec. postgresqlConfig_10_1C. autoExplainLogTiming |
boolean (boolean) |
configSpec. postgresqlConfig_10_1C. autoExplainLogTriggers |
boolean (boolean) |
configSpec. postgresqlConfig_10_1C. autoExplainLogVerbose |
boolean (boolean) |
configSpec. postgresqlConfig_10_1C. autoExplainLogNestedStatements |
boolean (boolean) |
configSpec. postgresqlConfig_10_1C. autoExplainSampleRate |
number (double) Acceptable values are 0 to 1, inclusive. |
configSpec. postgresqlConfig_10_1C. pgHintPlanEnableHint |
boolean (boolean) |
configSpec. postgresqlConfig_10_1C. pgHintPlanEnableHintTable |
boolean (boolean) |
configSpec. postgresqlConfig_10_1C. pgHintPlanDebugPrint |
string |
configSpec. postgresqlConfig_10_1C. pgHintPlanMessageLevel |
string |
configSpec. postgresqlConfig_10_1C. onlineAnalyzeEnable |
boolean (boolean) |
configSpec. postgresqlConfig_10_1C. plantunerFixEmptyTable |
boolean (boolean) |
configSpec. postgresqlConfig_10_1C. pgQualstatsEnabled |
boolean (boolean) |
configSpec. postgresqlConfig_10_1C. pgQualstatsTrackConstants |
boolean (boolean) |
configSpec. postgresqlConfig_10_1C. pgQualstatsMax |
integer (int64) |
configSpec. postgresqlConfig_10_1C. pgQualstatsResolveOids |
boolean (boolean) |
configSpec. postgresqlConfig_10_1C. pgQualstatsSampleRate |
number (double) |
configSpec. postgresqlConfig_10_1C. maxStackDepth |
integer (int64) Acceptable values are 65536 to 134217728, inclusive. |
configSpec. postgresqlConfig_10_1C. geqo |
boolean (boolean) |
configSpec. postgresqlConfig_10_1C. geqoThreshold |
integer (int64) Acceptable values are 2 to 2147483647, inclusive. |
configSpec. postgresqlConfig_10_1C. geqoEffort |
integer (int64) Acceptable values are 1 to 10, inclusive. |
configSpec. postgresqlConfig_10_1C. geqoPoolSize |
integer (int64) |
configSpec. postgresqlConfig_10_1C. geqoGenerations |
integer (int64) |
configSpec. postgresqlConfig_10_1C. geqoSelectionBias |
number (double) Acceptable values are 1.5 to 2, inclusive. |
configSpec. postgresqlConfig_10_1C. geqoSeed |
number (double) Acceptable values are 0 to 1, inclusive. |
configSpec. postgresqlConfig_10 |
object Configuration for a PostgreSQL 10 cluster. configSpec includes only one of the fields postgresqlConfig_9_6 , postgresqlConfig_10_1C , postgresqlConfig_10 , postgresqlConfig_11 , postgresqlConfig_11_1C , postgresqlConfig_12 , postgresqlConfig_12_1C , postgresqlConfig_13 , postgresqlConfig_13_1C , postgresqlConfig_14 , postgresqlConfig_14_1C , postgresqlConfig_15 , postgresqlConfig_15_1C |
configSpec. postgresqlConfig_10. maxConnections |
integer (int64) |
configSpec. postgresqlConfig_10. sharedBuffers |
integer (int64) |
configSpec. postgresqlConfig_10. tempBuffers |
integer (int64) |
configSpec. postgresqlConfig_10. maxPreparedTransactions |
integer (int64) |
configSpec. postgresqlConfig_10. workMem |
integer (int64) |
configSpec. postgresqlConfig_10. maintenanceWorkMem |
integer (int64) |
configSpec. postgresqlConfig_10. replacementSortTuples |
integer (int64) |
configSpec. postgresqlConfig_10. autovacuumWorkMem |
integer (int64) |
configSpec. postgresqlConfig_10. tempFileLimit |
integer (int64) |
configSpec. postgresqlConfig_10. vacuumCostDelay |
integer (int64) |
configSpec. postgresqlConfig_10. vacuumCostPageHit |
integer (int64) |
configSpec. postgresqlConfig_10. vacuumCostPageMiss |
integer (int64) |
configSpec. postgresqlConfig_10. vacuumCostPageDirty |
integer (int64) |
configSpec. postgresqlConfig_10. vacuumCostLimit |
integer (int64) |
configSpec. postgresqlConfig_10. bgwriterDelay |
integer (int64) Acceptable values are 10 to 10000, inclusive. |
configSpec. postgresqlConfig_10. bgwriterLruMaxpages |
integer (int64) |
configSpec. postgresqlConfig_10. bgwriterLruMultiplier |
number (double) |
configSpec. postgresqlConfig_10. bgwriterFlushAfter |
integer (int64) Acceptable values are 0 to 2048, inclusive. |
configSpec. postgresqlConfig_10. backendFlushAfter |
integer (int64) Acceptable values are 0 to 2048, inclusive. |
configSpec. postgresqlConfig_10. oldSnapshotThreshold |
integer (int64) Acceptable values are -1 to 86400000, inclusive. |
configSpec. postgresqlConfig_10. walLevel |
string |
configSpec. postgresqlConfig_10. synchronousCommit |
string |
configSpec. postgresqlConfig_10. checkpointTimeout |
integer (int64) Acceptable values are 30000 to 86400000, inclusive. |
configSpec. postgresqlConfig_10. checkpointCompletionTarget |
number (double) |
configSpec. postgresqlConfig_10. checkpointFlushAfter |
integer (int64) Acceptable values are 0 to 2048, inclusive. |
configSpec. postgresqlConfig_10. maxWalSize |
integer (int64) |
configSpec. postgresqlConfig_10. minWalSize |
integer (int64) |
configSpec. postgresqlConfig_10. maxStandbyStreamingDelay |
integer (int64) |
configSpec. postgresqlConfig_10. defaultStatisticsTarget |
integer (int64) |
configSpec. postgresqlConfig_10. constraintExclusion |
string |
configSpec. postgresqlConfig_10. cursorTupleFraction |
number (double) |
configSpec. postgresqlConfig_10. fromCollapseLimit |
integer (int64) Acceptable values are 1 to 2147483647, inclusive. |
configSpec. postgresqlConfig_10. joinCollapseLimit |
integer (int64) Acceptable values are 1 to 2147483647, inclusive. |
configSpec. postgresqlConfig_10. forceParallelMode |
string |
configSpec. postgresqlConfig_10. clientMinMessages |
string |
configSpec. postgresqlConfig_10. logMinMessages |
string |
configSpec. postgresqlConfig_10. logMinErrorStatement |
string |
configSpec. postgresqlConfig_10. logMinDurationStatement |
integer (int64) |
configSpec. postgresqlConfig_10. logCheckpoints |
boolean (boolean) |
configSpec. postgresqlConfig_10. logConnections |
boolean (boolean) |
configSpec. postgresqlConfig_10. logDisconnections |
boolean (boolean) |
configSpec. postgresqlConfig_10. logDuration |
boolean (boolean) |
configSpec. postgresqlConfig_10. logErrorVerbosity |
string |
configSpec. postgresqlConfig_10. logLockWaits |
boolean (boolean) |
configSpec. postgresqlConfig_10. logStatement |
string |
configSpec. postgresqlConfig_10. logTempFiles |
integer (int64) |
configSpec. postgresqlConfig_10. searchPath |
string |
configSpec. postgresqlConfig_10. rowSecurity |
boolean (boolean) |
configSpec. postgresqlConfig_10. defaultTransactionIsolation |
string |
configSpec. postgresqlConfig_10. statementTimeout |
integer (int64) |
configSpec. postgresqlConfig_10. lockTimeout |
integer (int64) |
configSpec. postgresqlConfig_10. idleInTransactionSessionTimeout |
integer (int64) |
configSpec. postgresqlConfig_10. byteaOutput |
string |
configSpec. postgresqlConfig_10. xmlbinary |
string |
configSpec. postgresqlConfig_10. xmloption |
string |
configSpec. postgresqlConfig_10. ginPendingListLimit |
integer (int64) |
configSpec. postgresqlConfig_10. deadlockTimeout |
integer (int64) |
configSpec. postgresqlConfig_10. maxLocksPerTransaction |
integer (int64) |
configSpec. postgresqlConfig_10. maxPredLocksPerTransaction |
integer (int64) |
configSpec. postgresqlConfig_10. arrayNulls |
boolean (boolean) |
configSpec. postgresqlConfig_10. backslashQuote |
string |
configSpec. postgresqlConfig_10. defaultWithOids |
boolean (boolean) |
configSpec. postgresqlConfig_10. escapeStringWarning |
boolean (boolean) |
configSpec. postgresqlConfig_10. loCompatPrivileges |
boolean (boolean) |
configSpec. postgresqlConfig_10. operatorPrecedenceWarning |
boolean (boolean) |
configSpec. postgresqlConfig_10. quoteAllIdentifiers |
boolean (boolean) |
configSpec. postgresqlConfig_10. standardConformingStrings |
boolean (boolean) |
configSpec. postgresqlConfig_10. synchronizeSeqscans |
boolean (boolean) |
configSpec. postgresqlConfig_10. transformNullEquals |
boolean (boolean) |
configSpec. postgresqlConfig_10. exitOnError |
boolean (boolean) |
configSpec. postgresqlConfig_10. seqPageCost |
number (double) |
configSpec. postgresqlConfig_10. randomPageCost |
number (double) |
configSpec. postgresqlConfig_10. autovacuumMaxWorkers |
integer (int64) Acceptable values are 1 to 32, inclusive. |
configSpec. postgresqlConfig_10. autovacuumVacuumCostDelay |
integer (int64) Acceptable values are -1 to 100, inclusive. |
configSpec. postgresqlConfig_10. autovacuumVacuumCostLimit |
integer (int64) Acceptable values are -1 to 10000, inclusive. |
configSpec. postgresqlConfig_10. autovacuumNaptime |
integer (int64) Acceptable values are 1000 to 86400000, inclusive. |
configSpec. postgresqlConfig_10. archiveTimeout |
integer (int64) Acceptable values are 10000 to 86400000, inclusive. |
configSpec. postgresqlConfig_10. trackActivityQuerySize |
integer (int64) Acceptable values are 100 to 102400, inclusive. |
configSpec. postgresqlConfig_10. enableBitmapscan |
boolean (boolean) |
configSpec. postgresqlConfig_10. enableHashagg |
boolean (boolean) |
configSpec. postgresqlConfig_10. enableHashjoin |
boolean (boolean) |
configSpec. postgresqlConfig_10. enableIndexscan |
boolean (boolean) |
configSpec. postgresqlConfig_10. enableIndexonlyscan |
boolean (boolean) |
configSpec. postgresqlConfig_10. enableMaterial |
boolean (boolean) |
configSpec. postgresqlConfig_10. enableMergejoin |
boolean (boolean) |
configSpec. postgresqlConfig_10. enableNestloop |
boolean (boolean) |
configSpec. postgresqlConfig_10. enableSeqscan |
boolean (boolean) |
configSpec. postgresqlConfig_10. enableSort |
boolean (boolean) |
configSpec. postgresqlConfig_10. enableTidscan |
boolean (boolean) |
configSpec. postgresqlConfig_10. maxWorkerProcesses |
integer (int64) Acceptable values are 0 to 1024, inclusive. |
configSpec. postgresqlConfig_10. maxParallelWorkers |
integer (int64) Acceptable values are 0 to 1024, inclusive. |
configSpec. postgresqlConfig_10. maxParallelWorkersPerGather |
integer (int64) Acceptable values are 0 to 1024, inclusive. |
configSpec. postgresqlConfig_10. autovacuumVacuumScaleFactor |
number (double) Acceptable values are 0 to 1, inclusive. |
configSpec. postgresqlConfig_10. autovacuumAnalyzeScaleFactor |
number (double) Acceptable values are 0 to 1, inclusive. |
configSpec. postgresqlConfig_10. defaultTransactionReadOnly |
boolean (boolean) |
configSpec. postgresqlConfig_10. timezone |
string |
configSpec. postgresqlConfig_10. effectiveIoConcurrency |
integer (int64) Acceptable values are 0 to 1000, inclusive. |
configSpec. postgresqlConfig_10. effectiveCacheSize |
integer (int64) Acceptable values are 0 to 549755813888, inclusive. |
configSpec. postgresqlConfig_10. sharedPreloadLibraries[] |
string |
configSpec. postgresqlConfig_10. autoExplainLogMinDuration |
integer (int64) Acceptable values are -1 to 2147483647, inclusive. |
configSpec. postgresqlConfig_10. autoExplainLogAnalyze |
boolean (boolean) |
configSpec. postgresqlConfig_10. autoExplainLogBuffers |
boolean (boolean) |
configSpec. postgresqlConfig_10. autoExplainLogTiming |
boolean (boolean) |
configSpec. postgresqlConfig_10. autoExplainLogTriggers |
boolean (boolean) |
configSpec. postgresqlConfig_10. autoExplainLogVerbose |
boolean (boolean) |
configSpec. postgresqlConfig_10. autoExplainLogNestedStatements |
boolean (boolean) |
configSpec. postgresqlConfig_10. autoExplainSampleRate |
number (double) Acceptable values are 0 to 1, inclusive. |
configSpec. postgresqlConfig_10. pgHintPlanEnableHint |
boolean (boolean) |
configSpec. postgresqlConfig_10. pgHintPlanEnableHintTable |
boolean (boolean) |
configSpec. postgresqlConfig_10. pgHintPlanDebugPrint |
string |
configSpec. postgresqlConfig_10. pgHintPlanMessageLevel |
string |
configSpec. postgresqlConfig_10. pgQualstatsEnabled |
boolean (boolean) |
configSpec. postgresqlConfig_10. pgQualstatsTrackConstants |
boolean (boolean) |
configSpec. postgresqlConfig_10. pgQualstatsMax |
integer (int64) |
configSpec. postgresqlConfig_10. pgQualstatsResolveOids |
boolean (boolean) |
configSpec. postgresqlConfig_10. pgQualstatsSampleRate |
number (double) |
configSpec. postgresqlConfig_10. maxStackDepth |
integer (int64) Acceptable values are 65536 to 134217728, inclusive. |
configSpec. postgresqlConfig_10. geqo |
boolean (boolean) |
configSpec. postgresqlConfig_10. geqoThreshold |
integer (int64) Acceptable values are 2 to 2147483647, inclusive. |
configSpec. postgresqlConfig_10. geqoEffort |
integer (int64) Acceptable values are 1 to 10, inclusive. |
configSpec. postgresqlConfig_10. geqoPoolSize |
integer (int64) |
configSpec. postgresqlConfig_10. geqoGenerations |
integer (int64) |
configSpec. postgresqlConfig_10. geqoSelectionBias |
number (double) Acceptable values are 1.5 to 2, inclusive. |
configSpec. postgresqlConfig_10. geqoSeed |
number (double) Acceptable values are 0 to 1, inclusive. |
configSpec. postgresqlConfig_11 |
object Configuration for a PostgreSQL 11 cluster. configSpec includes only one of the fields postgresqlConfig_9_6 , postgresqlConfig_10_1C , postgresqlConfig_10 , postgresqlConfig_11 , postgresqlConfig_11_1C , postgresqlConfig_12 , postgresqlConfig_12_1C , postgresqlConfig_13 , postgresqlConfig_13_1C , postgresqlConfig_14 , postgresqlConfig_14_1C , postgresqlConfig_15 , postgresqlConfig_15_1C |
configSpec. postgresqlConfig_11. maxConnections |
integer (int64) |
configSpec. postgresqlConfig_11. sharedBuffers |
integer (int64) |
configSpec. postgresqlConfig_11. tempBuffers |
integer (int64) |
configSpec. postgresqlConfig_11. maxPreparedTransactions |
integer (int64) |
configSpec. postgresqlConfig_11. workMem |
integer (int64) |
configSpec. postgresqlConfig_11. maintenanceWorkMem |
integer (int64) |
configSpec. postgresqlConfig_11. autovacuumWorkMem |
integer (int64) |
configSpec. postgresqlConfig_11. tempFileLimit |
integer (int64) |
configSpec. postgresqlConfig_11. vacuumCostDelay |
integer (int64) |
configSpec. postgresqlConfig_11. vacuumCostPageHit |
integer (int64) |
configSpec. postgresqlConfig_11. vacuumCostPageMiss |
integer (int64) |
configSpec. postgresqlConfig_11. vacuumCostPageDirty |
integer (int64) |
configSpec. postgresqlConfig_11. vacuumCostLimit |
integer (int64) |
configSpec. postgresqlConfig_11. bgwriterDelay |
integer (int64) Acceptable values are 10 to 10000, inclusive. |
configSpec. postgresqlConfig_11. bgwriterLruMaxpages |
integer (int64) |
configSpec. postgresqlConfig_11. bgwriterLruMultiplier |
number (double) |
configSpec. postgresqlConfig_11. bgwriterFlushAfter |
integer (int64) Acceptable values are 0 to 2048, inclusive. |
configSpec. postgresqlConfig_11. backendFlushAfter |
integer (int64) Acceptable values are 0 to 2048, inclusive. |
configSpec. postgresqlConfig_11. oldSnapshotThreshold |
integer (int64) Acceptable values are -1 to 86400000, inclusive. |
configSpec. postgresqlConfig_11. walLevel |
string |
configSpec. postgresqlConfig_11. synchronousCommit |
string |
configSpec. postgresqlConfig_11. checkpointTimeout |
integer (int64) Acceptable values are 30000 to 86400000, inclusive. |
configSpec. postgresqlConfig_11. checkpointCompletionTarget |
number (double) |
configSpec. postgresqlConfig_11. checkpointFlushAfter |
integer (int64) Acceptable values are 0 to 2048, inclusive. |
configSpec. postgresqlConfig_11. maxWalSize |
integer (int64) |
configSpec. postgresqlConfig_11. minWalSize |
integer (int64) |
configSpec. postgresqlConfig_11. maxStandbyStreamingDelay |
integer (int64) |
configSpec. postgresqlConfig_11. defaultStatisticsTarget |
integer (int64) |
configSpec. postgresqlConfig_11. constraintExclusion |
string |
configSpec. postgresqlConfig_11. cursorTupleFraction |
number (double) |
configSpec. postgresqlConfig_11. fromCollapseLimit |
integer (int64) Acceptable values are 1 to 2147483647, inclusive. |
configSpec. postgresqlConfig_11. joinCollapseLimit |
integer (int64) Acceptable values are 1 to 2147483647, inclusive. |
configSpec. postgresqlConfig_11. forceParallelMode |
string |
configSpec. postgresqlConfig_11. clientMinMessages |
string |
configSpec. postgresqlConfig_11. logMinMessages |
string |
configSpec. postgresqlConfig_11. logMinErrorStatement |
string |
configSpec. postgresqlConfig_11. logMinDurationStatement |
integer (int64) |
configSpec. postgresqlConfig_11. logCheckpoints |
boolean (boolean) |
configSpec. postgresqlConfig_11. logConnections |
boolean (boolean) |
configSpec. postgresqlConfig_11. logDisconnections |
boolean (boolean) |
configSpec. postgresqlConfig_11. logDuration |
boolean (boolean) |
configSpec. postgresqlConfig_11. logErrorVerbosity |
string |
configSpec. postgresqlConfig_11. logLockWaits |
boolean (boolean) |
configSpec. postgresqlConfig_11. logStatement |
string |
configSpec. postgresqlConfig_11. logTempFiles |
integer (int64) |
configSpec. postgresqlConfig_11. searchPath |
string |
configSpec. postgresqlConfig_11. rowSecurity |
boolean (boolean) |
configSpec. postgresqlConfig_11. defaultTransactionIsolation |
string |
configSpec. postgresqlConfig_11. statementTimeout |
integer (int64) |
configSpec. postgresqlConfig_11. lockTimeout |
integer (int64) |
configSpec. postgresqlConfig_11. idleInTransactionSessionTimeout |
integer (int64) |
configSpec. postgresqlConfig_11. byteaOutput |
string |
configSpec. postgresqlConfig_11. xmlbinary |
string |
configSpec. postgresqlConfig_11. xmloption |
string |
configSpec. postgresqlConfig_11. ginPendingListLimit |
integer (int64) |
configSpec. postgresqlConfig_11. deadlockTimeout |
integer (int64) |
configSpec. postgresqlConfig_11. maxLocksPerTransaction |
integer (int64) |
configSpec. postgresqlConfig_11. maxPredLocksPerTransaction |
integer (int64) |
configSpec. postgresqlConfig_11. arrayNulls |
boolean (boolean) |
configSpec. postgresqlConfig_11. backslashQuote |
string |
configSpec. postgresqlConfig_11. defaultWithOids |
boolean (boolean) |
configSpec. postgresqlConfig_11. escapeStringWarning |
boolean (boolean) |
configSpec. postgresqlConfig_11. loCompatPrivileges |
boolean (boolean) |
configSpec. postgresqlConfig_11. operatorPrecedenceWarning |
boolean (boolean) |
configSpec. postgresqlConfig_11. quoteAllIdentifiers |
boolean (boolean) |
configSpec. postgresqlConfig_11. standardConformingStrings |
boolean (boolean) |
configSpec. postgresqlConfig_11. synchronizeSeqscans |
boolean (boolean) |
configSpec. postgresqlConfig_11. transformNullEquals |
boolean (boolean) |
configSpec. postgresqlConfig_11. exitOnError |
boolean (boolean) |
configSpec. postgresqlConfig_11. seqPageCost |
number (double) |
configSpec. postgresqlConfig_11. randomPageCost |
number (double) |
configSpec. postgresqlConfig_11. autovacuumMaxWorkers |
integer (int64) Acceptable values are 1 to 32, inclusive. |
configSpec. postgresqlConfig_11. autovacuumVacuumCostDelay |
integer (int64) Acceptable values are -1 to 100, inclusive. |
configSpec. postgresqlConfig_11. autovacuumVacuumCostLimit |
integer (int64) Acceptable values are -1 to 10000, inclusive. |
configSpec. postgresqlConfig_11. autovacuumNaptime |
integer (int64) Acceptable values are 1000 to 86400000, inclusive. |
configSpec. postgresqlConfig_11. archiveTimeout |
integer (int64) Acceptable values are 10000 to 86400000, inclusive. |
configSpec. postgresqlConfig_11. trackActivityQuerySize |
integer (int64) Acceptable values are 100 to 102400, inclusive. |
configSpec. postgresqlConfig_11. enableBitmapscan |
boolean (boolean) |
configSpec. postgresqlConfig_11. enableHashagg |
boolean (boolean) |
configSpec. postgresqlConfig_11. enableHashjoin |
boolean (boolean) |
configSpec. postgresqlConfig_11. enableIndexscan |
boolean (boolean) |
configSpec. postgresqlConfig_11. enableIndexonlyscan |
boolean (boolean) |
configSpec. postgresqlConfig_11. enableMaterial |
boolean (boolean) |
configSpec. postgresqlConfig_11. enableMergejoin |
boolean (boolean) |
configSpec. postgresqlConfig_11. enableNestloop |
boolean (boolean) |
configSpec. postgresqlConfig_11. enableSeqscan |
boolean (boolean) |
configSpec. postgresqlConfig_11. enableSort |
boolean (boolean) |
configSpec. postgresqlConfig_11. enableTidscan |
boolean (boolean) |
configSpec. postgresqlConfig_11. maxWorkerProcesses |
integer (int64) Acceptable values are 0 to 1024, inclusive. |
configSpec. postgresqlConfig_11. maxParallelWorkers |
integer (int64) Acceptable values are 0 to 1024, inclusive. |
configSpec. postgresqlConfig_11. maxParallelWorkersPerGather |
integer (int64) Acceptable values are 0 to 1024, inclusive. |
configSpec. postgresqlConfig_11. autovacuumVacuumScaleFactor |
number (double) Acceptable values are 0 to 1, inclusive. |
configSpec. postgresqlConfig_11. autovacuumAnalyzeScaleFactor |
number (double) Acceptable values are 0 to 1, inclusive. |
configSpec. postgresqlConfig_11. defaultTransactionReadOnly |
boolean (boolean) |
configSpec. postgresqlConfig_11. timezone |
string |
configSpec. postgresqlConfig_11. enableParallelAppend |
boolean (boolean) |
configSpec. postgresqlConfig_11. enableParallelHash |
boolean (boolean) |
configSpec. postgresqlConfig_11. enablePartitionPruning |
boolean (boolean) |
configSpec. postgresqlConfig_11. enablePartitionwiseAggregate |
boolean (boolean) |
configSpec. postgresqlConfig_11. enablePartitionwiseJoin |
boolean (boolean) |
configSpec. postgresqlConfig_11. jit |
boolean (boolean) |
configSpec. postgresqlConfig_11. maxParallelMaintenanceWorkers |
integer (int64) The minimum value is 0. |
configSpec. postgresqlConfig_11. parallelLeaderParticipation |
boolean (boolean) |
configSpec. postgresqlConfig_11. vacuumCleanupIndexScaleFactor |
number (double) Acceptable values are 0 to 10000000000, inclusive. |
configSpec. postgresqlConfig_11. effectiveIoConcurrency |
integer (int64) Acceptable values are 0 to 1000, inclusive. |
configSpec. postgresqlConfig_11. effectiveCacheSize |
integer (int64) Acceptable values are 0 to 549755813888, inclusive. |
configSpec. postgresqlConfig_11. sharedPreloadLibraries[] |
string |
configSpec. postgresqlConfig_11. autoExplainLogMinDuration |
integer (int64) Acceptable values are -1 to 2147483647, inclusive. |
configSpec. postgresqlConfig_11. autoExplainLogAnalyze |
boolean (boolean) |
configSpec. postgresqlConfig_11. autoExplainLogBuffers |
boolean (boolean) |
configSpec. postgresqlConfig_11. autoExplainLogTiming |
boolean (boolean) |
configSpec. postgresqlConfig_11. autoExplainLogTriggers |
boolean (boolean) |
configSpec. postgresqlConfig_11. autoExplainLogVerbose |
boolean (boolean) |
configSpec. postgresqlConfig_11. autoExplainLogNestedStatements |
boolean (boolean) |
configSpec. postgresqlConfig_11. autoExplainSampleRate |
number (double) Acceptable values are 0 to 1, inclusive. |
configSpec. postgresqlConfig_11. pgHintPlanEnableHint |
boolean (boolean) |
configSpec. postgresqlConfig_11. pgHintPlanEnableHintTable |
boolean (boolean) |
configSpec. postgresqlConfig_11. pgHintPlanDebugPrint |
string |
configSpec. postgresqlConfig_11. pgHintPlanMessageLevel |
string |
configSpec. postgresqlConfig_11. pgQualstatsEnabled |
boolean (boolean) |
configSpec. postgresqlConfig_11. pgQualstatsTrackConstants |
boolean (boolean) |
configSpec. postgresqlConfig_11. pgQualstatsMax |
integer (int64) |
configSpec. postgresqlConfig_11. pgQualstatsResolveOids |
boolean (boolean) |
configSpec. postgresqlConfig_11. pgQualstatsSampleRate |
number (double) |
configSpec. postgresqlConfig_11. maxStackDepth |
integer (int64) Acceptable values are 65536 to 134217728, inclusive. |
configSpec. postgresqlConfig_11. geqo |
boolean (boolean) |
configSpec. postgresqlConfig_11. geqoThreshold |
integer (int64) Acceptable values are 2 to 2147483647, inclusive. |
configSpec. postgresqlConfig_11. geqoEffort |
integer (int64) Acceptable values are 1 to 10, inclusive. |
configSpec. postgresqlConfig_11. geqoPoolSize |
integer (int64) |
configSpec. postgresqlConfig_11. geqoGenerations |
integer (int64) |
configSpec. postgresqlConfig_11. geqoSelectionBias |
number (double) Acceptable values are 1.5 to 2, inclusive. |
configSpec. postgresqlConfig_11. geqoSeed |
number (double) Acceptable values are 0 to 1, inclusive. |
configSpec. postgresqlConfig_11. pgTrgmSimilarityThreshold |
number (double) Acceptable values are 0 to 1, inclusive. |
configSpec. postgresqlConfig_11. pgTrgmWordSimilarityThreshold |
number (double) Acceptable values are 0 to 1, inclusive. |
configSpec. postgresqlConfig_11. pgTrgmStrictWordSimilarityThreshold |
number (double) Acceptable values are 0 to 1, inclusive. |
configSpec. postgresqlConfig_11_1C |
object Configuration for a PostgreSQL 11 1C cluster. configSpec includes only one of the fields postgresqlConfig_9_6 , postgresqlConfig_10_1C , postgresqlConfig_10 , postgresqlConfig_11 , postgresqlConfig_11_1C , postgresqlConfig_12 , postgresqlConfig_12_1C , postgresqlConfig_13 , postgresqlConfig_13_1C , postgresqlConfig_14 , postgresqlConfig_14_1C , postgresqlConfig_15 , postgresqlConfig_15_1C |
configSpec. postgresqlConfig_11_1C. maxConnections |
integer (int64) |
configSpec. postgresqlConfig_11_1C. sharedBuffers |
integer (int64) |
configSpec. postgresqlConfig_11_1C. tempBuffers |
integer (int64) |
configSpec. postgresqlConfig_11_1C. maxPreparedTransactions |
integer (int64) |
configSpec. postgresqlConfig_11_1C. workMem |
integer (int64) |
configSpec. postgresqlConfig_11_1C. maintenanceWorkMem |
integer (int64) |
configSpec. postgresqlConfig_11_1C. autovacuumWorkMem |
integer (int64) |
configSpec. postgresqlConfig_11_1C. tempFileLimit |
integer (int64) |
configSpec. postgresqlConfig_11_1C. vacuumCostDelay |
integer (int64) |
configSpec. postgresqlConfig_11_1C. vacuumCostPageHit |
integer (int64) |
configSpec. postgresqlConfig_11_1C. vacuumCostPageMiss |
integer (int64) |
configSpec. postgresqlConfig_11_1C. vacuumCostPageDirty |
integer (int64) |
configSpec. postgresqlConfig_11_1C. vacuumCostLimit |
integer (int64) |
configSpec. postgresqlConfig_11_1C. bgwriterDelay |
integer (int64) Acceptable values are 10 to 10000, inclusive. |
configSpec. postgresqlConfig_11_1C. bgwriterLruMaxpages |
integer (int64) |
configSpec. postgresqlConfig_11_1C. bgwriterLruMultiplier |
number (double) |
configSpec. postgresqlConfig_11_1C. bgwriterFlushAfter |
integer (int64) Acceptable values are 0 to 2048, inclusive. |
configSpec. postgresqlConfig_11_1C. backendFlushAfter |
integer (int64) Acceptable values are 0 to 2048, inclusive. |
configSpec. postgresqlConfig_11_1C. oldSnapshotThreshold |
integer (int64) Acceptable values are -1 to 86400000, inclusive. |
configSpec. postgresqlConfig_11_1C. walLevel |
string |
configSpec. postgresqlConfig_11_1C. synchronousCommit |
string |
configSpec. postgresqlConfig_11_1C. checkpointTimeout |
integer (int64) Acceptable values are 30000 to 86400000, inclusive. |
configSpec. postgresqlConfig_11_1C. checkpointCompletionTarget |
number (double) |
configSpec. postgresqlConfig_11_1C. checkpointFlushAfter |
integer (int64) Acceptable values are 0 to 2048, inclusive. |
configSpec. postgresqlConfig_11_1C. maxWalSize |
integer (int64) |
configSpec. postgresqlConfig_11_1C. minWalSize |
integer (int64) |
configSpec. postgresqlConfig_11_1C. maxStandbyStreamingDelay |
integer (int64) |
configSpec. postgresqlConfig_11_1C. defaultStatisticsTarget |
integer (int64) |
configSpec. postgresqlConfig_11_1C. constraintExclusion |
string |
configSpec. postgresqlConfig_11_1C. cursorTupleFraction |
number (double) |
configSpec. postgresqlConfig_11_1C. fromCollapseLimit |
integer (int64) Acceptable values are 1 to 2147483647, inclusive. |
configSpec. postgresqlConfig_11_1C. joinCollapseLimit |
integer (int64) Acceptable values are 1 to 2147483647, inclusive. |
configSpec. postgresqlConfig_11_1C. forceParallelMode |
string |
configSpec. postgresqlConfig_11_1C. clientMinMessages |
string |
configSpec. postgresqlConfig_11_1C. logMinMessages |
string |
configSpec. postgresqlConfig_11_1C. logMinErrorStatement |
string |
configSpec. postgresqlConfig_11_1C. logMinDurationStatement |
integer (int64) |
configSpec. postgresqlConfig_11_1C. logCheckpoints |
boolean (boolean) |
configSpec. postgresqlConfig_11_1C. logConnections |
boolean (boolean) |
configSpec. postgresqlConfig_11_1C. logDisconnections |
boolean (boolean) |
configSpec. postgresqlConfig_11_1C. logDuration |
boolean (boolean) |
configSpec. postgresqlConfig_11_1C. logErrorVerbosity |
string |
configSpec. postgresqlConfig_11_1C. logLockWaits |
boolean (boolean) |
configSpec. postgresqlConfig_11_1C. logStatement |
string |
configSpec. postgresqlConfig_11_1C. logTempFiles |
integer (int64) |
configSpec. postgresqlConfig_11_1C. searchPath |
string |
configSpec. postgresqlConfig_11_1C. rowSecurity |
boolean (boolean) |
configSpec. postgresqlConfig_11_1C. defaultTransactionIsolation |
string |
configSpec. postgresqlConfig_11_1C. statementTimeout |
integer (int64) |
configSpec. postgresqlConfig_11_1C. lockTimeout |
integer (int64) |
configSpec. postgresqlConfig_11_1C. idleInTransactionSessionTimeout |
integer (int64) |
configSpec. postgresqlConfig_11_1C. byteaOutput |
string |
configSpec. postgresqlConfig_11_1C. xmlbinary |
string |
configSpec. postgresqlConfig_11_1C. xmloption |
string |
configSpec. postgresqlConfig_11_1C. ginPendingListLimit |
integer (int64) |
configSpec. postgresqlConfig_11_1C. deadlockTimeout |
integer (int64) |
configSpec. postgresqlConfig_11_1C. maxLocksPerTransaction |
integer (int64) |
configSpec. postgresqlConfig_11_1C. maxPredLocksPerTransaction |
integer (int64) |
configSpec. postgresqlConfig_11_1C. arrayNulls |
boolean (boolean) |
configSpec. postgresqlConfig_11_1C. backslashQuote |
string |
configSpec. postgresqlConfig_11_1C. defaultWithOids |
boolean (boolean) |
configSpec. postgresqlConfig_11_1C. escapeStringWarning |
boolean (boolean) |
configSpec. postgresqlConfig_11_1C. loCompatPrivileges |
boolean (boolean) |
configSpec. postgresqlConfig_11_1C. operatorPrecedenceWarning |
boolean (boolean) |
configSpec. postgresqlConfig_11_1C. quoteAllIdentifiers |
boolean (boolean) |
configSpec. postgresqlConfig_11_1C. standardConformingStrings |
boolean (boolean) |
configSpec. postgresqlConfig_11_1C. synchronizeSeqscans |
boolean (boolean) |
configSpec. postgresqlConfig_11_1C. transformNullEquals |
boolean (boolean) |
configSpec. postgresqlConfig_11_1C. exitOnError |
boolean (boolean) |
configSpec. postgresqlConfig_11_1C. seqPageCost |
number (double) |
configSpec. postgresqlConfig_11_1C. randomPageCost |
number (double) |
configSpec. postgresqlConfig_11_1C. autovacuumMaxWorkers |
integer (int64) Acceptable values are 1 to 32, inclusive. |
configSpec. postgresqlConfig_11_1C. autovacuumVacuumCostDelay |
integer (int64) Acceptable values are -1 to 100, inclusive. |
configSpec. postgresqlConfig_11_1C. autovacuumVacuumCostLimit |
integer (int64) Acceptable values are -1 to 10000, inclusive. |
configSpec. postgresqlConfig_11_1C. autovacuumNaptime |
integer (int64) Acceptable values are 1000 to 86400000, inclusive. |
configSpec. postgresqlConfig_11_1C. archiveTimeout |
integer (int64) Acceptable values are 10000 to 86400000, inclusive. |
configSpec. postgresqlConfig_11_1C. trackActivityQuerySize |
integer (int64) Acceptable values are 100 to 102400, inclusive. |
configSpec. postgresqlConfig_11_1C. onlineAnalyzeEnable |
boolean (boolean) |
configSpec. postgresqlConfig_11_1C. enableBitmapscan |
boolean (boolean) |
configSpec. postgresqlConfig_11_1C. enableHashagg |
boolean (boolean) |
configSpec. postgresqlConfig_11_1C. enableHashjoin |
boolean (boolean) |
configSpec. postgresqlConfig_11_1C. enableIndexscan |
boolean (boolean) |
configSpec. postgresqlConfig_11_1C. enableIndexonlyscan |
boolean (boolean) |
configSpec. postgresqlConfig_11_1C. enableMaterial |
boolean (boolean) |
configSpec. postgresqlConfig_11_1C. enableMergejoin |
boolean (boolean) |
configSpec. postgresqlConfig_11_1C. enableNestloop |
boolean (boolean) |
configSpec. postgresqlConfig_11_1C. enableSeqscan |
boolean (boolean) |
configSpec. postgresqlConfig_11_1C. enableSort |
boolean (boolean) |
configSpec. postgresqlConfig_11_1C. enableTidscan |
boolean (boolean) |
configSpec. postgresqlConfig_11_1C. maxWorkerProcesses |
integer (int64) Acceptable values are 0 to 1024, inclusive. |
configSpec. postgresqlConfig_11_1C. maxParallelWorkers |
integer (int64) Acceptable values are 0 to 1024, inclusive. |
configSpec. postgresqlConfig_11_1C. maxParallelWorkersPerGather |
integer (int64) Acceptable values are 0 to 1024, inclusive. |
configSpec. postgresqlConfig_11_1C. autovacuumVacuumScaleFactor |
number (double) Acceptable values are 0 to 1, inclusive. |
configSpec. postgresqlConfig_11_1C. autovacuumAnalyzeScaleFactor |
number (double) Acceptable values are 0 to 1, inclusive. |
configSpec. postgresqlConfig_11_1C. defaultTransactionReadOnly |
boolean (boolean) |
configSpec. postgresqlConfig_11_1C. timezone |
string |
configSpec. postgresqlConfig_11_1C. enableParallelAppend |
boolean (boolean) |
configSpec. postgresqlConfig_11_1C. enableParallelHash |
boolean (boolean) |
configSpec. postgresqlConfig_11_1C. enablePartitionPruning |
boolean (boolean) |
configSpec. postgresqlConfig_11_1C. enablePartitionwiseAggregate |
boolean (boolean) |
configSpec. postgresqlConfig_11_1C. enablePartitionwiseJoin |
boolean (boolean) |
configSpec. postgresqlConfig_11_1C. jit |
boolean (boolean) |
configSpec. postgresqlConfig_11_1C. maxParallelMaintenanceWorkers |
integer (int64) The minimum value is 0. |
configSpec. postgresqlConfig_11_1C. parallelLeaderParticipation |
boolean (boolean) |
configSpec. postgresqlConfig_11_1C. vacuumCleanupIndexScaleFactor |
number (double) Acceptable values are 0 to 10000000000, inclusive. |
configSpec. postgresqlConfig_11_1C. effectiveIoConcurrency |
integer (int64) Acceptable values are 0 to 1000, inclusive. |
configSpec. postgresqlConfig_11_1C. effectiveCacheSize |
integer (int64) Acceptable values are 0 to 549755813888, inclusive. |
configSpec. postgresqlConfig_11_1C. sharedPreloadLibraries[] |
string |
configSpec. postgresqlConfig_11_1C. autoExplainLogMinDuration |
integer (int64) Acceptable values are -1 to 2147483647, inclusive. |
configSpec. postgresqlConfig_11_1C. autoExplainLogAnalyze |
boolean (boolean) |
configSpec. postgresqlConfig_11_1C. autoExplainLogBuffers |
boolean (boolean) |
configSpec. postgresqlConfig_11_1C. autoExplainLogTiming |
boolean (boolean) |
configSpec. postgresqlConfig_11_1C. autoExplainLogTriggers |
boolean (boolean) |
configSpec. postgresqlConfig_11_1C. autoExplainLogVerbose |
boolean (boolean) |
configSpec. postgresqlConfig_11_1C. autoExplainLogNestedStatements |
boolean (boolean) |
configSpec. postgresqlConfig_11_1C. autoExplainSampleRate |
number (double) Acceptable values are 0 to 1, inclusive. |
configSpec. postgresqlConfig_11_1C. pgHintPlanEnableHint |
boolean (boolean) |
configSpec. postgresqlConfig_11_1C. pgHintPlanEnableHintTable |
boolean (boolean) |
configSpec. postgresqlConfig_11_1C. pgHintPlanDebugPrint |
string |
configSpec. postgresqlConfig_11_1C. pgHintPlanMessageLevel |
string |
configSpec. postgresqlConfig_11_1C. pgQualstatsEnabled |
boolean (boolean) |
configSpec. postgresqlConfig_11_1C. pgQualstatsTrackConstants |
boolean (boolean) |
configSpec. postgresqlConfig_11_1C. pgQualstatsMax |
integer (int64) |
configSpec. postgresqlConfig_11_1C. pgQualstatsResolveOids |
boolean (boolean) |
configSpec. postgresqlConfig_11_1C. pgQualstatsSampleRate |
number (double) |
configSpec. postgresqlConfig_11_1C. plantunerFixEmptyTable |
boolean (boolean) |
configSpec. postgresqlConfig_11_1C. maxStackDepth |
integer (int64) Acceptable values are 65536 to 134217728, inclusive. |
configSpec. postgresqlConfig_11_1C. geqo |
boolean (boolean) |
configSpec. postgresqlConfig_11_1C. geqoThreshold |
integer (int64) Acceptable values are 2 to 2147483647, inclusive. |
configSpec. postgresqlConfig_11_1C. geqoEffort |
integer (int64) Acceptable values are 1 to 10, inclusive. |
configSpec. postgresqlConfig_11_1C. geqoPoolSize |
integer (int64) |
configSpec. postgresqlConfig_11_1C. geqoGenerations |
integer (int64) |
configSpec. postgresqlConfig_11_1C. geqoSelectionBias |
number (double) Acceptable values are 1.5 to 2, inclusive. |
configSpec. postgresqlConfig_11_1C. geqoSeed |
number (double) Acceptable values are 0 to 1, inclusive. |
configSpec. postgresqlConfig_11_1C. pgTrgmSimilarityThreshold |
number (double) Acceptable values are 0 to 1, inclusive. |
configSpec. postgresqlConfig_11_1C. pgTrgmWordSimilarityThreshold |
number (double) Acceptable values are 0 to 1, inclusive. |
configSpec. postgresqlConfig_11_1C. pgTrgmStrictWordSimilarityThreshold |
number (double) Acceptable values are 0 to 1, inclusive. |
configSpec. postgresqlConfig_12 |
object Configuration for a PostgreSQL 12 cluster. configSpec includes only one of the fields postgresqlConfig_9_6 , postgresqlConfig_10_1C , postgresqlConfig_10 , postgresqlConfig_11 , postgresqlConfig_11_1C , postgresqlConfig_12 , postgresqlConfig_12_1C , postgresqlConfig_13 , postgresqlConfig_13_1C , postgresqlConfig_14 , postgresqlConfig_14_1C , postgresqlConfig_15 , postgresqlConfig_15_1C |
configSpec. postgresqlConfig_12. maxConnections |
integer (int64) |
configSpec. postgresqlConfig_12. sharedBuffers |
integer (int64) |
configSpec. postgresqlConfig_12. tempBuffers |
integer (int64) |
configSpec. postgresqlConfig_12. maxPreparedTransactions |
integer (int64) |
configSpec. postgresqlConfig_12. workMem |
integer (int64) |
configSpec. postgresqlConfig_12. maintenanceWorkMem |
integer (int64) |
configSpec. postgresqlConfig_12. autovacuumWorkMem |
integer (int64) |
configSpec. postgresqlConfig_12. tempFileLimit |
integer (int64) |
configSpec. postgresqlConfig_12. vacuumCostDelay |
integer (int64) |
configSpec. postgresqlConfig_12. vacuumCostPageHit |
integer (int64) |
configSpec. postgresqlConfig_12. vacuumCostPageMiss |
integer (int64) |
configSpec. postgresqlConfig_12. vacuumCostPageDirty |
integer (int64) |
configSpec. postgresqlConfig_12. vacuumCostLimit |
integer (int64) |
configSpec. postgresqlConfig_12. bgwriterDelay |
integer (int64) Acceptable values are 10 to 10000, inclusive. |
configSpec. postgresqlConfig_12. bgwriterLruMaxpages |
integer (int64) |
configSpec. postgresqlConfig_12. bgwriterLruMultiplier |
number (double) |
configSpec. postgresqlConfig_12. bgwriterFlushAfter |
integer (int64) Acceptable values are 0 to 2048, inclusive. |
configSpec. postgresqlConfig_12. backendFlushAfter |
integer (int64) Acceptable values are 0 to 2048, inclusive. |
configSpec. postgresqlConfig_12. oldSnapshotThreshold |
integer (int64) Acceptable values are -1 to 86400000, inclusive. |
configSpec. postgresqlConfig_12. walLevel |
string |
configSpec. postgresqlConfig_12. synchronousCommit |
string |
configSpec. postgresqlConfig_12. checkpointTimeout |
integer (int64) Acceptable values are 30000 to 86400000, inclusive. |
configSpec. postgresqlConfig_12. checkpointCompletionTarget |
number (double) |
configSpec. postgresqlConfig_12. checkpointFlushAfter |
integer (int64) Acceptable values are 0 to 2048, inclusive. |
configSpec. postgresqlConfig_12. maxWalSize |
integer (int64) |
configSpec. postgresqlConfig_12. minWalSize |
integer (int64) |
configSpec. postgresqlConfig_12. maxStandbyStreamingDelay |
integer (int64) |
configSpec. postgresqlConfig_12. defaultStatisticsTarget |
integer (int64) |
configSpec. postgresqlConfig_12. constraintExclusion |
string |
configSpec. postgresqlConfig_12. cursorTupleFraction |
number (double) |
configSpec. postgresqlConfig_12. fromCollapseLimit |
integer (int64) Acceptable values are 1 to 2147483647, inclusive. |
configSpec. postgresqlConfig_12. joinCollapseLimit |
integer (int64) Acceptable values are 1 to 2147483647, inclusive. |
configSpec. postgresqlConfig_12. forceParallelMode |
string |
configSpec. postgresqlConfig_12. clientMinMessages |
string |
configSpec. postgresqlConfig_12. logMinMessages |
string |
configSpec. postgresqlConfig_12. logMinErrorStatement |
string |
configSpec. postgresqlConfig_12. logMinDurationStatement |
integer (int64) |
configSpec. postgresqlConfig_12. logCheckpoints |
boolean (boolean) |
configSpec. postgresqlConfig_12. logConnections |
boolean (boolean) |
configSpec. postgresqlConfig_12. logDisconnections |
boolean (boolean) |
configSpec. postgresqlConfig_12. logDuration |
boolean (boolean) |
configSpec. postgresqlConfig_12. logErrorVerbosity |
string |
configSpec. postgresqlConfig_12. logLockWaits |
boolean (boolean) |
configSpec. postgresqlConfig_12. logStatement |
string |
configSpec. postgresqlConfig_12. logTempFiles |
integer (int64) |
configSpec. postgresqlConfig_12. searchPath |
string |
configSpec. postgresqlConfig_12. rowSecurity |
boolean (boolean) |
configSpec. postgresqlConfig_12. defaultTransactionIsolation |
string |
configSpec. postgresqlConfig_12. statementTimeout |
integer (int64) |
configSpec. postgresqlConfig_12. lockTimeout |
integer (int64) |
configSpec. postgresqlConfig_12. idleInTransactionSessionTimeout |
integer (int64) |
configSpec. postgresqlConfig_12. byteaOutput |
string |
configSpec. postgresqlConfig_12. xmlbinary |
string |
configSpec. postgresqlConfig_12. xmloption |
string |
configSpec. postgresqlConfig_12. ginPendingListLimit |
integer (int64) |
configSpec. postgresqlConfig_12. deadlockTimeout |
integer (int64) |
configSpec. postgresqlConfig_12. maxLocksPerTransaction |
integer (int64) |
configSpec. postgresqlConfig_12. maxPredLocksPerTransaction |
integer (int64) |
configSpec. postgresqlConfig_12. arrayNulls |
boolean (boolean) |
configSpec. postgresqlConfig_12. backslashQuote |
string |
configSpec. postgresqlConfig_12. defaultWithOids |
boolean (boolean) |
configSpec. postgresqlConfig_12. escapeStringWarning |
boolean (boolean) |
configSpec. postgresqlConfig_12. loCompatPrivileges |
boolean (boolean) |
configSpec. postgresqlConfig_12. operatorPrecedenceWarning |
boolean (boolean) |
configSpec. postgresqlConfig_12. quoteAllIdentifiers |
boolean (boolean) |
configSpec. postgresqlConfig_12. standardConformingStrings |
boolean (boolean) |
configSpec. postgresqlConfig_12. synchronizeSeqscans |
boolean (boolean) |
configSpec. postgresqlConfig_12. transformNullEquals |
boolean (boolean) |
configSpec. postgresqlConfig_12. exitOnError |
boolean (boolean) |
configSpec. postgresqlConfig_12. seqPageCost |
number (double) |
configSpec. postgresqlConfig_12. randomPageCost |
number (double) |
configSpec. postgresqlConfig_12. autovacuumMaxWorkers |
integer (int64) Acceptable values are 1 to 32, inclusive. |
configSpec. postgresqlConfig_12. autovacuumVacuumCostDelay |
integer (int64) Acceptable values are -1 to 100, inclusive. |
configSpec. postgresqlConfig_12. autovacuumVacuumCostLimit |
integer (int64) Acceptable values are -1 to 10000, inclusive. |
configSpec. postgresqlConfig_12. autovacuumNaptime |
integer (int64) Acceptable values are 1000 to 86400000, inclusive. |
configSpec. postgresqlConfig_12. archiveTimeout |
integer (int64) Acceptable values are 10000 to 86400000, inclusive. |
configSpec. postgresqlConfig_12. trackActivityQuerySize |
integer (int64) Acceptable values are 100 to 102400, inclusive. |
configSpec. postgresqlConfig_12. enableBitmapscan |
boolean (boolean) |
configSpec. postgresqlConfig_12. enableHashagg |
boolean (boolean) |
configSpec. postgresqlConfig_12. enableHashjoin |
boolean (boolean) |
configSpec. postgresqlConfig_12. enableIndexscan |
boolean (boolean) |
configSpec. postgresqlConfig_12. enableIndexonlyscan |
boolean (boolean) |
configSpec. postgresqlConfig_12. enableMaterial |
boolean (boolean) |
configSpec. postgresqlConfig_12. enableMergejoin |
boolean (boolean) |
configSpec. postgresqlConfig_12. enableNestloop |
boolean (boolean) |
configSpec. postgresqlConfig_12. enableSeqscan |
boolean (boolean) |
configSpec. postgresqlConfig_12. enableSort |
boolean (boolean) |
configSpec. postgresqlConfig_12. enableTidscan |
boolean (boolean) |
configSpec. postgresqlConfig_12. maxWorkerProcesses |
integer (int64) Acceptable values are 0 to 1024, inclusive. |
configSpec. postgresqlConfig_12. maxParallelWorkers |
integer (int64) Acceptable values are 0 to 1024, inclusive. |
configSpec. postgresqlConfig_12. maxParallelWorkersPerGather |
integer (int64) Acceptable values are 0 to 1024, inclusive. |
configSpec. postgresqlConfig_12. autovacuumVacuumScaleFactor |
number (double) Acceptable values are 0 to 1, inclusive. |
configSpec. postgresqlConfig_12. autovacuumAnalyzeScaleFactor |
number (double) Acceptable values are 0 to 1, inclusive. |
configSpec. postgresqlConfig_12. defaultTransactionReadOnly |
boolean (boolean) |
configSpec. postgresqlConfig_12. timezone |
string |
configSpec. postgresqlConfig_12. enableParallelAppend |
boolean (boolean) |
configSpec. postgresqlConfig_12. enableParallelHash |
boolean (boolean) |
configSpec. postgresqlConfig_12. enablePartitionPruning |
boolean (boolean) |
configSpec. postgresqlConfig_12. enablePartitionwiseAggregate |
boolean (boolean) |
configSpec. postgresqlConfig_12. enablePartitionwiseJoin |
boolean (boolean) |
configSpec. postgresqlConfig_12. jit |
boolean (boolean) |
configSpec. postgresqlConfig_12. maxParallelMaintenanceWorkers |
integer (int64) The minimum value is 0. |
configSpec. postgresqlConfig_12. parallelLeaderParticipation |
boolean (boolean) |
configSpec. postgresqlConfig_12. vacuumCleanupIndexScaleFactor |
number (double) Acceptable values are 0 to 10000000000, inclusive. |
configSpec. postgresqlConfig_12. logTransactionSampleRate |
number (double) Acceptable values are 0 to 1, inclusive. |
configSpec. postgresqlConfig_12. planCacheMode |
string |
configSpec. postgresqlConfig_12. effectiveIoConcurrency |
integer (int64) Acceptable values are 0 to 1000, inclusive. |
configSpec. postgresqlConfig_12. effectiveCacheSize |
integer (int64) Acceptable values are 0 to 549755813888, inclusive. |
configSpec. postgresqlConfig_12. sharedPreloadLibraries[] |
string |
configSpec. postgresqlConfig_12. autoExplainLogMinDuration |
integer (int64) Acceptable values are -1 to 2147483647, inclusive. |
configSpec. postgresqlConfig_12. autoExplainLogAnalyze |
boolean (boolean) |
configSpec. postgresqlConfig_12. autoExplainLogBuffers |
boolean (boolean) |
configSpec. postgresqlConfig_12. autoExplainLogTiming |
boolean (boolean) |
configSpec. postgresqlConfig_12. autoExplainLogTriggers |
boolean (boolean) |
configSpec. postgresqlConfig_12. autoExplainLogVerbose |
boolean (boolean) |
configSpec. postgresqlConfig_12. autoExplainLogNestedStatements |
boolean (boolean) |
configSpec. postgresqlConfig_12. autoExplainSampleRate |
number (double) Acceptable values are 0 to 1, inclusive. |
configSpec. postgresqlConfig_12. pgHintPlanEnableHint |
boolean (boolean) |
configSpec. postgresqlConfig_12. pgHintPlanEnableHintTable |
boolean (boolean) |
configSpec. postgresqlConfig_12. pgHintPlanDebugPrint |
string |
configSpec. postgresqlConfig_12. pgHintPlanMessageLevel |
string |
configSpec. postgresqlConfig_12. pgQualstatsEnabled |
boolean (boolean) |
configSpec. postgresqlConfig_12. pgQualstatsTrackConstants |
boolean (boolean) |
configSpec. postgresqlConfig_12. pgQualstatsMax |
integer (int64) |
configSpec. postgresqlConfig_12. pgQualstatsResolveOids |
boolean (boolean) |
configSpec. postgresqlConfig_12. pgQualstatsSampleRate |
number (double) |
configSpec. postgresqlConfig_12. maxStackDepth |
integer (int64) Acceptable values are 65536 to 134217728, inclusive. |
configSpec. postgresqlConfig_12. geqo |
boolean (boolean) |
configSpec. postgresqlConfig_12. geqoThreshold |
integer (int64) Acceptable values are 2 to 2147483647, inclusive. |
configSpec. postgresqlConfig_12. geqoEffort |
integer (int64) Acceptable values are 1 to 10, inclusive. |
configSpec. postgresqlConfig_12. geqoPoolSize |
integer (int64) |
configSpec. postgresqlConfig_12. geqoGenerations |
integer (int64) |
configSpec. postgresqlConfig_12. geqoSelectionBias |
number (double) Acceptable values are 1.5 to 2, inclusive. |
configSpec. postgresqlConfig_12. geqoSeed |
number (double) Acceptable values are 0 to 1, inclusive. |
configSpec. postgresqlConfig_12. pgTrgmSimilarityThreshold |
number (double) Acceptable values are 0 to 1, inclusive. |
configSpec. postgresqlConfig_12. pgTrgmWordSimilarityThreshold |
number (double) Acceptable values are 0 to 1, inclusive. |
configSpec. postgresqlConfig_12. pgTrgmStrictWordSimilarityThreshold |
number (double) Acceptable values are 0 to 1, inclusive. |
configSpec. postgresqlConfig_12_1C |
object Configuration for a PostgreSQL 12 1C cluster. configSpec includes only one of the fields postgresqlConfig_9_6 , postgresqlConfig_10_1C , postgresqlConfig_10 , postgresqlConfig_11 , postgresqlConfig_11_1C , postgresqlConfig_12 , postgresqlConfig_12_1C , postgresqlConfig_13 , postgresqlConfig_13_1C , postgresqlConfig_14 , postgresqlConfig_14_1C , postgresqlConfig_15 , postgresqlConfig_15_1C |
configSpec. postgresqlConfig_12_1C. maxConnections |
integer (int64) |
configSpec. postgresqlConfig_12_1C. sharedBuffers |
integer (int64) |
configSpec. postgresqlConfig_12_1C. tempBuffers |
integer (int64) |
configSpec. postgresqlConfig_12_1C. maxPreparedTransactions |
integer (int64) |
configSpec. postgresqlConfig_12_1C. workMem |
integer (int64) |
configSpec. postgresqlConfig_12_1C. maintenanceWorkMem |
integer (int64) |
configSpec. postgresqlConfig_12_1C. autovacuumWorkMem |
integer (int64) |
configSpec. postgresqlConfig_12_1C. tempFileLimit |
integer (int64) |
configSpec. postgresqlConfig_12_1C. vacuumCostDelay |
integer (int64) |
configSpec. postgresqlConfig_12_1C. vacuumCostPageHit |
integer (int64) |
configSpec. postgresqlConfig_12_1C. vacuumCostPageMiss |
integer (int64) |
configSpec. postgresqlConfig_12_1C. vacuumCostPageDirty |
integer (int64) |
configSpec. postgresqlConfig_12_1C. vacuumCostLimit |
integer (int64) |
configSpec. postgresqlConfig_12_1C. bgwriterDelay |
integer (int64) Acceptable values are 10 to 10000, inclusive. |
configSpec. postgresqlConfig_12_1C. bgwriterLruMaxpages |
integer (int64) |
configSpec. postgresqlConfig_12_1C. bgwriterLruMultiplier |
number (double) |
configSpec. postgresqlConfig_12_1C. bgwriterFlushAfter |
integer (int64) Acceptable values are 0 to 2048, inclusive. |
configSpec. postgresqlConfig_12_1C. backendFlushAfter |
integer (int64) Acceptable values are 0 to 2048, inclusive. |
configSpec. postgresqlConfig_12_1C. oldSnapshotThreshold |
integer (int64) Acceptable values are -1 to 86400000, inclusive. |
configSpec. postgresqlConfig_12_1C. walLevel |
string |
configSpec. postgresqlConfig_12_1C. synchronousCommit |
string |
configSpec. postgresqlConfig_12_1C. checkpointTimeout |
integer (int64) Acceptable values are 30000 to 86400000, inclusive. |
configSpec. postgresqlConfig_12_1C. checkpointCompletionTarget |
number (double) |
configSpec. postgresqlConfig_12_1C. checkpointFlushAfter |
integer (int64) Acceptable values are 0 to 2048, inclusive. |
configSpec. postgresqlConfig_12_1C. maxWalSize |
integer (int64) |
configSpec. postgresqlConfig_12_1C. minWalSize |
integer (int64) |
configSpec. postgresqlConfig_12_1C. maxStandbyStreamingDelay |
integer (int64) |
configSpec. postgresqlConfig_12_1C. defaultStatisticsTarget |
integer (int64) |
configSpec. postgresqlConfig_12_1C. constraintExclusion |
string |
configSpec. postgresqlConfig_12_1C. cursorTupleFraction |
number (double) |
configSpec. postgresqlConfig_12_1C. fromCollapseLimit |
integer (int64) Acceptable values are 1 to 2147483647, inclusive. |
configSpec. postgresqlConfig_12_1C. joinCollapseLimit |
integer (int64) Acceptable values are 1 to 2147483647, inclusive. |
configSpec. postgresqlConfig_12_1C. forceParallelMode |
string |
configSpec. postgresqlConfig_12_1C. clientMinMessages |
string |
configSpec. postgresqlConfig_12_1C. logMinMessages |
string |
configSpec. postgresqlConfig_12_1C. logMinErrorStatement |
string |
configSpec. postgresqlConfig_12_1C. logMinDurationStatement |
integer (int64) |
configSpec. postgresqlConfig_12_1C. logCheckpoints |
boolean (boolean) |
configSpec. postgresqlConfig_12_1C. logConnections |
boolean (boolean) |
configSpec. postgresqlConfig_12_1C. logDisconnections |
boolean (boolean) |
configSpec. postgresqlConfig_12_1C. logDuration |
boolean (boolean) |
configSpec. postgresqlConfig_12_1C. logErrorVerbosity |
string |
configSpec. postgresqlConfig_12_1C. logLockWaits |
boolean (boolean) |
configSpec. postgresqlConfig_12_1C. logStatement |
string |
configSpec. postgresqlConfig_12_1C. logTempFiles |
integer (int64) |
configSpec. postgresqlConfig_12_1C. searchPath |
string |
configSpec. postgresqlConfig_12_1C. rowSecurity |
boolean (boolean) |
configSpec. postgresqlConfig_12_1C. defaultTransactionIsolation |
string |
configSpec. postgresqlConfig_12_1C. statementTimeout |
integer (int64) |
configSpec. postgresqlConfig_12_1C. lockTimeout |
integer (int64) |
configSpec. postgresqlConfig_12_1C. idleInTransactionSessionTimeout |
integer (int64) |
configSpec. postgresqlConfig_12_1C. byteaOutput |
string |
configSpec. postgresqlConfig_12_1C. xmlbinary |
string |
configSpec. postgresqlConfig_12_1C. xmloption |
string |
configSpec. postgresqlConfig_12_1C. ginPendingListLimit |
integer (int64) |
configSpec. postgresqlConfig_12_1C. deadlockTimeout |
integer (int64) |
configSpec. postgresqlConfig_12_1C. maxLocksPerTransaction |
integer (int64) |
configSpec. postgresqlConfig_12_1C. maxPredLocksPerTransaction |
integer (int64) |
configSpec. postgresqlConfig_12_1C. arrayNulls |
boolean (boolean) |
configSpec. postgresqlConfig_12_1C. backslashQuote |
string |
configSpec. postgresqlConfig_12_1C. defaultWithOids |
boolean (boolean) |
configSpec. postgresqlConfig_12_1C. escapeStringWarning |
boolean (boolean) |
configSpec. postgresqlConfig_12_1C. loCompatPrivileges |
boolean (boolean) |
configSpec. postgresqlConfig_12_1C. operatorPrecedenceWarning |
boolean (boolean) |
configSpec. postgresqlConfig_12_1C. quoteAllIdentifiers |
boolean (boolean) |
configSpec. postgresqlConfig_12_1C. standardConformingStrings |
boolean (boolean) |
configSpec. postgresqlConfig_12_1C. synchronizeSeqscans |
boolean (boolean) |
configSpec. postgresqlConfig_12_1C. transformNullEquals |
boolean (boolean) |
configSpec. postgresqlConfig_12_1C. exitOnError |
boolean (boolean) |
configSpec. postgresqlConfig_12_1C. seqPageCost |
number (double) |
configSpec. postgresqlConfig_12_1C. randomPageCost |
number (double) |
configSpec. postgresqlConfig_12_1C. autovacuumMaxWorkers |
integer (int64) Acceptable values are 1 to 32, inclusive. |
configSpec. postgresqlConfig_12_1C. autovacuumVacuumCostDelay |
integer (int64) Acceptable values are -1 to 100, inclusive. |
configSpec. postgresqlConfig_12_1C. autovacuumVacuumCostLimit |
integer (int64) Acceptable values are -1 to 10000, inclusive. |
configSpec. postgresqlConfig_12_1C. autovacuumNaptime |
integer (int64) Acceptable values are 1000 to 86400000, inclusive. |
configSpec. postgresqlConfig_12_1C. archiveTimeout |
integer (int64) Acceptable values are 10000 to 86400000, inclusive. |
configSpec. postgresqlConfig_12_1C. trackActivityQuerySize |
integer (int64) Acceptable values are 100 to 102400, inclusive. |
configSpec. postgresqlConfig_12_1C. onlineAnalyzeEnable |
boolean (boolean) |
configSpec. postgresqlConfig_12_1C. enableBitmapscan |
boolean (boolean) |
configSpec. postgresqlConfig_12_1C. enableHashagg |
boolean (boolean) |
configSpec. postgresqlConfig_12_1C. enableHashjoin |
boolean (boolean) |
configSpec. postgresqlConfig_12_1C. enableIndexscan |
boolean (boolean) |
configSpec. postgresqlConfig_12_1C. enableIndexonlyscan |
boolean (boolean) |
configSpec. postgresqlConfig_12_1C. enableMaterial |
boolean (boolean) |
configSpec. postgresqlConfig_12_1C. enableMergejoin |
boolean (boolean) |
configSpec. postgresqlConfig_12_1C. enableNestloop |
boolean (boolean) |
configSpec. postgresqlConfig_12_1C. enableSeqscan |
boolean (boolean) |
configSpec. postgresqlConfig_12_1C. enableSort |
boolean (boolean) |
configSpec. postgresqlConfig_12_1C. enableTidscan |
boolean (boolean) |
configSpec. postgresqlConfig_12_1C. maxWorkerProcesses |
integer (int64) Acceptable values are 0 to 1024, inclusive. |
configSpec. postgresqlConfig_12_1C. maxParallelWorkers |
integer (int64) Acceptable values are 0 to 1024, inclusive. |
configSpec. postgresqlConfig_12_1C. maxParallelWorkersPerGather |
integer (int64) Acceptable values are 0 to 1024, inclusive. |
configSpec. postgresqlConfig_12_1C. autovacuumVacuumScaleFactor |
number (double) Acceptable values are 0 to 1, inclusive. |
configSpec. postgresqlConfig_12_1C. autovacuumAnalyzeScaleFactor |
number (double) Acceptable values are 0 to 1, inclusive. |
configSpec. postgresqlConfig_12_1C. defaultTransactionReadOnly |
boolean (boolean) |
configSpec. postgresqlConfig_12_1C. timezone |
string |
configSpec. postgresqlConfig_12_1C. enableParallelAppend |
boolean (boolean) |
configSpec. postgresqlConfig_12_1C. enableParallelHash |
boolean (boolean) |
configSpec. postgresqlConfig_12_1C. enablePartitionPruning |
boolean (boolean) |
configSpec. postgresqlConfig_12_1C. enablePartitionwiseAggregate |
boolean (boolean) |
configSpec. postgresqlConfig_12_1C. enablePartitionwiseJoin |
boolean (boolean) |
configSpec. postgresqlConfig_12_1C. jit |
boolean (boolean) |
configSpec. postgresqlConfig_12_1C. maxParallelMaintenanceWorkers |
integer (int64) The minimum value is 0. |
configSpec. postgresqlConfig_12_1C. parallelLeaderParticipation |
boolean (boolean) |
configSpec. postgresqlConfig_12_1C. vacuumCleanupIndexScaleFactor |
number (double) Acceptable values are 0 to 10000000000, inclusive. |
configSpec. postgresqlConfig_12_1C. logTransactionSampleRate |
number (double) Acceptable values are 0 to 1, inclusive. |
configSpec. postgresqlConfig_12_1C. planCacheMode |
string |
configSpec. postgresqlConfig_12_1C. effectiveIoConcurrency |
integer (int64) Acceptable values are 0 to 1000, inclusive. |
configSpec. postgresqlConfig_12_1C. effectiveCacheSize |
integer (int64) Acceptable values are 0 to 549755813888, inclusive. |
configSpec. postgresqlConfig_12_1C. sharedPreloadLibraries[] |
string |
configSpec. postgresqlConfig_12_1C. autoExplainLogMinDuration |
integer (int64) Acceptable values are -1 to 2147483647, inclusive. |
configSpec. postgresqlConfig_12_1C. autoExplainLogAnalyze |
boolean (boolean) |
configSpec. postgresqlConfig_12_1C. autoExplainLogBuffers |
boolean (boolean) |
configSpec. postgresqlConfig_12_1C. autoExplainLogTiming |
boolean (boolean) |
configSpec. postgresqlConfig_12_1C. autoExplainLogTriggers |
boolean (boolean) |
configSpec. postgresqlConfig_12_1C. autoExplainLogVerbose |
boolean (boolean) |
configSpec. postgresqlConfig_12_1C. autoExplainLogNestedStatements |
boolean (boolean) |
configSpec. postgresqlConfig_12_1C. autoExplainSampleRate |
number (double) Acceptable values are 0 to 1, inclusive. |
configSpec. postgresqlConfig_12_1C. pgHintPlanEnableHint |
boolean (boolean) |
configSpec. postgresqlConfig_12_1C. pgHintPlanEnableHintTable |
boolean (boolean) |
configSpec. postgresqlConfig_12_1C. pgHintPlanDebugPrint |
string |
configSpec. postgresqlConfig_12_1C. pgHintPlanMessageLevel |
string |
configSpec. postgresqlConfig_12_1C. pgQualstatsEnabled |
boolean (boolean) |
configSpec. postgresqlConfig_12_1C. pgQualstatsTrackConstants |
boolean (boolean) |
configSpec. postgresqlConfig_12_1C. pgQualstatsMax |
integer (int64) |
configSpec. postgresqlConfig_12_1C. pgQualstatsResolveOids |
boolean (boolean) |
configSpec. postgresqlConfig_12_1C. pgQualstatsSampleRate |
number (double) |
configSpec. postgresqlConfig_12_1C. plantunerFixEmptyTable |
boolean (boolean) |
configSpec. postgresqlConfig_12_1C. maxStackDepth |
integer (int64) Acceptable values are 65536 to 134217728, inclusive. |
configSpec. postgresqlConfig_12_1C. geqo |
boolean (boolean) |
configSpec. postgresqlConfig_12_1C. geqoThreshold |
integer (int64) Acceptable values are 2 to 2147483647, inclusive. |
configSpec. postgresqlConfig_12_1C. geqoEffort |
integer (int64) Acceptable values are 1 to 10, inclusive. |
configSpec. postgresqlConfig_12_1C. geqoPoolSize |
integer (int64) |
configSpec. postgresqlConfig_12_1C. geqoGenerations |
integer (int64) |
configSpec. postgresqlConfig_12_1C. geqoSelectionBias |
number (double) Acceptable values are 1.5 to 2, inclusive. |
configSpec. postgresqlConfig_12_1C. geqoSeed |
number (double) Acceptable values are 0 to 1, inclusive. |
configSpec. postgresqlConfig_12_1C. pgTrgmSimilarityThreshold |
number (double) Acceptable values are 0 to 1, inclusive. |
configSpec. postgresqlConfig_12_1C. pgTrgmWordSimilarityThreshold |
number (double) Acceptable values are 0 to 1, inclusive. |
configSpec. postgresqlConfig_12_1C. pgTrgmStrictWordSimilarityThreshold |
number (double) Acceptable values are 0 to 1, inclusive. |
configSpec. postgresqlConfig_13 |
object Configuration for a PostgreSQL 13 cluster. configSpec includes only one of the fields postgresqlConfig_9_6 , postgresqlConfig_10_1C , postgresqlConfig_10 , postgresqlConfig_11 , postgresqlConfig_11_1C , postgresqlConfig_12 , postgresqlConfig_12_1C , postgresqlConfig_13 , postgresqlConfig_13_1C , postgresqlConfig_14 , postgresqlConfig_14_1C , postgresqlConfig_15 , postgresqlConfig_15_1C |
configSpec. postgresqlConfig_13. maxConnections |
integer (int64) |
configSpec. postgresqlConfig_13. sharedBuffers |
integer (int64) |
configSpec. postgresqlConfig_13. tempBuffers |
integer (int64) |
configSpec. postgresqlConfig_13. maxPreparedTransactions |
integer (int64) |
configSpec. postgresqlConfig_13. workMem |
integer (int64) |
configSpec. postgresqlConfig_13. maintenanceWorkMem |
integer (int64) |
configSpec. postgresqlConfig_13. autovacuumWorkMem |
integer (int64) |
configSpec. postgresqlConfig_13. tempFileLimit |
integer (int64) |
configSpec. postgresqlConfig_13. vacuumCostDelay |
integer (int64) |
configSpec. postgresqlConfig_13. vacuumCostPageHit |
integer (int64) |
configSpec. postgresqlConfig_13. vacuumCostPageMiss |
integer (int64) |
configSpec. postgresqlConfig_13. vacuumCostPageDirty |
integer (int64) |
configSpec. postgresqlConfig_13. vacuumCostLimit |
integer (int64) |
configSpec. postgresqlConfig_13. bgwriterDelay |
integer (int64) Acceptable values are 10 to 10000, inclusive. |
configSpec. postgresqlConfig_13. bgwriterLruMaxpages |
integer (int64) |
configSpec. postgresqlConfig_13. bgwriterLruMultiplier |
number (double) |
configSpec. postgresqlConfig_13. bgwriterFlushAfter |
integer (int64) Acceptable values are 0 to 2048, inclusive. |
configSpec. postgresqlConfig_13. backendFlushAfter |
integer (int64) Acceptable values are 0 to 2048, inclusive. |
configSpec. postgresqlConfig_13. oldSnapshotThreshold |
integer (int64) Acceptable values are -1 to 86400000, inclusive. |
configSpec. postgresqlConfig_13. walLevel |
string |
configSpec. postgresqlConfig_13. synchronousCommit |
string |
configSpec. postgresqlConfig_13. checkpointTimeout |
integer (int64) Acceptable values are 30000 to 86400000, inclusive. |
configSpec. postgresqlConfig_13. checkpointCompletionTarget |
number (double) |
configSpec. postgresqlConfig_13. checkpointFlushAfter |
integer (int64) Acceptable values are 0 to 2048, inclusive. |
configSpec. postgresqlConfig_13. maxWalSize |
integer (int64) |
configSpec. postgresqlConfig_13. minWalSize |
integer (int64) |
configSpec. postgresqlConfig_13. maxStandbyStreamingDelay |
integer (int64) |
configSpec. postgresqlConfig_13. defaultStatisticsTarget |
integer (int64) |
configSpec. postgresqlConfig_13. constraintExclusion |
string |
configSpec. postgresqlConfig_13. cursorTupleFraction |
number (double) |
configSpec. postgresqlConfig_13. fromCollapseLimit |
integer (int64) Acceptable values are 1 to 2147483647, inclusive. |
configSpec. postgresqlConfig_13. joinCollapseLimit |
integer (int64) Acceptable values are 1 to 2147483647, inclusive. |
configSpec. postgresqlConfig_13. forceParallelMode |
string |
configSpec. postgresqlConfig_13. clientMinMessages |
string |
configSpec. postgresqlConfig_13. logMinMessages |
string |
configSpec. postgresqlConfig_13. logMinErrorStatement |
string |
configSpec. postgresqlConfig_13. logMinDurationStatement |
integer (int64) |
configSpec. postgresqlConfig_13. logCheckpoints |
boolean (boolean) |
configSpec. postgresqlConfig_13. logConnections |
boolean (boolean) |
configSpec. postgresqlConfig_13. logDisconnections |
boolean (boolean) |
configSpec. postgresqlConfig_13. logDuration |
boolean (boolean) |
configSpec. postgresqlConfig_13. logErrorVerbosity |
string |
configSpec. postgresqlConfig_13. logLockWaits |
boolean (boolean) |
configSpec. postgresqlConfig_13. logStatement |
string |
configSpec. postgresqlConfig_13. logTempFiles |
integer (int64) |
configSpec. postgresqlConfig_13. searchPath |
string |
configSpec. postgresqlConfig_13. rowSecurity |
boolean (boolean) |
configSpec. postgresqlConfig_13. defaultTransactionIsolation |
string |
configSpec. postgresqlConfig_13. statementTimeout |
integer (int64) |
configSpec. postgresqlConfig_13. lockTimeout |
integer (int64) |
configSpec. postgresqlConfig_13. idleInTransactionSessionTimeout |
integer (int64) |
configSpec. postgresqlConfig_13. byteaOutput |
string |
configSpec. postgresqlConfig_13. xmlbinary |
string |
configSpec. postgresqlConfig_13. xmloption |
string |
configSpec. postgresqlConfig_13. ginPendingListLimit |
integer (int64) |
configSpec. postgresqlConfig_13. deadlockTimeout |
integer (int64) |
configSpec. postgresqlConfig_13. maxLocksPerTransaction |
integer (int64) |
configSpec. postgresqlConfig_13. maxPredLocksPerTransaction |
integer (int64) |
configSpec. postgresqlConfig_13. arrayNulls |
boolean (boolean) |
configSpec. postgresqlConfig_13. backslashQuote |
string |
configSpec. postgresqlConfig_13. defaultWithOids |
boolean (boolean) |
configSpec. postgresqlConfig_13. escapeStringWarning |
boolean (boolean) |
configSpec. postgresqlConfig_13. loCompatPrivileges |
boolean (boolean) |
configSpec. postgresqlConfig_13. operatorPrecedenceWarning |
boolean (boolean) |
configSpec. postgresqlConfig_13. quoteAllIdentifiers |
boolean (boolean) |
configSpec. postgresqlConfig_13. standardConformingStrings |
boolean (boolean) |
configSpec. postgresqlConfig_13. synchronizeSeqscans |
boolean (boolean) |
configSpec. postgresqlConfig_13. transformNullEquals |
boolean (boolean) |
configSpec. postgresqlConfig_13. exitOnError |
boolean (boolean) |
configSpec. postgresqlConfig_13. seqPageCost |
number (double) |
configSpec. postgresqlConfig_13. randomPageCost |
number (double) |
configSpec. postgresqlConfig_13. autovacuumMaxWorkers |
integer (int64) Acceptable values are 1 to 32, inclusive. |
configSpec. postgresqlConfig_13. autovacuumVacuumCostDelay |
integer (int64) Acceptable values are -1 to 100, inclusive. |
configSpec. postgresqlConfig_13. autovacuumVacuumCostLimit |
integer (int64) Acceptable values are -1 to 10000, inclusive. |
configSpec. postgresqlConfig_13. autovacuumNaptime |
integer (int64) Acceptable values are 1000 to 86400000, inclusive. |
configSpec. postgresqlConfig_13. archiveTimeout |
integer (int64) Acceptable values are 10000 to 86400000, inclusive. |
configSpec. postgresqlConfig_13. trackActivityQuerySize |
integer (int64) Acceptable values are 100 to 102400, inclusive. |
configSpec. postgresqlConfig_13. enableBitmapscan |
boolean (boolean) |
configSpec. postgresqlConfig_13. enableHashagg |
boolean (boolean) |
configSpec. postgresqlConfig_13. enableHashjoin |
boolean (boolean) |
configSpec. postgresqlConfig_13. enableIndexscan |
boolean (boolean) |
configSpec. postgresqlConfig_13. enableIndexonlyscan |
boolean (boolean) |
configSpec. postgresqlConfig_13. enableMaterial |
boolean (boolean) |
configSpec. postgresqlConfig_13. enableMergejoin |
boolean (boolean) |
configSpec. postgresqlConfig_13. enableNestloop |
boolean (boolean) |
configSpec. postgresqlConfig_13. enableSeqscan |
boolean (boolean) |
configSpec. postgresqlConfig_13. enableSort |
boolean (boolean) |
configSpec. postgresqlConfig_13. enableTidscan |
boolean (boolean) |
configSpec. postgresqlConfig_13. maxWorkerProcesses |
integer (int64) Acceptable values are 0 to 1024, inclusive. |
configSpec. postgresqlConfig_13. maxParallelWorkers |
integer (int64) Acceptable values are 0 to 1024, inclusive. |
configSpec. postgresqlConfig_13. maxParallelWorkersPerGather |
integer (int64) Acceptable values are 0 to 1024, inclusive. |
configSpec. postgresqlConfig_13. autovacuumVacuumScaleFactor |
number (double) Acceptable values are 0 to 1, inclusive. |
configSpec. postgresqlConfig_13. autovacuumAnalyzeScaleFactor |
number (double) Acceptable values are 0 to 1, inclusive. |
configSpec. postgresqlConfig_13. defaultTransactionReadOnly |
boolean (boolean) |
configSpec. postgresqlConfig_13. timezone |
string |
configSpec. postgresqlConfig_13. enableParallelAppend |
boolean (boolean) |
configSpec. postgresqlConfig_13. enableParallelHash |
boolean (boolean) |
configSpec. postgresqlConfig_13. enablePartitionPruning |
boolean (boolean) |
configSpec. postgresqlConfig_13. enablePartitionwiseAggregate |
boolean (boolean) |
configSpec. postgresqlConfig_13. enablePartitionwiseJoin |
boolean (boolean) |
configSpec. postgresqlConfig_13. jit |
boolean (boolean) |
configSpec. postgresqlConfig_13. maxParallelMaintenanceWorkers |
integer (int64) The minimum value is 0. |
configSpec. postgresqlConfig_13. parallelLeaderParticipation |
boolean (boolean) |
configSpec. postgresqlConfig_13. vacuumCleanupIndexScaleFactor |
number (double) Acceptable values are 0 to 10000000000, inclusive. |
configSpec. postgresqlConfig_13. logTransactionSampleRate |
number (double) Acceptable values are 0 to 1, inclusive. |
configSpec. postgresqlConfig_13. planCacheMode |
string |
configSpec. postgresqlConfig_13. effectiveIoConcurrency |
integer (int64) Acceptable values are 0 to 1000, inclusive. |
configSpec. postgresqlConfig_13. effectiveCacheSize |
integer (int64) Acceptable values are 0 to 549755813888, inclusive. |
configSpec. postgresqlConfig_13. sharedPreloadLibraries[] |
string |
configSpec. postgresqlConfig_13. autoExplainLogMinDuration |
integer (int64) Acceptable values are -1 to 2147483647, inclusive. |
configSpec. postgresqlConfig_13. autoExplainLogAnalyze |
boolean (boolean) |
configSpec. postgresqlConfig_13. autoExplainLogBuffers |
boolean (boolean) |
configSpec. postgresqlConfig_13. autoExplainLogTiming |
boolean (boolean) |
configSpec. postgresqlConfig_13. autoExplainLogTriggers |
boolean (boolean) |
configSpec. postgresqlConfig_13. autoExplainLogVerbose |
boolean (boolean) |
configSpec. postgresqlConfig_13. autoExplainLogNestedStatements |
boolean (boolean) |
configSpec. postgresqlConfig_13. autoExplainSampleRate |
number (double) Acceptable values are 0 to 1, inclusive. |
configSpec. postgresqlConfig_13. pgHintPlanEnableHint |
boolean (boolean) |
configSpec. postgresqlConfig_13. pgHintPlanEnableHintTable |
boolean (boolean) |
configSpec. postgresqlConfig_13. pgHintPlanDebugPrint |
string |
configSpec. postgresqlConfig_13. pgHintPlanMessageLevel |
string |
configSpec. postgresqlConfig_13. hashMemMultiplier |
number (double) Acceptable values are 0 to 1000, inclusive. |
configSpec. postgresqlConfig_13. logicalDecodingWorkMem |
integer (int64) Acceptable values are 65536 to 1099511627776, inclusive. |
configSpec. postgresqlConfig_13. maintenanceIoConcurrency |
integer (int64) Acceptable values are 0 to 1000, inclusive. |
configSpec. postgresqlConfig_13. maxSlotWalKeepSize |
integer (int64) Acceptable values are -1 to 2251799812636672, inclusive. |
configSpec. postgresqlConfig_13. walKeepSize |
integer (int64) Acceptable values are -1 to 2251799812636672, inclusive. |
configSpec. postgresqlConfig_13. enableIncrementalSort |
boolean (boolean) |
configSpec. postgresqlConfig_13. autovacuumVacuumInsertThreshold |
integer (int64) Acceptable values are -1 to 2147483647, inclusive. |
configSpec. postgresqlConfig_13. autovacuumVacuumInsertScaleFactor |
number (double) Acceptable values are 0 to 100, inclusive. |
configSpec. postgresqlConfig_13. logMinDurationSample |
integer (int64) Acceptable values are -1 to 2147483647, inclusive. |
configSpec. postgresqlConfig_13. logStatementSampleRate |
number (double) Acceptable values are 0 to 1, inclusive. |
configSpec. postgresqlConfig_13. logParameterMaxLength |
integer (int64) Acceptable values are -1 to 2147483647, inclusive. |
configSpec. postgresqlConfig_13. logParameterMaxLengthOnError |
integer (int64) Acceptable values are -1 to 2147483647, inclusive. |
configSpec. postgresqlConfig_13. pgQualstatsEnabled |
boolean (boolean) |
configSpec. postgresqlConfig_13. pgQualstatsTrackConstants |
boolean (boolean) |
configSpec. postgresqlConfig_13. pgQualstatsMax |
integer (int64) |
configSpec. postgresqlConfig_13. pgQualstatsResolveOids |
boolean (boolean) |
configSpec. postgresqlConfig_13. pgQualstatsSampleRate |
number (double) |
configSpec. postgresqlConfig_13. maxStackDepth |
integer (int64) Acceptable values are 65536 to 134217728, inclusive. |
configSpec. postgresqlConfig_13. geqo |
boolean (boolean) |
configSpec. postgresqlConfig_13. geqoThreshold |
integer (int64) Acceptable values are 2 to 2147483647, inclusive. |
configSpec. postgresqlConfig_13. geqoEffort |
integer (int64) Acceptable values are 1 to 10, inclusive. |
configSpec. postgresqlConfig_13. geqoPoolSize |
integer (int64) |
configSpec. postgresqlConfig_13. geqoGenerations |
integer (int64) |
configSpec. postgresqlConfig_13. geqoSelectionBias |
number (double) Acceptable values are 1.5 to 2, inclusive. |
configSpec. postgresqlConfig_13. geqoSeed |
number (double) Acceptable values are 0 to 1, inclusive. |
configSpec. postgresqlConfig_13. pgTrgmSimilarityThreshold |
number (double) Acceptable values are 0 to 1, inclusive. |
configSpec. postgresqlConfig_13. pgTrgmWordSimilarityThreshold |
number (double) Acceptable values are 0 to 1, inclusive. |
configSpec. postgresqlConfig_13. pgTrgmStrictWordSimilarityThreshold |
number (double) Acceptable values are 0 to 1, inclusive. |
configSpec. postgresqlConfig_13_1C |
object Configuration for a PostgreSQL 13 1C cluster. configSpec includes only one of the fields postgresqlConfig_9_6 , postgresqlConfig_10_1C , postgresqlConfig_10 , postgresqlConfig_11 , postgresqlConfig_11_1C , postgresqlConfig_12 , postgresqlConfig_12_1C , postgresqlConfig_13 , postgresqlConfig_13_1C , postgresqlConfig_14 , postgresqlConfig_14_1C , postgresqlConfig_15 , postgresqlConfig_15_1C |
configSpec. postgresqlConfig_13_1C. maxConnections |
integer (int64) |
configSpec. postgresqlConfig_13_1C. sharedBuffers |
integer (int64) |
configSpec. postgresqlConfig_13_1C. tempBuffers |
integer (int64) |
configSpec. postgresqlConfig_13_1C. maxPreparedTransactions |
integer (int64) |
configSpec. postgresqlConfig_13_1C. workMem |
integer (int64) |
configSpec. postgresqlConfig_13_1C. maintenanceWorkMem |
integer (int64) |
configSpec. postgresqlConfig_13_1C. autovacuumWorkMem |
integer (int64) |
configSpec. postgresqlConfig_13_1C. tempFileLimit |
integer (int64) |
configSpec. postgresqlConfig_13_1C. vacuumCostDelay |
integer (int64) |
configSpec. postgresqlConfig_13_1C. vacuumCostPageHit |
integer (int64) |
configSpec. postgresqlConfig_13_1C. vacuumCostPageMiss |
integer (int64) |
configSpec. postgresqlConfig_13_1C. vacuumCostPageDirty |
integer (int64) |
configSpec. postgresqlConfig_13_1C. vacuumCostLimit |
integer (int64) |
configSpec. postgresqlConfig_13_1C. bgwriterDelay |
integer (int64) Acceptable values are 10 to 10000, inclusive. |
configSpec. postgresqlConfig_13_1C. bgwriterLruMaxpages |
integer (int64) |
configSpec. postgresqlConfig_13_1C. bgwriterLruMultiplier |
number (double) |
configSpec. postgresqlConfig_13_1C. bgwriterFlushAfter |
integer (int64) Acceptable values are 0 to 2048, inclusive. |
configSpec. postgresqlConfig_13_1C. backendFlushAfter |
integer (int64) Acceptable values are 0 to 2048, inclusive. |
configSpec. postgresqlConfig_13_1C. oldSnapshotThreshold |
integer (int64) Acceptable values are -1 to 86400000, inclusive. |
configSpec. postgresqlConfig_13_1C. walLevel |
string |
configSpec. postgresqlConfig_13_1C. synchronousCommit |
string |
configSpec. postgresqlConfig_13_1C. checkpointTimeout |
integer (int64) Acceptable values are 30000 to 86400000, inclusive. |
configSpec. postgresqlConfig_13_1C. checkpointCompletionTarget |
number (double) |
configSpec. postgresqlConfig_13_1C. checkpointFlushAfter |
integer (int64) Acceptable values are 0 to 2048, inclusive. |
configSpec. postgresqlConfig_13_1C. maxWalSize |
integer (int64) |
configSpec. postgresqlConfig_13_1C. minWalSize |
integer (int64) |
configSpec. postgresqlConfig_13_1C. maxStandbyStreamingDelay |
integer (int64) |
configSpec. postgresqlConfig_13_1C. defaultStatisticsTarget |
integer (int64) |
configSpec. postgresqlConfig_13_1C. constraintExclusion |
string |
configSpec. postgresqlConfig_13_1C. cursorTupleFraction |
number (double) |
configSpec. postgresqlConfig_13_1C. fromCollapseLimit |
integer (int64) Acceptable values are 1 to 2147483647, inclusive. |
configSpec. postgresqlConfig_13_1C. joinCollapseLimit |
integer (int64) Acceptable values are 1 to 2147483647, inclusive. |
configSpec. postgresqlConfig_13_1C. forceParallelMode |
string |
configSpec. postgresqlConfig_13_1C. clientMinMessages |
string |
configSpec. postgresqlConfig_13_1C. logMinMessages |
string |
configSpec. postgresqlConfig_13_1C. logMinErrorStatement |
string |
configSpec. postgresqlConfig_13_1C. logMinDurationStatement |
integer (int64) |
configSpec. postgresqlConfig_13_1C. logCheckpoints |
boolean (boolean) |
configSpec. postgresqlConfig_13_1C. logConnections |
boolean (boolean) |
configSpec. postgresqlConfig_13_1C. logDisconnections |
boolean (boolean) |
configSpec. postgresqlConfig_13_1C. logDuration |
boolean (boolean) |
configSpec. postgresqlConfig_13_1C. logErrorVerbosity |
string |
configSpec. postgresqlConfig_13_1C. logLockWaits |
boolean (boolean) |
configSpec. postgresqlConfig_13_1C. logStatement |
string |
configSpec. postgresqlConfig_13_1C. logTempFiles |
integer (int64) |
configSpec. postgresqlConfig_13_1C. searchPath |
string |
configSpec. postgresqlConfig_13_1C. rowSecurity |
boolean (boolean) |
configSpec. postgresqlConfig_13_1C. defaultTransactionIsolation |
string |
configSpec. postgresqlConfig_13_1C. statementTimeout |
integer (int64) |
configSpec. postgresqlConfig_13_1C. lockTimeout |
integer (int64) |
configSpec. postgresqlConfig_13_1C. idleInTransactionSessionTimeout |
integer (int64) |
configSpec. postgresqlConfig_13_1C. byteaOutput |
string |
configSpec. postgresqlConfig_13_1C. xmlbinary |
string |
configSpec. postgresqlConfig_13_1C. xmloption |
string |
configSpec. postgresqlConfig_13_1C. ginPendingListLimit |
integer (int64) |
configSpec. postgresqlConfig_13_1C. deadlockTimeout |
integer (int64) |
configSpec. postgresqlConfig_13_1C. maxLocksPerTransaction |
integer (int64) |
configSpec. postgresqlConfig_13_1C. maxPredLocksPerTransaction |
integer (int64) |
configSpec. postgresqlConfig_13_1C. arrayNulls |
boolean (boolean) |
configSpec. postgresqlConfig_13_1C. backslashQuote |
string |
configSpec. postgresqlConfig_13_1C. defaultWithOids |
boolean (boolean) |
configSpec. postgresqlConfig_13_1C. escapeStringWarning |
boolean (boolean) |
configSpec. postgresqlConfig_13_1C. loCompatPrivileges |
boolean (boolean) |
configSpec. postgresqlConfig_13_1C. operatorPrecedenceWarning |
boolean (boolean) |
configSpec. postgresqlConfig_13_1C. quoteAllIdentifiers |
boolean (boolean) |
configSpec. postgresqlConfig_13_1C. standardConformingStrings |
boolean (boolean) |
configSpec. postgresqlConfig_13_1C. synchronizeSeqscans |
boolean (boolean) |
configSpec. postgresqlConfig_13_1C. transformNullEquals |
boolean (boolean) |
configSpec. postgresqlConfig_13_1C. exitOnError |
boolean (boolean) |
configSpec. postgresqlConfig_13_1C. seqPageCost |
number (double) |
configSpec. postgresqlConfig_13_1C. randomPageCost |
number (double) |
configSpec. postgresqlConfig_13_1C. autovacuumMaxWorkers |
integer (int64) Acceptable values are 1 to 32, inclusive. |
configSpec. postgresqlConfig_13_1C. autovacuumVacuumCostDelay |
integer (int64) Acceptable values are -1 to 100, inclusive. |
configSpec. postgresqlConfig_13_1C. autovacuumVacuumCostLimit |
integer (int64) Acceptable values are -1 to 10000, inclusive. |
configSpec. postgresqlConfig_13_1C. autovacuumNaptime |
integer (int64) Acceptable values are 1000 to 86400000, inclusive. |
configSpec. postgresqlConfig_13_1C. archiveTimeout |
integer (int64) Acceptable values are 10000 to 86400000, inclusive. |
configSpec. postgresqlConfig_13_1C. trackActivityQuerySize |
integer (int64) Acceptable values are 100 to 102400, inclusive. |
configSpec. postgresqlConfig_13_1C. onlineAnalyzeEnable |
boolean (boolean) |
configSpec. postgresqlConfig_13_1C. enableBitmapscan |
boolean (boolean) |
configSpec. postgresqlConfig_13_1C. enableHashagg |
boolean (boolean) |
configSpec. postgresqlConfig_13_1C. enableHashjoin |
boolean (boolean) |
configSpec. postgresqlConfig_13_1C. enableIndexscan |
boolean (boolean) |
configSpec. postgresqlConfig_13_1C. enableIndexonlyscan |
boolean (boolean) |
configSpec. postgresqlConfig_13_1C. enableMaterial |
boolean (boolean) |
configSpec. postgresqlConfig_13_1C. enableMergejoin |
boolean (boolean) |
configSpec. postgresqlConfig_13_1C. enableNestloop |
boolean (boolean) |
configSpec. postgresqlConfig_13_1C. enableSeqscan |
boolean (boolean) |
configSpec. postgresqlConfig_13_1C. enableSort |
boolean (boolean) |
configSpec. postgresqlConfig_13_1C. enableTidscan |
boolean (boolean) |
configSpec. postgresqlConfig_13_1C. maxWorkerProcesses |
integer (int64) Acceptable values are 0 to 1024, inclusive. |
configSpec. postgresqlConfig_13_1C. maxParallelWorkers |
integer (int64) Acceptable values are 0 to 1024, inclusive. |
configSpec. postgresqlConfig_13_1C. maxParallelWorkersPerGather |
integer (int64) Acceptable values are 0 to 1024, inclusive. |
configSpec. postgresqlConfig_13_1C. autovacuumVacuumScaleFactor |
number (double) Acceptable values are 0 to 1, inclusive. |
configSpec. postgresqlConfig_13_1C. autovacuumAnalyzeScaleFactor |
number (double) Acceptable values are 0 to 1, inclusive. |
configSpec. postgresqlConfig_13_1C. defaultTransactionReadOnly |
boolean (boolean) |
configSpec. postgresqlConfig_13_1C. timezone |
string |
configSpec. postgresqlConfig_13_1C. enableParallelAppend |
boolean (boolean) |
configSpec. postgresqlConfig_13_1C. enableParallelHash |
boolean (boolean) |
configSpec. postgresqlConfig_13_1C. enablePartitionPruning |
boolean (boolean) |
configSpec. postgresqlConfig_13_1C. enablePartitionwiseAggregate |
boolean (boolean) |
configSpec. postgresqlConfig_13_1C. enablePartitionwiseJoin |
boolean (boolean) |
configSpec. postgresqlConfig_13_1C. jit |
boolean (boolean) |
configSpec. postgresqlConfig_13_1C. maxParallelMaintenanceWorkers |
integer (int64) The minimum value is 0. |
configSpec. postgresqlConfig_13_1C. parallelLeaderParticipation |
boolean (boolean) |
configSpec. postgresqlConfig_13_1C. vacuumCleanupIndexScaleFactor |
number (double) Acceptable values are 0 to 10000000000, inclusive. |
configSpec. postgresqlConfig_13_1C. logTransactionSampleRate |
number (double) Acceptable values are 0 to 1, inclusive. |
configSpec. postgresqlConfig_13_1C. planCacheMode |
string |
configSpec. postgresqlConfig_13_1C. effectiveIoConcurrency |
integer (int64) Acceptable values are 0 to 1000, inclusive. |
configSpec. postgresqlConfig_13_1C. effectiveCacheSize |
integer (int64) Acceptable values are 0 to 549755813888, inclusive. |
configSpec. postgresqlConfig_13_1C. sharedPreloadLibraries[] |
string |
configSpec. postgresqlConfig_13_1C. autoExplainLogMinDuration |
integer (int64) Acceptable values are -1 to 2147483647, inclusive. |
configSpec. postgresqlConfig_13_1C. autoExplainLogAnalyze |
boolean (boolean) |
configSpec. postgresqlConfig_13_1C. autoExplainLogBuffers |
boolean (boolean) |
configSpec. postgresqlConfig_13_1C. autoExplainLogTiming |
boolean (boolean) |
configSpec. postgresqlConfig_13_1C. autoExplainLogTriggers |
boolean (boolean) |
configSpec. postgresqlConfig_13_1C. autoExplainLogVerbose |
boolean (boolean) |
configSpec. postgresqlConfig_13_1C. autoExplainLogNestedStatements |
boolean (boolean) |
configSpec. postgresqlConfig_13_1C. autoExplainSampleRate |
number (double) Acceptable values are 0 to 1, inclusive. |
configSpec. postgresqlConfig_13_1C. pgHintPlanEnableHint |
boolean (boolean) |
configSpec. postgresqlConfig_13_1C. pgHintPlanEnableHintTable |
boolean (boolean) |
configSpec. postgresqlConfig_13_1C. pgHintPlanDebugPrint |
string |
configSpec. postgresqlConfig_13_1C. pgHintPlanMessageLevel |
string |
configSpec. postgresqlConfig_13_1C. hashMemMultiplier |
number (double) Acceptable values are 0 to 1000, inclusive. |
configSpec. postgresqlConfig_13_1C. logicalDecodingWorkMem |
integer (int64) Acceptable values are 65536 to 1099511627776, inclusive. |
configSpec. postgresqlConfig_13_1C. maintenanceIoConcurrency |
integer (int64) Acceptable values are 0 to 1000, inclusive. |
configSpec. postgresqlConfig_13_1C. maxSlotWalKeepSize |
integer (int64) Acceptable values are -1 to 2251799812636672, inclusive. |
configSpec. postgresqlConfig_13_1C. walKeepSize |
integer (int64) Acceptable values are -1 to 2251799812636672, inclusive. |
configSpec. postgresqlConfig_13_1C. enableIncrementalSort |
boolean (boolean) |
configSpec. postgresqlConfig_13_1C. autovacuumVacuumInsertThreshold |
integer (int64) Acceptable values are -1 to 2147483647, inclusive. |
configSpec. postgresqlConfig_13_1C. autovacuumVacuumInsertScaleFactor |
number (double) Acceptable values are 0 to 100, inclusive. |
configSpec. postgresqlConfig_13_1C. logMinDurationSample |
integer (int64) Acceptable values are -1 to 2147483647, inclusive. |
configSpec. postgresqlConfig_13_1C. logStatementSampleRate |
number (double) Acceptable values are 0 to 1, inclusive. |
configSpec. postgresqlConfig_13_1C. logParameterMaxLength |
integer (int64) Acceptable values are -1 to 2147483647, inclusive. |
configSpec. postgresqlConfig_13_1C. logParameterMaxLengthOnError |
integer (int64) Acceptable values are -1 to 2147483647, inclusive. |
configSpec. postgresqlConfig_13_1C. pgQualstatsEnabled |
boolean (boolean) |
configSpec. postgresqlConfig_13_1C. pgQualstatsTrackConstants |
boolean (boolean) |
configSpec. postgresqlConfig_13_1C. pgQualstatsMax |
integer (int64) |
configSpec. postgresqlConfig_13_1C. pgQualstatsResolveOids |
boolean (boolean) |
configSpec. postgresqlConfig_13_1C. pgQualstatsSampleRate |
number (double) |
configSpec. postgresqlConfig_13_1C. plantunerFixEmptyTable |
boolean (boolean) |
configSpec. postgresqlConfig_13_1C. geqo |
boolean (boolean) |
configSpec. postgresqlConfig_13_1C. geqoThreshold |
integer (int64) Acceptable values are 2 to 2147483647, inclusive. |
configSpec. postgresqlConfig_13_1C. geqoEffort |
integer (int64) Acceptable values are 1 to 10, inclusive. |
configSpec. postgresqlConfig_13_1C. geqoPoolSize |
integer (int64) |
configSpec. postgresqlConfig_13_1C. geqoGenerations |
integer (int64) |
configSpec. postgresqlConfig_13_1C. geqoSelectionBias |
number (double) Acceptable values are 1.5 to 2, inclusive. |
configSpec. postgresqlConfig_13_1C. geqoSeed |
number (double) Acceptable values are 0 to 1, inclusive. |
configSpec. postgresqlConfig_13_1C. pgTrgmSimilarityThreshold |
number (double) Acceptable values are 0 to 1, inclusive. |
configSpec. postgresqlConfig_13_1C. pgTrgmWordSimilarityThreshold |
number (double) Acceptable values are 0 to 1, inclusive. |
configSpec. postgresqlConfig_13_1C. pgTrgmStrictWordSimilarityThreshold |
number (double) Acceptable values are 0 to 1, inclusive. |
configSpec. postgresqlConfig_14 |
object Configuration for a PostgreSQL 14 cluster. configSpec includes only one of the fields postgresqlConfig_9_6 , postgresqlConfig_10_1C , postgresqlConfig_10 , postgresqlConfig_11 , postgresqlConfig_11_1C , postgresqlConfig_12 , postgresqlConfig_12_1C , postgresqlConfig_13 , postgresqlConfig_13_1C , postgresqlConfig_14 , postgresqlConfig_14_1C , postgresqlConfig_15 , postgresqlConfig_15_1C |
configSpec. postgresqlConfig_14. maxConnections |
integer (int64) |
configSpec. postgresqlConfig_14. sharedBuffers |
integer (int64) |
configSpec. postgresqlConfig_14. tempBuffers |
integer (int64) |
configSpec. postgresqlConfig_14. maxPreparedTransactions |
integer (int64) |
configSpec. postgresqlConfig_14. workMem |
integer (int64) |
configSpec. postgresqlConfig_14. maintenanceWorkMem |
integer (int64) |
configSpec. postgresqlConfig_14. autovacuumWorkMem |
integer (int64) |
configSpec. postgresqlConfig_14. tempFileLimit |
integer (int64) |
configSpec. postgresqlConfig_14. vacuumCostDelay |
integer (int64) |
configSpec. postgresqlConfig_14. vacuumCostPageHit |
integer (int64) |
configSpec. postgresqlConfig_14. vacuumCostPageMiss |
integer (int64) |
configSpec. postgresqlConfig_14. vacuumCostPageDirty |
integer (int64) |
configSpec. postgresqlConfig_14. vacuumCostLimit |
integer (int64) |
configSpec. postgresqlConfig_14. bgwriterDelay |
integer (int64) Acceptable values are 10 to 10000, inclusive. |
configSpec. postgresqlConfig_14. bgwriterLruMaxpages |
integer (int64) |
configSpec. postgresqlConfig_14. bgwriterLruMultiplier |
number (double) |
configSpec. postgresqlConfig_14. bgwriterFlushAfter |
integer (int64) Acceptable values are 0 to 2048, inclusive. |
configSpec. postgresqlConfig_14. backendFlushAfter |
integer (int64) Acceptable values are 0 to 2048, inclusive. |
configSpec. postgresqlConfig_14. oldSnapshotThreshold |
integer (int64) Acceptable values are -1 to 86400000, inclusive. |
configSpec. postgresqlConfig_14. walLevel |
string |
configSpec. postgresqlConfig_14. synchronousCommit |
string |
configSpec. postgresqlConfig_14. checkpointTimeout |
integer (int64) Acceptable values are 30000 to 86400000, inclusive. |
configSpec. postgresqlConfig_14. checkpointCompletionTarget |
number (double) |
configSpec. postgresqlConfig_14. checkpointFlushAfter |
integer (int64) Acceptable values are 0 to 2048, inclusive. |
configSpec. postgresqlConfig_14. maxWalSize |
integer (int64) |
configSpec. postgresqlConfig_14. minWalSize |
integer (int64) |
configSpec. postgresqlConfig_14. maxStandbyStreamingDelay |
integer (int64) |
configSpec. postgresqlConfig_14. defaultStatisticsTarget |
integer (int64) |
configSpec. postgresqlConfig_14. constraintExclusion |
string |
configSpec. postgresqlConfig_14. cursorTupleFraction |
number (double) |
configSpec. postgresqlConfig_14. fromCollapseLimit |
integer (int64) Acceptable values are 1 to 2147483647, inclusive. |
configSpec. postgresqlConfig_14. joinCollapseLimit |
integer (int64) Acceptable values are 1 to 2147483647, inclusive. |
configSpec. postgresqlConfig_14. forceParallelMode |
string |
configSpec. postgresqlConfig_14. clientMinMessages |
string |
configSpec. postgresqlConfig_14. logMinMessages |
string |
configSpec. postgresqlConfig_14. logMinErrorStatement |
string |
configSpec. postgresqlConfig_14. logMinDurationStatement |
integer (int64) |
configSpec. postgresqlConfig_14. logCheckpoints |
boolean (boolean) |
configSpec. postgresqlConfig_14. logConnections |
boolean (boolean) |
configSpec. postgresqlConfig_14. logDisconnections |
boolean (boolean) |
configSpec. postgresqlConfig_14. logDuration |
boolean (boolean) |
configSpec. postgresqlConfig_14. logErrorVerbosity |
string |
configSpec. postgresqlConfig_14. logLockWaits |
boolean (boolean) |
configSpec. postgresqlConfig_14. logStatement |
string |
configSpec. postgresqlConfig_14. logTempFiles |
integer (int64) |
configSpec. postgresqlConfig_14. searchPath |
string |
configSpec. postgresqlConfig_14. rowSecurity |
boolean (boolean) |
configSpec. postgresqlConfig_14. defaultTransactionIsolation |
string |
configSpec. postgresqlConfig_14. statementTimeout |
integer (int64) |
configSpec. postgresqlConfig_14. lockTimeout |
integer (int64) |
configSpec. postgresqlConfig_14. idleInTransactionSessionTimeout |
integer (int64) |
configSpec. postgresqlConfig_14. byteaOutput |
string |
configSpec. postgresqlConfig_14. xmlbinary |
string |
configSpec. postgresqlConfig_14. xmloption |
string |
configSpec. postgresqlConfig_14. ginPendingListLimit |
integer (int64) |
configSpec. postgresqlConfig_14. deadlockTimeout |
integer (int64) |
configSpec. postgresqlConfig_14. maxLocksPerTransaction |
integer (int64) |
configSpec. postgresqlConfig_14. maxPredLocksPerTransaction |
integer (int64) |
configSpec. postgresqlConfig_14. arrayNulls |
boolean (boolean) |
configSpec. postgresqlConfig_14. backslashQuote |
string |
configSpec. postgresqlConfig_14. defaultWithOids |
boolean (boolean) |
configSpec. postgresqlConfig_14. escapeStringWarning |
boolean (boolean) |
configSpec. postgresqlConfig_14. loCompatPrivileges |
boolean (boolean) |
configSpec. postgresqlConfig_14. quoteAllIdentifiers |
boolean (boolean) |
configSpec. postgresqlConfig_14. standardConformingStrings |
boolean (boolean) |
configSpec. postgresqlConfig_14. synchronizeSeqscans |
boolean (boolean) |
configSpec. postgresqlConfig_14. transformNullEquals |
boolean (boolean) |
configSpec. postgresqlConfig_14. exitOnError |
boolean (boolean) |
configSpec. postgresqlConfig_14. seqPageCost |
number (double) |
configSpec. postgresqlConfig_14. randomPageCost |
number (double) |
configSpec. postgresqlConfig_14. autovacuumMaxWorkers |
integer (int64) Acceptable values are 1 to 32, inclusive. |
configSpec. postgresqlConfig_14. autovacuumVacuumCostDelay |
integer (int64) Acceptable values are -1 to 100, inclusive. |
configSpec. postgresqlConfig_14. autovacuumVacuumCostLimit |
integer (int64) Acceptable values are -1 to 10000, inclusive. |
configSpec. postgresqlConfig_14. autovacuumNaptime |
integer (int64) Acceptable values are 1000 to 86400000, inclusive. |
configSpec. postgresqlConfig_14. archiveTimeout |
integer (int64) Acceptable values are 10000 to 86400000, inclusive. |
configSpec. postgresqlConfig_14. trackActivityQuerySize |
integer (int64) Acceptable values are 100 to 102400, inclusive. |
configSpec. postgresqlConfig_14. enableBitmapscan |
boolean (boolean) |
configSpec. postgresqlConfig_14. enableHashagg |
boolean (boolean) |
configSpec. postgresqlConfig_14. enableHashjoin |
boolean (boolean) |
configSpec. postgresqlConfig_14. enableIndexscan |
boolean (boolean) |
configSpec. postgresqlConfig_14. enableIndexonlyscan |
boolean (boolean) |
configSpec. postgresqlConfig_14. enableMaterial |
boolean (boolean) |
configSpec. postgresqlConfig_14. enableMergejoin |
boolean (boolean) |
configSpec. postgresqlConfig_14. enableNestloop |
boolean (boolean) |
configSpec. postgresqlConfig_14. enableSeqscan |
boolean (boolean) |
configSpec. postgresqlConfig_14. enableSort |
boolean (boolean) |
configSpec. postgresqlConfig_14. enableTidscan |
boolean (boolean) |
configSpec. postgresqlConfig_14. maxWorkerProcesses |
integer (int64) Acceptable values are 0 to 1024, inclusive. |
configSpec. postgresqlConfig_14. maxParallelWorkers |
integer (int64) Acceptable values are 0 to 1024, inclusive. |
configSpec. postgresqlConfig_14. maxParallelWorkersPerGather |
integer (int64) Acceptable values are 0 to 1024, inclusive. |
configSpec. postgresqlConfig_14. autovacuumVacuumScaleFactor |
number (double) Acceptable values are 0 to 1, inclusive. |
configSpec. postgresqlConfig_14. autovacuumAnalyzeScaleFactor |
number (double) Acceptable values are 0 to 1, inclusive. |
configSpec. postgresqlConfig_14. defaultTransactionReadOnly |
boolean (boolean) |
configSpec. postgresqlConfig_14. timezone |
string |
configSpec. postgresqlConfig_14. enableParallelAppend |
boolean (boolean) |
configSpec. postgresqlConfig_14. enableParallelHash |
boolean (boolean) |
configSpec. postgresqlConfig_14. enablePartitionPruning |
boolean (boolean) |
configSpec. postgresqlConfig_14. enablePartitionwiseAggregate |
boolean (boolean) |
configSpec. postgresqlConfig_14. enablePartitionwiseJoin |
boolean (boolean) |
configSpec. postgresqlConfig_14. jit |
boolean (boolean) |
configSpec. postgresqlConfig_14. maxParallelMaintenanceWorkers |
integer (int64) The minimum value is 0. |
configSpec. postgresqlConfig_14. parallelLeaderParticipation |
boolean (boolean) |
configSpec. postgresqlConfig_14. logTransactionSampleRate |
number (double) Acceptable values are 0 to 1, inclusive. |
configSpec. postgresqlConfig_14. planCacheMode |
string |
configSpec. postgresqlConfig_14. effectiveIoConcurrency |
integer (int64) Acceptable values are 0 to 1000, inclusive. |
configSpec. postgresqlConfig_14. effectiveCacheSize |
integer (int64) Acceptable values are 0 to 549755813888, inclusive. |
configSpec. postgresqlConfig_14. sharedPreloadLibraries[] |
string |
configSpec. postgresqlConfig_14. autoExplainLogMinDuration |
integer (int64) Acceptable values are -1 to 2147483647, inclusive. |
configSpec. postgresqlConfig_14. autoExplainLogAnalyze |
boolean (boolean) |
configSpec. postgresqlConfig_14. autoExplainLogBuffers |
boolean (boolean) |
configSpec. postgresqlConfig_14. autoExplainLogTiming |
boolean (boolean) |
configSpec. postgresqlConfig_14. autoExplainLogTriggers |
boolean (boolean) |
configSpec. postgresqlConfig_14. autoExplainLogVerbose |
boolean (boolean) |
configSpec. postgresqlConfig_14. autoExplainLogNestedStatements |
boolean (boolean) |
configSpec. postgresqlConfig_14. autoExplainSampleRate |
number (double) Acceptable values are 0 to 1, inclusive. |
configSpec. postgresqlConfig_14. pgHintPlanEnableHint |
boolean (boolean) |
configSpec. postgresqlConfig_14. pgHintPlanEnableHintTable |
boolean (boolean) |
configSpec. postgresqlConfig_14. pgHintPlanDebugPrint |
string |
configSpec. postgresqlConfig_14. pgHintPlanMessageLevel |
string |
configSpec. postgresqlConfig_14. hashMemMultiplier |
number (double) Acceptable values are 0 to 1000, inclusive. |
configSpec. postgresqlConfig_14. logicalDecodingWorkMem |
integer (int64) Acceptable values are 65536 to 1099511627776, inclusive. |
configSpec. postgresqlConfig_14. maintenanceIoConcurrency |
integer (int64) Acceptable values are 0 to 1000, inclusive. |
configSpec. postgresqlConfig_14. maxSlotWalKeepSize |
integer (int64) Acceptable values are -1 to 2251799812636672, inclusive. |
configSpec. postgresqlConfig_14. walKeepSize |
integer (int64) Acceptable values are -1 to 2251799812636672, inclusive. |
configSpec. postgresqlConfig_14. enableIncrementalSort |
boolean (boolean) |
configSpec. postgresqlConfig_14. autovacuumVacuumInsertThreshold |
integer (int64) Acceptable values are -1 to 2147483647, inclusive. |
configSpec. postgresqlConfig_14. autovacuumVacuumInsertScaleFactor |
number (double) Acceptable values are 0 to 100, inclusive. |
configSpec. postgresqlConfig_14. logMinDurationSample |
integer (int64) Acceptable values are -1 to 2147483647, inclusive. |
configSpec. postgresqlConfig_14. logStatementSampleRate |
number (double) Acceptable values are 0 to 1, inclusive. |
configSpec. postgresqlConfig_14. logParameterMaxLength |
integer (int64) Acceptable values are -1 to 2147483647, inclusive. |
configSpec. postgresqlConfig_14. logParameterMaxLengthOnError |
integer (int64) Acceptable values are -1 to 2147483647, inclusive. |
configSpec. postgresqlConfig_14. clientConnectionCheckInterval |
integer (int64) Acceptable values are -1 to 2147483647, inclusive. |
configSpec. postgresqlConfig_14. enableAsyncAppend |
boolean (boolean) |
configSpec. postgresqlConfig_14. enableGathermerge |
boolean (boolean) |
configSpec. postgresqlConfig_14. enableMemoize |
boolean (boolean) |
configSpec. postgresqlConfig_14. logRecoveryConflictWaits |
boolean (boolean) |
configSpec. postgresqlConfig_14. vacuumFailsafeAge |
integer (int64) Acceptable values are -1 to 2147483647, inclusive. |
configSpec. postgresqlConfig_14. vacuumMultixactFailsafeAge |
integer (int64) Acceptable values are -1 to 2147483647, inclusive. |
configSpec. postgresqlConfig_14. pgQualstatsEnabled |
boolean (boolean) |
configSpec. postgresqlConfig_14. pgQualstatsTrackConstants |
boolean (boolean) |
configSpec. postgresqlConfig_14. pgQualstatsMax |
integer (int64) |
configSpec. postgresqlConfig_14. pgQualstatsResolveOids |
boolean (boolean) |
configSpec. postgresqlConfig_14. pgQualstatsSampleRate |
number (double) |
configSpec. postgresqlConfig_14. maxStackDepth |
integer (int64) Acceptable values are 65536 to 134217728, inclusive. |
configSpec. postgresqlConfig_14. geqo |
boolean (boolean) |
configSpec. postgresqlConfig_14. geqoThreshold |
integer (int64) Acceptable values are 2 to 2147483647, inclusive. |
configSpec. postgresqlConfig_14. geqoEffort |
integer (int64) Acceptable values are 1 to 10, inclusive. |
configSpec. postgresqlConfig_14. geqoPoolSize |
integer (int64) |
configSpec. postgresqlConfig_14. geqoGenerations |
integer (int64) |
configSpec. postgresqlConfig_14. geqoSelectionBias |
number (double) Acceptable values are 1.5 to 2, inclusive. |
configSpec. postgresqlConfig_14. geqoSeed |
number (double) Acceptable values are 0 to 1, inclusive. |
configSpec. postgresqlConfig_14. pgTrgmSimilarityThreshold |
number (double) Acceptable values are 0 to 1, inclusive. |
configSpec. postgresqlConfig_14. pgTrgmWordSimilarityThreshold |
number (double) Acceptable values are 0 to 1, inclusive. |
configSpec. postgresqlConfig_14. pgTrgmStrictWordSimilarityThreshold |
number (double) Acceptable values are 0 to 1, inclusive. |
configSpec. postgresqlConfig_14_1C |
object Configuration for a PostgreSQL 14 1C cluster. configSpec includes only one of the fields postgresqlConfig_9_6 , postgresqlConfig_10_1C , postgresqlConfig_10 , postgresqlConfig_11 , postgresqlConfig_11_1C , postgresqlConfig_12 , postgresqlConfig_12_1C , postgresqlConfig_13 , postgresqlConfig_13_1C , postgresqlConfig_14 , postgresqlConfig_14_1C , postgresqlConfig_15 , postgresqlConfig_15_1C |
configSpec. postgresqlConfig_14_1C. maxConnections |
integer (int64) |
configSpec. postgresqlConfig_14_1C. sharedBuffers |
integer (int64) |
configSpec. postgresqlConfig_14_1C. tempBuffers |
integer (int64) |
configSpec. postgresqlConfig_14_1C. maxPreparedTransactions |
integer (int64) |
configSpec. postgresqlConfig_14_1C. workMem |
integer (int64) |
configSpec. postgresqlConfig_14_1C. maintenanceWorkMem |
integer (int64) |
configSpec. postgresqlConfig_14_1C. autovacuumWorkMem |
integer (int64) |
configSpec. postgresqlConfig_14_1C. tempFileLimit |
integer (int64) |
configSpec. postgresqlConfig_14_1C. vacuumCostDelay |
integer (int64) |
configSpec. postgresqlConfig_14_1C. vacuumCostPageHit |
integer (int64) |
configSpec. postgresqlConfig_14_1C. vacuumCostPageMiss |
integer (int64) |
configSpec. postgresqlConfig_14_1C. vacuumCostPageDirty |
integer (int64) |
configSpec. postgresqlConfig_14_1C. vacuumCostLimit |
integer (int64) |
configSpec. postgresqlConfig_14_1C. bgwriterDelay |
integer (int64) Acceptable values are 10 to 10000, inclusive. |
configSpec. postgresqlConfig_14_1C. bgwriterLruMaxpages |
integer (int64) |
configSpec. postgresqlConfig_14_1C. bgwriterLruMultiplier |
number (double) |
configSpec. postgresqlConfig_14_1C. bgwriterFlushAfter |
integer (int64) Acceptable values are 0 to 2048, inclusive. |
configSpec. postgresqlConfig_14_1C. backendFlushAfter |
integer (int64) Acceptable values are 0 to 2048, inclusive. |
configSpec. postgresqlConfig_14_1C. oldSnapshotThreshold |
integer (int64) Acceptable values are -1 to 86400000, inclusive. |
configSpec. postgresqlConfig_14_1C. walLevel |
string |
configSpec. postgresqlConfig_14_1C. synchronousCommit |
string |
configSpec. postgresqlConfig_14_1C. checkpointTimeout |
integer (int64) Acceptable values are 30000 to 86400000, inclusive. |
configSpec. postgresqlConfig_14_1C. checkpointCompletionTarget |
number (double) |
configSpec. postgresqlConfig_14_1C. checkpointFlushAfter |
integer (int64) Acceptable values are 0 to 2048, inclusive. |
configSpec. postgresqlConfig_14_1C. maxWalSize |
integer (int64) |
configSpec. postgresqlConfig_14_1C. minWalSize |
integer (int64) |
configSpec. postgresqlConfig_14_1C. maxStandbyStreamingDelay |
integer (int64) |
configSpec. postgresqlConfig_14_1C. defaultStatisticsTarget |
integer (int64) |
configSpec. postgresqlConfig_14_1C. constraintExclusion |
string |
configSpec. postgresqlConfig_14_1C. cursorTupleFraction |
number (double) |
configSpec. postgresqlConfig_14_1C. fromCollapseLimit |
integer (int64) Acceptable values are 1 to 2147483647, inclusive. |
configSpec. postgresqlConfig_14_1C. joinCollapseLimit |
integer (int64) Acceptable values are 1 to 2147483647, inclusive. |
configSpec. postgresqlConfig_14_1C. forceParallelMode |
string |
configSpec. postgresqlConfig_14_1C. clientMinMessages |
string |
configSpec. postgresqlConfig_14_1C. logMinMessages |
string |
configSpec. postgresqlConfig_14_1C. logMinErrorStatement |
string |
configSpec. postgresqlConfig_14_1C. logMinDurationStatement |
integer (int64) |
configSpec. postgresqlConfig_14_1C. logCheckpoints |
boolean (boolean) |
configSpec. postgresqlConfig_14_1C. logConnections |
boolean (boolean) |
configSpec. postgresqlConfig_14_1C. logDisconnections |
boolean (boolean) |
configSpec. postgresqlConfig_14_1C. logDuration |
boolean (boolean) |
configSpec. postgresqlConfig_14_1C. logErrorVerbosity |
string |
configSpec. postgresqlConfig_14_1C. logLockWaits |
boolean (boolean) |
configSpec. postgresqlConfig_14_1C. logStatement |
string |
configSpec. postgresqlConfig_14_1C. logTempFiles |
integer (int64) |
configSpec. postgresqlConfig_14_1C. searchPath |
string |
configSpec. postgresqlConfig_14_1C. rowSecurity |
boolean (boolean) |
configSpec. postgresqlConfig_14_1C. defaultTransactionIsolation |
string |
configSpec. postgresqlConfig_14_1C. statementTimeout |
integer (int64) |
configSpec. postgresqlConfig_14_1C. lockTimeout |
integer (int64) |
configSpec. postgresqlConfig_14_1C. idleInTransactionSessionTimeout |
integer (int64) |
configSpec. postgresqlConfig_14_1C. byteaOutput |
string |
configSpec. postgresqlConfig_14_1C. xmlbinary |
string |
configSpec. postgresqlConfig_14_1C. xmloption |
string |
configSpec. postgresqlConfig_14_1C. ginPendingListLimit |
integer (int64) |
configSpec. postgresqlConfig_14_1C. deadlockTimeout |
integer (int64) |
configSpec. postgresqlConfig_14_1C. maxLocksPerTransaction |
integer (int64) |
configSpec. postgresqlConfig_14_1C. maxPredLocksPerTransaction |
integer (int64) |
configSpec. postgresqlConfig_14_1C. arrayNulls |
boolean (boolean) |
configSpec. postgresqlConfig_14_1C. backslashQuote |
string |
configSpec. postgresqlConfig_14_1C. defaultWithOids |
boolean (boolean) |
configSpec. postgresqlConfig_14_1C. escapeStringWarning |
boolean (boolean) |
configSpec. postgresqlConfig_14_1C. loCompatPrivileges |
boolean (boolean) |
configSpec. postgresqlConfig_14_1C. quoteAllIdentifiers |
boolean (boolean) |
configSpec. postgresqlConfig_14_1C. standardConformingStrings |
boolean (boolean) |
configSpec. postgresqlConfig_14_1C. synchronizeSeqscans |
boolean (boolean) |
configSpec. postgresqlConfig_14_1C. transformNullEquals |
boolean (boolean) |
configSpec. postgresqlConfig_14_1C. exitOnError |
boolean (boolean) |
configSpec. postgresqlConfig_14_1C. seqPageCost |
number (double) |
configSpec. postgresqlConfig_14_1C. randomPageCost |
number (double) |
configSpec. postgresqlConfig_14_1C. autovacuumMaxWorkers |
integer (int64) Acceptable values are 1 to 32, inclusive. |
configSpec. postgresqlConfig_14_1C. autovacuumVacuumCostDelay |
integer (int64) Acceptable values are -1 to 100, inclusive. |
configSpec. postgresqlConfig_14_1C. autovacuumVacuumCostLimit |
integer (int64) Acceptable values are -1 to 10000, inclusive. |
configSpec. postgresqlConfig_14_1C. autovacuumNaptime |
integer (int64) Acceptable values are 1000 to 86400000, inclusive. |
configSpec. postgresqlConfig_14_1C. archiveTimeout |
integer (int64) Acceptable values are 10000 to 86400000, inclusive. |
configSpec. postgresqlConfig_14_1C. trackActivityQuerySize |
integer (int64) Acceptable values are 100 to 102400, inclusive. |
configSpec. postgresqlConfig_14_1C. onlineAnalyzeEnable |
boolean (boolean) |
configSpec. postgresqlConfig_14_1C. enableBitmapscan |
boolean (boolean) |
configSpec. postgresqlConfig_14_1C. enableHashagg |
boolean (boolean) |
configSpec. postgresqlConfig_14_1C. enableHashjoin |
boolean (boolean) |
configSpec. postgresqlConfig_14_1C. enableIndexscan |
boolean (boolean) |
configSpec. postgresqlConfig_14_1C. enableIndexonlyscan |
boolean (boolean) |
configSpec. postgresqlConfig_14_1C. enableMaterial |
boolean (boolean) |
configSpec. postgresqlConfig_14_1C. enableMergejoin |
boolean (boolean) |
configSpec. postgresqlConfig_14_1C. enableNestloop |
boolean (boolean) |
configSpec. postgresqlConfig_14_1C. enableSeqscan |
boolean (boolean) |
configSpec. postgresqlConfig_14_1C. enableSort |
boolean (boolean) |
configSpec. postgresqlConfig_14_1C. enableTidscan |
boolean (boolean) |
configSpec. postgresqlConfig_14_1C. maxWorkerProcesses |
integer (int64) Acceptable values are 0 to 1024, inclusive. |
configSpec. postgresqlConfig_14_1C. maxParallelWorkers |
integer (int64) Acceptable values are 0 to 1024, inclusive. |
configSpec. postgresqlConfig_14_1C. maxParallelWorkersPerGather |
integer (int64) Acceptable values are 0 to 1024, inclusive. |
configSpec. postgresqlConfig_14_1C. autovacuumVacuumScaleFactor |
number (double) Acceptable values are 0 to 1, inclusive. |
configSpec. postgresqlConfig_14_1C. autovacuumAnalyzeScaleFactor |
number (double) Acceptable values are 0 to 1, inclusive. |
configSpec. postgresqlConfig_14_1C. defaultTransactionReadOnly |
boolean (boolean) |
configSpec. postgresqlConfig_14_1C. timezone |
string |
configSpec. postgresqlConfig_14_1C. enableParallelAppend |
boolean (boolean) |
configSpec. postgresqlConfig_14_1C. enableParallelHash |
boolean (boolean) |
configSpec. postgresqlConfig_14_1C. enablePartitionPruning |
boolean (boolean) |
configSpec. postgresqlConfig_14_1C. enablePartitionwiseAggregate |
boolean (boolean) |
configSpec. postgresqlConfig_14_1C. enablePartitionwiseJoin |
boolean (boolean) |
configSpec. postgresqlConfig_14_1C. jit |
boolean (boolean) |
configSpec. postgresqlConfig_14_1C. maxParallelMaintenanceWorkers |
integer (int64) The minimum value is 0. |
configSpec. postgresqlConfig_14_1C. parallelLeaderParticipation |
boolean (boolean) |
configSpec. postgresqlConfig_14_1C. logTransactionSampleRate |
number (double) Acceptable values are 0 to 1, inclusive. |
configSpec. postgresqlConfig_14_1C. planCacheMode |
string |
configSpec. postgresqlConfig_14_1C. effectiveIoConcurrency |
integer (int64) Acceptable values are 0 to 1000, inclusive. |
configSpec. postgresqlConfig_14_1C. effectiveCacheSize |
integer (int64) Acceptable values are 0 to 549755813888, inclusive. |
configSpec. postgresqlConfig_14_1C. sharedPreloadLibraries[] |
string |
configSpec. postgresqlConfig_14_1C. autoExplainLogMinDuration |
integer (int64) Acceptable values are -1 to 2147483647, inclusive. |
configSpec. postgresqlConfig_14_1C. autoExplainLogAnalyze |
boolean (boolean) |
configSpec. postgresqlConfig_14_1C. autoExplainLogBuffers |
boolean (boolean) |
configSpec. postgresqlConfig_14_1C. autoExplainLogTiming |
boolean (boolean) |
configSpec. postgresqlConfig_14_1C. autoExplainLogTriggers |
boolean (boolean) |
configSpec. postgresqlConfig_14_1C. autoExplainLogVerbose |
boolean (boolean) |
configSpec. postgresqlConfig_14_1C. autoExplainLogNestedStatements |
boolean (boolean) |
configSpec. postgresqlConfig_14_1C. autoExplainSampleRate |
number (double) Acceptable values are 0 to 1, inclusive. |
configSpec. postgresqlConfig_14_1C. pgHintPlanEnableHint |
boolean (boolean) |
configSpec. postgresqlConfig_14_1C. pgHintPlanEnableHintTable |
boolean (boolean) |
configSpec. postgresqlConfig_14_1C. pgHintPlanDebugPrint |
string |
configSpec. postgresqlConfig_14_1C. pgHintPlanMessageLevel |
string |
configSpec. postgresqlConfig_14_1C. hashMemMultiplier |
number (double) Acceptable values are 0 to 1000, inclusive. |
configSpec. postgresqlConfig_14_1C. logicalDecodingWorkMem |
integer (int64) Acceptable values are 65536 to 1099511627776, inclusive. |
configSpec. postgresqlConfig_14_1C. maintenanceIoConcurrency |
integer (int64) Acceptable values are 0 to 1000, inclusive. |
configSpec. postgresqlConfig_14_1C. maxSlotWalKeepSize |
integer (int64) Acceptable values are -1 to 2251799812636672, inclusive. |
configSpec. postgresqlConfig_14_1C. walKeepSize |
integer (int64) Acceptable values are -1 to 2251799812636672, inclusive. |
configSpec. postgresqlConfig_14_1C. enableIncrementalSort |
boolean (boolean) |
configSpec. postgresqlConfig_14_1C. autovacuumVacuumInsertThreshold |
integer (int64) Acceptable values are -1 to 2147483647, inclusive. |
configSpec. postgresqlConfig_14_1C. autovacuumVacuumInsertScaleFactor |
number (double) Acceptable values are 0 to 100, inclusive. |
configSpec. postgresqlConfig_14_1C. logMinDurationSample |
integer (int64) Acceptable values are -1 to 2147483647, inclusive. |
configSpec. postgresqlConfig_14_1C. logStatementSampleRate |
number (double) Acceptable values are 0 to 1, inclusive. |
configSpec. postgresqlConfig_14_1C. logParameterMaxLength |
integer (int64) Acceptable values are -1 to 2147483647, inclusive. |
configSpec. postgresqlConfig_14_1C. logParameterMaxLengthOnError |
integer (int64) Acceptable values are -1 to 2147483647, inclusive. |
configSpec. postgresqlConfig_14_1C. clientConnectionCheckInterval |
integer (int64) Acceptable values are -1 to 2147483647, inclusive. |
configSpec. postgresqlConfig_14_1C. enableAsyncAppend |
boolean (boolean) |
configSpec. postgresqlConfig_14_1C. enableGathermerge |
boolean (boolean) |
configSpec. postgresqlConfig_14_1C. enableMemoize |
boolean (boolean) |
configSpec. postgresqlConfig_14_1C. logRecoveryConflictWaits |
boolean (boolean) |
configSpec. postgresqlConfig_14_1C. vacuumFailsafeAge |
integer (int64) Acceptable values are -1 to 2147483647, inclusive. |
configSpec. postgresqlConfig_14_1C. vacuumMultixactFailsafeAge |
integer (int64) Acceptable values are -1 to 2147483647, inclusive. |
configSpec. postgresqlConfig_14_1C. pgQualstatsEnabled |
boolean (boolean) |
configSpec. postgresqlConfig_14_1C. pgQualstatsTrackConstants |
boolean (boolean) |
configSpec. postgresqlConfig_14_1C. pgQualstatsMax |
integer (int64) |
configSpec. postgresqlConfig_14_1C. pgQualstatsResolveOids |
boolean (boolean) |
configSpec. postgresqlConfig_14_1C. pgQualstatsSampleRate |
number (double) |
configSpec. postgresqlConfig_14_1C. plantunerFixEmptyTable |
boolean (boolean) |
configSpec. postgresqlConfig_14_1C. geqo |
boolean (boolean) |
configSpec. postgresqlConfig_14_1C. geqoThreshold |
integer (int64) Acceptable values are 2 to 2147483647, inclusive. |
configSpec. postgresqlConfig_14_1C. geqoEffort |
integer (int64) Acceptable values are 1 to 10, inclusive. |
configSpec. postgresqlConfig_14_1C. geqoPoolSize |
integer (int64) |
configSpec. postgresqlConfig_14_1C. geqoGenerations |
integer (int64) |
configSpec. postgresqlConfig_14_1C. geqoSelectionBias |
number (double) Acceptable values are 1.5 to 2, inclusive. |
configSpec. postgresqlConfig_14_1C. geqoSeed |
number (double) Acceptable values are 0 to 1, inclusive. |
configSpec. postgresqlConfig_14_1C. pgTrgmSimilarityThreshold |
number (double) Acceptable values are 0 to 1, inclusive. |
configSpec. postgresqlConfig_14_1C. pgTrgmWordSimilarityThreshold |
number (double) Acceptable values are 0 to 1, inclusive. |
configSpec. postgresqlConfig_14_1C. pgTrgmStrictWordSimilarityThreshold |
number (double) Acceptable values are 0 to 1, inclusive. |
configSpec. postgresqlConfig_15 |
object Configuration for a PostgreSQL 15 cluster. configSpec includes only one of the fields postgresqlConfig_9_6 , postgresqlConfig_10_1C , postgresqlConfig_10 , postgresqlConfig_11 , postgresqlConfig_11_1C , postgresqlConfig_12 , postgresqlConfig_12_1C , postgresqlConfig_13 , postgresqlConfig_13_1C , postgresqlConfig_14 , postgresqlConfig_14_1C , postgresqlConfig_15 , postgresqlConfig_15_1C |
configSpec. postgresqlConfig_15. maxConnections |
integer (int64) |
configSpec. postgresqlConfig_15. sharedBuffers |
integer (int64) |
configSpec. postgresqlConfig_15. tempBuffers |
integer (int64) |
configSpec. postgresqlConfig_15. maxPreparedTransactions |
integer (int64) |
configSpec. postgresqlConfig_15. workMem |
integer (int64) |
configSpec. postgresqlConfig_15. maintenanceWorkMem |
integer (int64) |
configSpec. postgresqlConfig_15. autovacuumWorkMem |
integer (int64) |
configSpec. postgresqlConfig_15. tempFileLimit |
integer (int64) |
configSpec. postgresqlConfig_15. vacuumCostDelay |
integer (int64) |
configSpec. postgresqlConfig_15. vacuumCostPageHit |
integer (int64) |
configSpec. postgresqlConfig_15. vacuumCostPageMiss |
integer (int64) |
configSpec. postgresqlConfig_15. vacuumCostPageDirty |
integer (int64) |
configSpec. postgresqlConfig_15. vacuumCostLimit |
integer (int64) |
configSpec. postgresqlConfig_15. bgwriterDelay |
integer (int64) Acceptable values are 10 to 10000, inclusive. |
configSpec. postgresqlConfig_15. bgwriterLruMaxpages |
integer (int64) |
configSpec. postgresqlConfig_15. bgwriterLruMultiplier |
number (double) |
configSpec. postgresqlConfig_15. bgwriterFlushAfter |
integer (int64) Acceptable values are 0 to 2048, inclusive. |
configSpec. postgresqlConfig_15. backendFlushAfter |
integer (int64) Acceptable values are 0 to 2048, inclusive. |
configSpec. postgresqlConfig_15. oldSnapshotThreshold |
integer (int64) Acceptable values are -1 to 86400000, inclusive. |
configSpec. postgresqlConfig_15. walLevel |
string |
configSpec. postgresqlConfig_15. synchronousCommit |
string |
configSpec. postgresqlConfig_15. checkpointTimeout |
integer (int64) Acceptable values are 30000 to 86400000, inclusive. |
configSpec. postgresqlConfig_15. checkpointCompletionTarget |
number (double) |
configSpec. postgresqlConfig_15. checkpointFlushAfter |
integer (int64) Acceptable values are 0 to 2048, inclusive. |
configSpec. postgresqlConfig_15. maxWalSize |
integer (int64) |
configSpec. postgresqlConfig_15. minWalSize |
integer (int64) |
configSpec. postgresqlConfig_15. maxStandbyStreamingDelay |
integer (int64) |
configSpec. postgresqlConfig_15. defaultStatisticsTarget |
integer (int64) |
configSpec. postgresqlConfig_15. constraintExclusion |
string |
configSpec. postgresqlConfig_15. cursorTupleFraction |
number (double) |
configSpec. postgresqlConfig_15. fromCollapseLimit |
integer (int64) Acceptable values are 1 to 2147483647, inclusive. |
configSpec. postgresqlConfig_15. joinCollapseLimit |
integer (int64) Acceptable values are 1 to 2147483647, inclusive. |
configSpec. postgresqlConfig_15. forceParallelMode |
string |
configSpec. postgresqlConfig_15. clientMinMessages |
string |
configSpec. postgresqlConfig_15. logMinMessages |
string |
configSpec. postgresqlConfig_15. logMinErrorStatement |
string |
configSpec. postgresqlConfig_15. logMinDurationStatement |
integer (int64) |
configSpec. postgresqlConfig_15. logCheckpoints |
boolean (boolean) |
configSpec. postgresqlConfig_15. logConnections |
boolean (boolean) |
configSpec. postgresqlConfig_15. logDisconnections |
boolean (boolean) |
configSpec. postgresqlConfig_15. logDuration |
boolean (boolean) |
configSpec. postgresqlConfig_15. logErrorVerbosity |
string |
configSpec. postgresqlConfig_15. logLockWaits |
boolean (boolean) |
configSpec. postgresqlConfig_15. logStatement |
string |
configSpec. postgresqlConfig_15. logTempFiles |
integer (int64) |
configSpec. postgresqlConfig_15. searchPath |
string |
configSpec. postgresqlConfig_15. rowSecurity |
boolean (boolean) |
configSpec. postgresqlConfig_15. defaultTransactionIsolation |
string |
configSpec. postgresqlConfig_15. statementTimeout |
integer (int64) |
configSpec. postgresqlConfig_15. lockTimeout |
integer (int64) |
configSpec. postgresqlConfig_15. idleInTransactionSessionTimeout |
integer (int64) |
configSpec. postgresqlConfig_15. byteaOutput |
string |
configSpec. postgresqlConfig_15. xmlbinary |
string |
configSpec. postgresqlConfig_15. xmloption |
string |
configSpec. postgresqlConfig_15. ginPendingListLimit |
integer (int64) |
configSpec. postgresqlConfig_15. deadlockTimeout |
integer (int64) |
configSpec. postgresqlConfig_15. maxLocksPerTransaction |
integer (int64) |
configSpec. postgresqlConfig_15. maxPredLocksPerTransaction |
integer (int64) |
configSpec. postgresqlConfig_15. arrayNulls |
boolean (boolean) |
configSpec. postgresqlConfig_15. backslashQuote |
string |
configSpec. postgresqlConfig_15. defaultWithOids |
boolean (boolean) |
configSpec. postgresqlConfig_15. escapeStringWarning |
boolean (boolean) |
configSpec. postgresqlConfig_15. loCompatPrivileges |
boolean (boolean) |
configSpec. postgresqlConfig_15. quoteAllIdentifiers |
boolean (boolean) |
configSpec. postgresqlConfig_15. standardConformingStrings |
boolean (boolean) |
configSpec. postgresqlConfig_15. synchronizeSeqscans |
boolean (boolean) |
configSpec. postgresqlConfig_15. transformNullEquals |
boolean (boolean) |
configSpec. postgresqlConfig_15. exitOnError |
boolean (boolean) |
configSpec. postgresqlConfig_15. seqPageCost |
number (double) |
configSpec. postgresqlConfig_15. randomPageCost |
number (double) |
configSpec. postgresqlConfig_15. autovacuumMaxWorkers |
integer (int64) Acceptable values are 1 to 32, inclusive. |
configSpec. postgresqlConfig_15. autovacuumVacuumCostDelay |
integer (int64) Acceptable values are -1 to 100, inclusive. |
configSpec. postgresqlConfig_15. autovacuumVacuumCostLimit |
integer (int64) Acceptable values are -1 to 10000, inclusive. |
configSpec. postgresqlConfig_15. autovacuumNaptime |
integer (int64) Acceptable values are 1000 to 86400000, inclusive. |
configSpec. postgresqlConfig_15. archiveTimeout |
integer (int64) Acceptable values are 10000 to 86400000, inclusive. |
configSpec. postgresqlConfig_15. trackActivityQuerySize |
integer (int64) Acceptable values are 100 to 102400, inclusive. |
configSpec. postgresqlConfig_15. enableBitmapscan |
boolean (boolean) |
configSpec. postgresqlConfig_15. enableHashagg |
boolean (boolean) |
configSpec. postgresqlConfig_15. enableHashjoin |
boolean (boolean) |
configSpec. postgresqlConfig_15. enableIndexscan |
boolean (boolean) |
configSpec. postgresqlConfig_15. enableIndexonlyscan |
boolean (boolean) |
configSpec. postgresqlConfig_15. enableMaterial |
boolean (boolean) |
configSpec. postgresqlConfig_15. enableMergejoin |
boolean (boolean) |
configSpec. postgresqlConfig_15. enableNestloop |
boolean (boolean) |
configSpec. postgresqlConfig_15. enableSeqscan |
boolean (boolean) |
configSpec. postgresqlConfig_15. enableSort |
boolean (boolean) |
configSpec. postgresqlConfig_15. enableTidscan |
boolean (boolean) |
configSpec. postgresqlConfig_15. maxWorkerProcesses |
integer (int64) Acceptable values are 0 to 1024, inclusive. |
configSpec. postgresqlConfig_15. maxParallelWorkers |
integer (int64) Acceptable values are 0 to 1024, inclusive. |
configSpec. postgresqlConfig_15. maxParallelWorkersPerGather |
integer (int64) Acceptable values are 0 to 1024, inclusive. |
configSpec. postgresqlConfig_15. autovacuumVacuumScaleFactor |
number (double) Acceptable values are 0 to 1, inclusive. |
configSpec. postgresqlConfig_15. autovacuumAnalyzeScaleFactor |
number (double) Acceptable values are 0 to 1, inclusive. |
configSpec. postgresqlConfig_15. defaultTransactionReadOnly |
boolean (boolean) |
configSpec. postgresqlConfig_15. timezone |
string |
configSpec. postgresqlConfig_15. enableParallelAppend |
boolean (boolean) |
configSpec. postgresqlConfig_15. enableParallelHash |
boolean (boolean) |
configSpec. postgresqlConfig_15. enablePartitionPruning |
boolean (boolean) |
configSpec. postgresqlConfig_15. enablePartitionwiseAggregate |
boolean (boolean) |
configSpec. postgresqlConfig_15. enablePartitionwiseJoin |
boolean (boolean) |
configSpec. postgresqlConfig_15. jit |
boolean (boolean) |
configSpec. postgresqlConfig_15. maxParallelMaintenanceWorkers |
integer (int64) The minimum value is 0. |
configSpec. postgresqlConfig_15. parallelLeaderParticipation |
boolean (boolean) |
configSpec. postgresqlConfig_15. logTransactionSampleRate |
number (double) Acceptable values are 0 to 1, inclusive. |
configSpec. postgresqlConfig_15. planCacheMode |
string |
configSpec. postgresqlConfig_15. effectiveIoConcurrency |
integer (int64) Acceptable values are 0 to 1000, inclusive. |
configSpec. postgresqlConfig_15. effectiveCacheSize |
integer (int64) Acceptable values are 0 to 549755813888, inclusive. |
configSpec. postgresqlConfig_15. sharedPreloadLibraries[] |
string |
configSpec. postgresqlConfig_15. autoExplainLogMinDuration |
integer (int64) Acceptable values are -1 to 2147483647, inclusive. |
configSpec. postgresqlConfig_15. autoExplainLogAnalyze |
boolean (boolean) |
configSpec. postgresqlConfig_15. autoExplainLogBuffers |
boolean (boolean) |
configSpec. postgresqlConfig_15. autoExplainLogTiming |
boolean (boolean) |
configSpec. postgresqlConfig_15. autoExplainLogTriggers |
boolean (boolean) |
configSpec. postgresqlConfig_15. autoExplainLogVerbose |
boolean (boolean) |
configSpec. postgresqlConfig_15. autoExplainLogNestedStatements |
boolean (boolean) |
configSpec. postgresqlConfig_15. autoExplainSampleRate |
number (double) Acceptable values are 0 to 1, inclusive. |
configSpec. postgresqlConfig_15. pgHintPlanEnableHint |
boolean (boolean) |
configSpec. postgresqlConfig_15. pgHintPlanEnableHintTable |
boolean (boolean) |
configSpec. postgresqlConfig_15. pgHintPlanDebugPrint |
string |
configSpec. postgresqlConfig_15. pgHintPlanMessageLevel |
string |
configSpec. postgresqlConfig_15. hashMemMultiplier |
number (double) Acceptable values are 0 to 1000, inclusive. |
configSpec. postgresqlConfig_15. logicalDecodingWorkMem |
integer (int64) Acceptable values are 65536 to 1099511627776, inclusive. |
configSpec. postgresqlConfig_15. maintenanceIoConcurrency |
integer (int64) Acceptable values are 0 to 1000, inclusive. |
configSpec. postgresqlConfig_15. maxSlotWalKeepSize |
integer (int64) Acceptable values are -1 to 2251799812636672, inclusive. |
configSpec. postgresqlConfig_15. walKeepSize |
integer (int64) Acceptable values are -1 to 2251799812636672, inclusive. |
configSpec. postgresqlConfig_15. enableIncrementalSort |
boolean (boolean) |
configSpec. postgresqlConfig_15. autovacuumVacuumInsertThreshold |
integer (int64) Acceptable values are -1 to 2147483647, inclusive. |
configSpec. postgresqlConfig_15. autovacuumVacuumInsertScaleFactor |
number (double) Acceptable values are 0 to 100, inclusive. |
configSpec. postgresqlConfig_15. logMinDurationSample |
integer (int64) Acceptable values are -1 to 2147483647, inclusive. |
configSpec. postgresqlConfig_15. logStatementSampleRate |
number (double) Acceptable values are 0 to 1, inclusive. |
configSpec. postgresqlConfig_15. logParameterMaxLength |
integer (int64) Acceptable values are -1 to 2147483647, inclusive. |
configSpec. postgresqlConfig_15. logParameterMaxLengthOnError |
integer (int64) Acceptable values are -1 to 2147483647, inclusive. |
configSpec. postgresqlConfig_15. clientConnectionCheckInterval |
integer (int64) Acceptable values are -1 to 2147483647, inclusive. |
configSpec. postgresqlConfig_15. enableAsyncAppend |
boolean (boolean) |
configSpec. postgresqlConfig_15. enableGathermerge |
boolean (boolean) |
configSpec. postgresqlConfig_15. enableMemoize |
boolean (boolean) |
configSpec. postgresqlConfig_15. logRecoveryConflictWaits |
boolean (boolean) |
configSpec. postgresqlConfig_15. vacuumFailsafeAge |
integer (int64) Acceptable values are -1 to 2147483647, inclusive. |
configSpec. postgresqlConfig_15. vacuumMultixactFailsafeAge |
integer (int64) Acceptable values are -1 to 2147483647, inclusive. |
configSpec. postgresqlConfig_15. pgQualstatsEnabled |
boolean (boolean) |
configSpec. postgresqlConfig_15. pgQualstatsTrackConstants |
boolean (boolean) |
configSpec. postgresqlConfig_15. pgQualstatsMax |
integer (int64) |
configSpec. postgresqlConfig_15. pgQualstatsResolveOids |
boolean (boolean) |
configSpec. postgresqlConfig_15. pgQualstatsSampleRate |
number (double) |
configSpec. postgresqlConfig_15. maxStackDepth |
integer (int64) Acceptable values are 65536 to 134217728, inclusive. |
configSpec. postgresqlConfig_15. enableGroupByReordering |
boolean (boolean) |
configSpec. postgresqlConfig_15. pgTrgmSimilarityThreshold |
number (double) Acceptable values are 0 to 1, inclusive. |
configSpec. postgresqlConfig_15. pgTrgmWordSimilarityThreshold |
number (double) Acceptable values are 0 to 1, inclusive. |
configSpec. postgresqlConfig_15. pgTrgmStrictWordSimilarityThreshold |
number (double) Acceptable values are 0 to 1, inclusive. |
configSpec. postgresqlConfig_15_1C |
object Configuration for a PostgreSQL 15 1C cluster. configSpec includes only one of the fields postgresqlConfig_9_6 , postgresqlConfig_10_1C , postgresqlConfig_10 , postgresqlConfig_11 , postgresqlConfig_11_1C , postgresqlConfig_12 , postgresqlConfig_12_1C , postgresqlConfig_13 , postgresqlConfig_13_1C , postgresqlConfig_14 , postgresqlConfig_14_1C , postgresqlConfig_15 , postgresqlConfig_15_1C |
configSpec. postgresqlConfig_15_1C. maxConnections |
integer (int64) |
configSpec. postgresqlConfig_15_1C. sharedBuffers |
integer (int64) |
configSpec. postgresqlConfig_15_1C. tempBuffers |
integer (int64) |
configSpec. postgresqlConfig_15_1C. maxPreparedTransactions |
integer (int64) |
configSpec. postgresqlConfig_15_1C. workMem |
integer (int64) |
configSpec. postgresqlConfig_15_1C. maintenanceWorkMem |
integer (int64) |
configSpec. postgresqlConfig_15_1C. autovacuumWorkMem |
integer (int64) |
configSpec. postgresqlConfig_15_1C. tempFileLimit |
integer (int64) |
configSpec. postgresqlConfig_15_1C. vacuumCostDelay |
integer (int64) |
configSpec. postgresqlConfig_15_1C. vacuumCostPageHit |
integer (int64) |
configSpec. postgresqlConfig_15_1C. vacuumCostPageMiss |
integer (int64) |
configSpec. postgresqlConfig_15_1C. vacuumCostPageDirty |
integer (int64) |
configSpec. postgresqlConfig_15_1C. vacuumCostLimit |
integer (int64) |
configSpec. postgresqlConfig_15_1C. bgwriterDelay |
integer (int64) Acceptable values are 10 to 10000, inclusive. |
configSpec. postgresqlConfig_15_1C. bgwriterLruMaxpages |
integer (int64) |
configSpec. postgresqlConfig_15_1C. bgwriterLruMultiplier |
number (double) |
configSpec. postgresqlConfig_15_1C. bgwriterFlushAfter |
integer (int64) Acceptable values are 0 to 2048, inclusive. |
configSpec. postgresqlConfig_15_1C. backendFlushAfter |
integer (int64) Acceptable values are 0 to 2048, inclusive. |
configSpec. postgresqlConfig_15_1C. oldSnapshotThreshold |
integer (int64) Acceptable values are -1 to 86400000, inclusive. |
configSpec. postgresqlConfig_15_1C. walLevel |
string |
configSpec. postgresqlConfig_15_1C. synchronousCommit |
string |
configSpec. postgresqlConfig_15_1C. checkpointTimeout |
integer (int64) Acceptable values are 30000 to 86400000, inclusive. |
configSpec. postgresqlConfig_15_1C. checkpointCompletionTarget |
number (double) |
configSpec. postgresqlConfig_15_1C. checkpointFlushAfter |
integer (int64) Acceptable values are 0 to 2048, inclusive. |
configSpec. postgresqlConfig_15_1C. maxWalSize |
integer (int64) |
configSpec. postgresqlConfig_15_1C. minWalSize |
integer (int64) |
configSpec. postgresqlConfig_15_1C. maxStandbyStreamingDelay |
integer (int64) |
configSpec. postgresqlConfig_15_1C. defaultStatisticsTarget |
integer (int64) |
configSpec. postgresqlConfig_15_1C. constraintExclusion |
string |
configSpec. postgresqlConfig_15_1C. cursorTupleFraction |
number (double) |
configSpec. postgresqlConfig_15_1C. fromCollapseLimit |
integer (int64) Acceptable values are 1 to 2147483647, inclusive. |
configSpec. postgresqlConfig_15_1C. joinCollapseLimit |
integer (int64) Acceptable values are 1 to 2147483647, inclusive. |
configSpec. postgresqlConfig_15_1C. forceParallelMode |
string |
configSpec. postgresqlConfig_15_1C. clientMinMessages |
string |
configSpec. postgresqlConfig_15_1C. logMinMessages |
string |
configSpec. postgresqlConfig_15_1C. logMinErrorStatement |
string |
configSpec. postgresqlConfig_15_1C. logMinDurationStatement |
integer (int64) |
configSpec. postgresqlConfig_15_1C. logCheckpoints |
boolean (boolean) |
configSpec. postgresqlConfig_15_1C. logConnections |
boolean (boolean) |
configSpec. postgresqlConfig_15_1C. logDisconnections |
boolean (boolean) |
configSpec. postgresqlConfig_15_1C. logDuration |
boolean (boolean) |
configSpec. postgresqlConfig_15_1C. logErrorVerbosity |
string |
configSpec. postgresqlConfig_15_1C. logLockWaits |
boolean (boolean) |
configSpec. postgresqlConfig_15_1C. logStatement |
string |
configSpec. postgresqlConfig_15_1C. logTempFiles |
integer (int64) |
configSpec. postgresqlConfig_15_1C. searchPath |
string |
configSpec. postgresqlConfig_15_1C. rowSecurity |
boolean (boolean) |
configSpec. postgresqlConfig_15_1C. defaultTransactionIsolation |
string |
configSpec. postgresqlConfig_15_1C. statementTimeout |
integer (int64) |
configSpec. postgresqlConfig_15_1C. lockTimeout |
integer (int64) |
configSpec. postgresqlConfig_15_1C. idleInTransactionSessionTimeout |
integer (int64) |
configSpec. postgresqlConfig_15_1C. byteaOutput |
string |
configSpec. postgresqlConfig_15_1C. xmlbinary |
string |
configSpec. postgresqlConfig_15_1C. xmloption |
string |
configSpec. postgresqlConfig_15_1C. ginPendingListLimit |
integer (int64) |
configSpec. postgresqlConfig_15_1C. deadlockTimeout |
integer (int64) |
configSpec. postgresqlConfig_15_1C. maxLocksPerTransaction |
integer (int64) |
configSpec. postgresqlConfig_15_1C. maxPredLocksPerTransaction |
integer (int64) |
configSpec. postgresqlConfig_15_1C. arrayNulls |
boolean (boolean) |
configSpec. postgresqlConfig_15_1C. backslashQuote |
string |
configSpec. postgresqlConfig_15_1C. defaultWithOids |
boolean (boolean) |
configSpec. postgresqlConfig_15_1C. escapeStringWarning |
boolean (boolean) |
configSpec. postgresqlConfig_15_1C. loCompatPrivileges |
boolean (boolean) |
configSpec. postgresqlConfig_15_1C. quoteAllIdentifiers |
boolean (boolean) |
configSpec. postgresqlConfig_15_1C. standardConformingStrings |
boolean (boolean) |
configSpec. postgresqlConfig_15_1C. synchronizeSeqscans |
boolean (boolean) |
configSpec. postgresqlConfig_15_1C. transformNullEquals |
boolean (boolean) |
configSpec. postgresqlConfig_15_1C. exitOnError |
boolean (boolean) |
configSpec. postgresqlConfig_15_1C. seqPageCost |
number (double) |
configSpec. postgresqlConfig_15_1C. randomPageCost |
number (double) |
configSpec. postgresqlConfig_15_1C. autovacuumMaxWorkers |
integer (int64) Acceptable values are 1 to 32, inclusive. |
configSpec. postgresqlConfig_15_1C. autovacuumVacuumCostDelay |
integer (int64) Acceptable values are -1 to 100, inclusive. |
configSpec. postgresqlConfig_15_1C. autovacuumVacuumCostLimit |
integer (int64) Acceptable values are -1 to 10000, inclusive. |
configSpec. postgresqlConfig_15_1C. autovacuumNaptime |
integer (int64) Acceptable values are 1000 to 86400000, inclusive. |
configSpec. postgresqlConfig_15_1C. archiveTimeout |
integer (int64) Acceptable values are 10000 to 86400000, inclusive. |
configSpec. postgresqlConfig_15_1C. trackActivityQuerySize |
integer (int64) Acceptable values are 100 to 102400, inclusive. |
configSpec. postgresqlConfig_15_1C. onlineAnalyzeEnable |
boolean (boolean) |
configSpec. postgresqlConfig_15_1C. enableBitmapscan |
boolean (boolean) |
configSpec. postgresqlConfig_15_1C. enableHashagg |
boolean (boolean) |
configSpec. postgresqlConfig_15_1C. enableHashjoin |
boolean (boolean) |
configSpec. postgresqlConfig_15_1C. enableIndexscan |
boolean (boolean) |
configSpec. postgresqlConfig_15_1C. enableIndexonlyscan |
boolean (boolean) |
configSpec. postgresqlConfig_15_1C. enableMaterial |
boolean (boolean) |
configSpec. postgresqlConfig_15_1C. enableMergejoin |
boolean (boolean) |
configSpec. postgresqlConfig_15_1C. enableNestloop |
boolean (boolean) |
configSpec. postgresqlConfig_15_1C. enableSeqscan |
boolean (boolean) |
configSpec. postgresqlConfig_15_1C. enableSort |
boolean (boolean) |
configSpec. postgresqlConfig_15_1C. enableTidscan |
boolean (boolean) |
configSpec. postgresqlConfig_15_1C. maxWorkerProcesses |
integer (int64) Acceptable values are 0 to 1024, inclusive. |
configSpec. postgresqlConfig_15_1C. maxParallelWorkers |
integer (int64) Acceptable values are 0 to 1024, inclusive. |
configSpec. postgresqlConfig_15_1C. maxParallelWorkersPerGather |
integer (int64) Acceptable values are 0 to 1024, inclusive. |
configSpec. postgresqlConfig_15_1C. autovacuumVacuumScaleFactor |
number (double) Acceptable values are 0 to 1, inclusive. |
configSpec. postgresqlConfig_15_1C. autovacuumAnalyzeScaleFactor |
number (double) Acceptable values are 0 to 1, inclusive. |
configSpec. postgresqlConfig_15_1C. defaultTransactionReadOnly |
boolean (boolean) |
configSpec. postgresqlConfig_15_1C. timezone |
string |
configSpec. postgresqlConfig_15_1C. enableParallelAppend |
boolean (boolean) |
configSpec. postgresqlConfig_15_1C. enableParallelHash |
boolean (boolean) |
configSpec. postgresqlConfig_15_1C. enablePartitionPruning |
boolean (boolean) |
configSpec. postgresqlConfig_15_1C. enablePartitionwiseAggregate |
boolean (boolean) |
configSpec. postgresqlConfig_15_1C. enablePartitionwiseJoin |
boolean (boolean) |
configSpec. postgresqlConfig_15_1C. jit |
boolean (boolean) |
configSpec. postgresqlConfig_15_1C. maxParallelMaintenanceWorkers |
integer (int64) The minimum value is 0. |
configSpec. postgresqlConfig_15_1C. parallelLeaderParticipation |
boolean (boolean) |
configSpec. postgresqlConfig_15_1C. logTransactionSampleRate |
number (double) Acceptable values are 0 to 1, inclusive. |
configSpec. postgresqlConfig_15_1C. planCacheMode |
string |
configSpec. postgresqlConfig_15_1C. effectiveIoConcurrency |
integer (int64) Acceptable values are 0 to 1000, inclusive. |
configSpec. postgresqlConfig_15_1C. effectiveCacheSize |
integer (int64) Acceptable values are 0 to 549755813888, inclusive. |
configSpec. postgresqlConfig_15_1C. sharedPreloadLibraries[] |
string |
configSpec. postgresqlConfig_15_1C. autoExplainLogMinDuration |
integer (int64) Acceptable values are -1 to 2147483647, inclusive. |
configSpec. postgresqlConfig_15_1C. autoExplainLogAnalyze |
boolean (boolean) |
configSpec. postgresqlConfig_15_1C. autoExplainLogBuffers |
boolean (boolean) |
configSpec. postgresqlConfig_15_1C. autoExplainLogTiming |
boolean (boolean) |
configSpec. postgresqlConfig_15_1C. autoExplainLogTriggers |
boolean (boolean) |
configSpec. postgresqlConfig_15_1C. autoExplainLogVerbose |
boolean (boolean) |
configSpec. postgresqlConfig_15_1C. autoExplainLogNestedStatements |
boolean (boolean) |
configSpec. postgresqlConfig_15_1C. autoExplainSampleRate |
number (double) Acceptable values are 0 to 1, inclusive. |
configSpec. postgresqlConfig_15_1C. pgHintPlanEnableHint |
boolean (boolean) |
configSpec. postgresqlConfig_15_1C. pgHintPlanEnableHintTable |
boolean (boolean) |
configSpec. postgresqlConfig_15_1C. pgHintPlanDebugPrint |
string |
configSpec. postgresqlConfig_15_1C. pgHintPlanMessageLevel |
string |
configSpec. postgresqlConfig_15_1C. hashMemMultiplier |
number (double) Acceptable values are 0 to 1000, inclusive. |
configSpec. postgresqlConfig_15_1C. logicalDecodingWorkMem |
integer (int64) Acceptable values are 65536 to 1099511627776, inclusive. |
configSpec. postgresqlConfig_15_1C. maintenanceIoConcurrency |
integer (int64) Acceptable values are 0 to 1000, inclusive. |
configSpec. postgresqlConfig_15_1C. maxSlotWalKeepSize |
integer (int64) Acceptable values are -1 to 2251799812636672, inclusive. |
configSpec. postgresqlConfig_15_1C. walKeepSize |
integer (int64) Acceptable values are -1 to 2251799812636672, inclusive. |
configSpec. postgresqlConfig_15_1C. enableIncrementalSort |
boolean (boolean) |
configSpec. postgresqlConfig_15_1C. autovacuumVacuumInsertThreshold |
integer (int64) Acceptable values are -1 to 2147483647, inclusive. |
configSpec. postgresqlConfig_15_1C. autovacuumVacuumInsertScaleFactor |
number (double) Acceptable values are 0 to 100, inclusive. |
configSpec. postgresqlConfig_15_1C. logMinDurationSample |
integer (int64) Acceptable values are -1 to 2147483647, inclusive. |
configSpec. postgresqlConfig_15_1C. logStatementSampleRate |
number (double) Acceptable values are 0 to 1, inclusive. |
configSpec. postgresqlConfig_15_1C. logParameterMaxLength |
integer (int64) Acceptable values are -1 to 2147483647, inclusive. |
configSpec. postgresqlConfig_15_1C. logParameterMaxLengthOnError |
integer (int64) Acceptable values are -1 to 2147483647, inclusive. |
configSpec. postgresqlConfig_15_1C. clientConnectionCheckInterval |
integer (int64) Acceptable values are -1 to 2147483647, inclusive. |
configSpec. postgresqlConfig_15_1C. enableAsyncAppend |
boolean (boolean) |
configSpec. postgresqlConfig_15_1C. enableGathermerge |
boolean (boolean) |
configSpec. postgresqlConfig_15_1C. enableMemoize |
boolean (boolean) |
configSpec. postgresqlConfig_15_1C. logRecoveryConflictWaits |
boolean (boolean) |
configSpec. postgresqlConfig_15_1C. vacuumFailsafeAge |
integer (int64) Acceptable values are -1 to 2147483647, inclusive. |
configSpec. postgresqlConfig_15_1C. vacuumMultixactFailsafeAge |
integer (int64) Acceptable values are -1 to 2147483647, inclusive. |
configSpec. postgresqlConfig_15_1C. pgQualstatsEnabled |
boolean (boolean) |
configSpec. postgresqlConfig_15_1C. pgQualstatsTrackConstants |
boolean (boolean) |
configSpec. postgresqlConfig_15_1C. pgQualstatsMax |
integer (int64) |
configSpec. postgresqlConfig_15_1C. pgQualstatsResolveOids |
boolean (boolean) |
configSpec. postgresqlConfig_15_1C. pgQualstatsSampleRate |
number (double) |
configSpec. postgresqlConfig_15_1C. plantunerFixEmptyTable |
boolean (boolean) |
configSpec. postgresqlConfig_15_1C. geqo |
boolean (boolean) |
configSpec. postgresqlConfig_15_1C. geqoThreshold |
integer (int64) Acceptable values are 2 to 2147483647, inclusive. |
configSpec. postgresqlConfig_15_1C. geqoEffort |
integer (int64) Acceptable values are 1 to 10, inclusive. |
configSpec. postgresqlConfig_15_1C. geqoPoolSize |
integer (int64) |
configSpec. postgresqlConfig_15_1C. geqoGenerations |
integer (int64) |
configSpec. postgresqlConfig_15_1C. geqoSelectionBias |
number (double) Acceptable values are 1.5 to 2, inclusive. |
configSpec. postgresqlConfig_15_1C. geqoSeed |
number (double) Acceptable values are 0 to 1, inclusive. |
configSpec. postgresqlConfig_15_1C. pgTrgmSimilarityThreshold |
number (double) Acceptable values are 0 to 1, inclusive. |
configSpec. postgresqlConfig_15_1C. pgTrgmWordSimilarityThreshold |
number (double) Acceptable values are 0 to 1, inclusive. |
configSpec. postgresqlConfig_15_1C. pgTrgmStrictWordSimilarityThreshold |
number (double) Acceptable values are 0 to 1, inclusive. |
name | string New name for the cluster. The maximum string length in characters is 63. Value must match the regular expression |
maintenanceWindow | object New maintenance window settings for the cluster. A maintenance window settings. |
maintenanceWindow. anytime |
object Maintenance operation can be scheduled anytime. maintenanceWindow includes only one of the fields anytime , weeklyMaintenanceWindow |
maintenanceWindow. weeklyMaintenanceWindow |
object Maintenance operation can be scheduled on a weekly basis. maintenanceWindow includes only one of the fields anytime , weeklyMaintenanceWindow |
maintenanceWindow. weeklyMaintenanceWindow. day |
string Day of the week (in |
maintenanceWindow. weeklyMaintenanceWindow. hour |
string (int64) Hour of the day in UTC (in Acceptable values are 1 to 24, inclusive. |
securityGroupIds[] | string User security groups |
deletionProtection | boolean (boolean) Deletion Protection inhibits deletion of the cluster |
Response
HTTP Code: 200 - OK
{
"id": "string",
"description": "string",
"createdAt": "string",
"createdBy": "string",
"modifiedAt": "string",
"done": true,
"metadata": "object",
// includes only one of the fields `error`, `response`
"error": {
"code": "integer",
"message": "string",
"details": [
"object"
]
},
"response": "object",
// 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 | string (date-time) Creation timestamp. 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). |
createdBy | string ID of the user or service account who initiated the operation. |
modifiedAt | string (date-time) The time when the Operation resource was last modified. 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). |
done | boolean (boolean) If the value is |
metadata | object Service-specific metadata associated with the operation. It typically contains the ID of the target resource that the operation is performed on. Any method that returns a long-running operation should document the metadata type, if any. |
error | object The error result of the operation in case of failure or cancellation. includes only one of the fields error , response |
error. code |
integer (int32) Error code. An enum value of google.rpc.Code. |
error. message |
string An error message. |
error. details[] |
object A list of messages that carry the error details. |
response | object includes only one of the fields error , response The normal response of the operation in case of success. If the original method returns no data on success, such as Delete, the response is google.protobuf.Empty. If the original method is the standard Create/Update, the response should be the target resource of the operation. Any method that returns a long-running operation should document the response type, if any. |