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.
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. |