Lines in postgresql.conf being commented out doesn't mean things are disabled, it means the default value is not overridden. > On Jun 25, 2017, at 1:53 AM, rajan <vgmonnet@xxxxxxxxx> wrote: > > 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 -- Scott Ribe scott_ribe@xxxxxxxxxxxxxxxx (303) 722-0567 -- Sent via pgsql-admin mailing list (pgsql-admin@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-admin
