maintenance_work_mem

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

maintenance_work_mem is a GUC 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

Default value for maintenance_work_mem is:

  • PostgreSQL 9.4 and later: 64MB
  • PostgreSQL 9.3 and earlier: 16MB

Change history

Categories

GUC configuration item, Memory

See also

work_mem, autovacuum_work_mem