Date: Sun, 25 Jun 2017 00:53:06 -0700 (MST)
From: rajan <vgmonnet@gmail.com>
To: pgsql-admin@postgresql.org
Message-ID: <1498377186127-5968586.post@n3.nabble.com>
Subject: pg9.6 - maintenance_work_mem is disabled in postgresql.conf by
 running a select query for pg_settings returns it is enabled
MIME-Version: 1.0
Content-Type: text/plain; charset=us-ascii
Content-Transfer-Encoding: 7bit
Precedence: bulk
Sender: pgsql-admin-owner@postgresql.org

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@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-admin