From: rajan <vgmonnet@gmail.com>
To: pgsql-admin@postgresql.org
Subject: 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 00:53:06 -0700 (MST)
Message-ID: <1498377186127-5968586.post@n3.nabble.com> (raw)
List-Unsubscribe: <mailto:majordomo@postgresql.org?body=unsub%20pgsql-admin>
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-runni...
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
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 using the --to and --cc options:
reply via email
To: pgsql-admin@postgresql.org
Cc: 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: <1498377186127-5968586.post@n3.nabble.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