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

Thanks all for replies. Now I understand.

On 25 Jun 2017 19:53, "Ashish Tiwari" <tashish786(at)gmail(dot)com> wrote:

> It's keep some memories default to perform system operations.
>
> Thanks.
>
> On Jun 25, 2017 6:58 PM, "rajan" <vgmonnet(at)gmail(dot)com> wrote:
>
>> Actually I did not make any changes to postgresql.conf
>>
>> When studying about this parameter I thought I should check what my
>> current
>> setting(for maintenance_work_mem) is and then I found that it is commented
>> in postgresql.conf while the pg_settings has the value enabled.
>>
>>
>>
>> -----
>> --
>> Thanks,
>> Rajan.
>> --
>> View this message in context: http://www.postgresql-archive.
>> org/pg9-6-maintenance-work-mem-is-disabled-in-postgresql-con
>> f-but-running-a-select-query-for-pg-settingsd-tp5968586p5968596.html
>> Sent from the PostgreSQL - admin mailing list archive at Nabble.com.
>>
>>
>> --
>> Sent via pgsql-admin mailing list (pgsql-admin(at)postgresql(dot)org)
>> To make changes to your subscription:
>> http://www.postgresql.org/mailpref/pgsql-admin
>>
>