Hi ,
Have you restarted after commenting this parameter.
Thanks.
On Jun 25, 2017 1:23 PM, "rajan" <vgmonnet@xxxxxxxxx> wrote:
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
