From: scott ribe <scott_ribe@elevated-dev.com>
To: rajan <vgmonnet@gmail.com>
Cc: pgsql-admin@postgresql.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: Sun, 25 Jun 2017 07:46:13 -0600
Message-ID: <2AE3B8AD-3E5E-4E8C-8BB6-84C887437699@elevated-dev.com> (raw)
In-Reply-To: <1498377186127-5968586.post@n3.nabble.com>
References: <1498377186127-5968586.post@n3.nabble.com>
List-Unsubscribe: <mailto:majordomo@postgresql.org?body=unsub%20pgsql-admin>
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@gmail.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@elevated-dev.com
(303) 722-0567
--
Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-admin
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients from your mail client; the link fills in
the headers below: reply via email
Some clients, webmail especially, drop In-Reply-To and References from
a link, and the reply then starts a new thread: use the mbox below.
To: pgsql-admin@postgresql.org
Cc: scott_ribe@elevated-dev.com, vgmonnet@gmail.com
Subject: Re: pg9.6 - maintenance_work_mem is disabled in postgresql.conf by running a select query for pg_settings returns it is enabled
In-Reply-To: <2AE3B8AD-3E5E-4E8C-8BB6-84C887437699@elevated-dev.com>
References: <1498377186127-5968586.post@n3.nabble.com> <2AE3B8AD-3E5E-4E8C-8BB6-84C887437699@elevated-dev.com>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox