Re: [ADMIN] pg9.6 - maintenance_work_mem is disabled inpostgresql.conf by running a select query for pg_settings returns it isenabled

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  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@elevated-dev.com
(303) 722-0567