Re: pg9.6 - maintenance_work_mem is disabled in postgresql.conf by running a select query for pg_settings returns it is enabled

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(at)gmail(dot)com> 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(at)elevated-dev(dot)com
(303) 722-0567