Postgres Pro
Downloads
Home   >   mailing lists

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

From Keith
Subject Re: [ADMIN] Re: pg9.6 - maintenance_work_mem is disabled inpostgresql.conf by running a select query for pg_settings returns it is enabled
Date
Msg-id CAHw75vuKY-TDYO4tx0Cw3DfmvssZHM4BhibSRP_=vJPdsjsyiQ@mail.gmail.com
Whole thread Raw
In response to [ADMIN] Re: pg9.6 - maintenance_work_mem is disabled in postgresql.conf byrunning a select query for pg_settings returns it is enabled  (rajan <vgmonnet@gmail.com>)
List pgsql-admin
Tree view


On Sun, Jun 25, 2017 at 9:27 AM, rajan <vgmonnet@gmail.com> wrote:
Actually I did not make any changes to postgresql.conf

When studying about this parameter I thought I should check what my current
setting(for maintenance_work_mem) is and then I found that it is commented
in postgresql.conf while the pg_settings has the value enabled.



-----
--
Thanks,
Rajan.
--
View this message in context: http://www.postgresql-archive.org/pg9-6-maintenance-work-mem-is-disabled-in-postgresql-conf-but-running-a-select-query-for-pg-settingsd-tp5968586p5968596.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


maintenance_work_mem isn't a setting that can be completely disabled. It's used for normal maintenance operations like autovaccum and index creation. If not set in postgresql.conf, it has a default value of 64MB in 9.6

https://www.postgresql.org/docs/9.6/static/runtime-config-resource.html

Keith

pgsql-admin by date:

Previous
From: rajan
Date:
Subject: [ADMIN] Re: pg9.6 - maintenance_work_mem is disabled in postgresql.conf byrunning a select query for pg_settings returns it is enabled
Next
From: scott ribe
Date:
Subject: Re: [ADMIN] pg9.6 - maintenance_work_mem is disabled inpostgresql.conf by running a select query for pg_settings returns it isenabled