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 value for
- PostgreSQL 9.4 and later:
- PostgreSQL 9.3 and earlier: