Hi, maintenance_work_mem is commented in postgresql.conf #maintenance_work_mem = 64MB but the following query, select * from pg_settings where name = 'maintenance_work_mem'; returns the following. Does it means it is enabled? name | maintenance_work_mem setting | 65536 unit | kB category | Resource Usage / Memory short_desc | Sets the maximum memory to be used for maintenance operations. extra_desc | This includes operations such as VACUUM and CREATE INDEX. context | user vartype | integer source | default min_val | 1024 max_val | 2147483647 enumvals | boot_val | 65536 reset_val | 65536 sourcefile | sourceline | pending_restart | f ----- -- Thanks, Rajan. -- View this message in context: http://www.postgresql-archive.org/pg9-6-maintenance-work-mem-is-disabled-in-postgresql-conf-by-running-a-select-query-for-pg-settings-d-tp5968586.html Sent from the PostgreSQL - admin mailing list archive at Nabble.com. -- Sent via pgsql-admin mailing list (pgsql-admin@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-admin
