Skip to main content

Settings

Below you can find the official schema (cue) and an example to configure your postgres database:

[postgres]
version = '14.6-20230925-1'

[postgres.resources.compute]
cpu = 1000
memory = 2048

[postgres.settings]
jit = "off"
maxConnections = 100
sharedBuffers = '256MB'
effectiveCacheSize = '768MB'
maintenanceWorkMem = '64MB'
checkpointCompletionTarget = 0.9
walBuffers = -1
defaultStatisticsTarget = 100
randomPageCost = 1.1
effectiveIOConcurrency = 200
workMem = '1310kB'
hugePages = 'off'
minWalSize = '80MB'
maxWalSize = '1GB'
maxWorkerProcesses = 8
maxParallelWorkersPerGather = 2
maxParallelWorkers = 8
maxParallelMaintenanceWorkers = 2
info

At the time of writing this document postgres settings are only supported via the configuration file.