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

From: Ashish Tiwari <tashish786(at)gmail(dot)com>
To: Muthiah Rajan <vgmonnet(at)gmail(dot)com>
Cc: pgsql-admin(at)postgresql(dot)org
Subject: Re: Re: pg9.6 - maintenance_work_mem is disabled in postgresql.conf by running a select query for pg_settings returns it is enabled
Date: 2017-06-25 14:40:21
Message-ID: CAH8UkmE50Y1CC_y=SwUbCJ0Hph5+4QbQ4s_kp+0rw+s47AdmOg@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

You're welcome!

On Jun 25, 2017 8:06 PM, "Muthiah Rajan" <vgmonnet(at)gmail(dot)com> wrote:

> 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
>>>
>>

In response to

Browse pgsql-admin by date

  From Date Subject
Next Message Jerry Sievers 2017-06-26 15:39:42 Restart time indication in cases of postmaster initiated all backend restart
Previous Message Muthiah Rajan 2017-06-25 14:36:01 Re: Re: pg9.6 - maintenance_work_mem is disabled in postgresql.conf by running a select query for pg_settings returns it is enabled