PostgreSQL working memory

The work_mem setting specifies the maximum amount of memory used for queries before writing to temporary files.

Console node group

PE Database

Parameter

puppet_enterprise::profile::database::work_mem

Default value

Based on the following calculation:

(Available RAM / 1024 / 8) + 0.5

The minimum is 4 MB, and the maximum is 16 MB.

Accepted values

An integer representing a number of MB