pg9.6 - maintenance_work_mem is disabled in postgresql.conf by running a select query for pg_settings returns it is enabled

From: rajan <vgmonnet(at)gmail(dot)com>
To: pgsql-admin(at)postgresql(dot)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: 2017-06-25 07:53:06
Message-ID: 1498377186127-5968586.post@n3.nabble.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-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-running-a-select-query-for-pg-settings-d-tp5968586.html
Sent from the PostgreSQL - admin mailing list archive at Nabble.com.

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message Ashish Tiwari 2017-06-25 08:35:01 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 Williams, Alex 2017-06-23 18:55:23 Re: Re: PGAdmin 4 1.5 Checkboxes in result columns push column names to next line, clipping the column names.