Re: [ADMIN] pg9.6 - maintenance_work_mem is disabled inpostgresql.conf by running a select query for pg_settings returns it is enabled

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