SuSE help


PGSQL_MAINTENANCE_WORK_MEM

The PGSQL_MAINTENANCE_WORK_MEM variable specifies the maximum amount of memory to be used in maintenance operations such as VACUUM.

Values

Integer (in MB)

Default

64

Comments

For most sites, CollabNet recommends that you set this to 256MB.

Related questions
What are the right PostgreSQL settings for my site?
More information
Full list of performance-related PosgreSQL parameters
PosgreSQL performance tips from the experts