Settings

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

schema

#Postgres: {
    version: string | *"14.6-20230705-1"

    // Resources for the service, optional
    resources?: #Resources & {
        replicas: 1
    }

    // postgres settings of the same name in camelCase, optional
    settings?: {
        jit:                           "off" | "on" | *"on"
        maxConnections:                int32 | *100
        sharedBuffers:                 string | *"128MB"
        effectiveCacheSize:            string | *"4GB"
        maintenanceWorkMem:            string | *"64MB"
        checkpointCompletionTarget:    number | *0.9
        walBuffers:                    int32 | *-1
        defaultStatisticsTarget:       int32 | *100
        randomPageCost:                number | *4.0
        effectiveIOConcurrency:        int32 | *1
        workMem:                       string | *"4MB"
        hugePages:                     string | *"try"
        minWalSize:                    string | *"80MB"
        maxWalSize:                    string | *"1GB"
        maxWorkerProcesses:            int32 | *8
        maxParallelWorkersPerGather:   int32 | *2
        maxParallelWorkers:            int32 | *8
        maxParallelMaintenanceWorkers: int32 | *2
    }
}

toml

[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.