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

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



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



[Index of Archives]     [KVM ARM]     [KVM ia64]     [KVM ppc]     [Virtualization Tools]     [Spice Development]     [Libvirt]     [Libvirt Users]     [Linux USB Devel]     [Linux Audio Users]     [Yosemite Questions]     [Linux Kernel]     [Linux SCSI]     [XFree86]

  Powered by Linux