pg.ddx.io  pgsql-admin@postgresql.org mailing list archive  
help / color / mirror / Atom feed
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



view thread (8+ messages)  latest in thread

Message-ID: <2AE3B8AD-3E5E-4E8C-8BB6-84C887437699@elevated-dev.com>
Permalink:  ../2AE3B8AD-3E5E-4E8C-8BB6-84C887437699@elevated-dev.com/
Also on:    postgresql.org/message-id/2AE3B8AD-3E5E-4E8C-8BB6-84C887437699@elevated-dev.com

 · 

reply

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