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