From: | Ashish Tiwari <tashish786(at)gmail(dot)com> |
---|---|
To: | rajan <vgmonnet(at)gmail(dot)com> |
Cc: | pgsql-admin(at)postgresql(dot)org |
Subject: | 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 08:35:01 |
Message-ID: | CAH8UkmF3OJbPODmmjmv2k+qv7LbVFAU9nWiHtnJWNTtECV8FaQ@mail.gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-admin |
Hi ,
Have you restarted after commenting this parameter.
Thanks.
On Jun 25, 2017 1:23 PM, "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
>
>
>
>
>
> -----
> --
> Thanks,
> Rajan.
> --
> View this message in context: http://www.postgresql-archive.
> org/pg9-6-maintenance-work-mem-is-disabled-in-postgresql-
> conf-by-running-a-select-query-for-pg-settings-d-tp5968586.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
>
From | Date | Subject | |
---|---|---|---|
Next Message | rajan | 2017-06-25 13:27:52 | Re: pg9.6 - maintenance_work_mem is disabled in postgresql.conf by running a select query for pg_settings returns it is enabled |
Previous Message | rajan | 2017-06-25 07:53:06 | pg9.6 - maintenance_work_mem is disabled in postgresql.conf by running a select query for pg_settings returns it is enabled |