maintenance_work_mem

A configuration parameter specifying the maximum amount of memory to be used by maintenance operations

maintenance_work_mem is a configuration parameter specifying the maximum amount of memory to be used by maintenance operations, such as vacuuming,  index creation, and adding constraints to tables.

maintenance_work_mem was added in PostgreSQL 8.0.

Default value

The default value for maintenance_work_mem is:

Change history

Categories

GUC configuration item, Memory

See also

work_mem, autovacuum_work_mem, max_parallel_maintenance_workers