pg.ddx.io pgsql-admin@postgresql.org mailing list archive
help / color / mirror / Atom feedpg9.6 - maintenance_work_mem is disabled in postgresql.conf by running a select query for pg_settings returns it is enabled
8+ messages / 5 participants
[nested] [flat]
* pg9.6 - maintenance_work_mem is disabled in postgresql.conf by running a select query for pg_settings returns it is enabled
@ 2017-06-25 07:53 rajan <vgmonnet@gmail.com>
2017-06-25 08:35 ` Re: pg9.6 - maintenance_work_mem is disabled in postgresql.conf by running a select query for pg_settings returns it is enabled Ashish Tiwari <tashish786@gmail.com>
2017-06-25 13:46 ` Re: pg9.6 - maintenance_work_mem is disabled in postgresql.conf by running a select query for pg_settings returns it is enabled scott ribe <scott_ribe@elevated-dev.com>
0 siblings, 2 replies; 8+ messages in thread
From: rajan @ 2017-06-25 07:53 UTC (permalink / raw)
To: pgsql-admin
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-runni...
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
^ permalink raw reply [nested|flat] 8+ messages in thread
* Re: pg9.6 - maintenance_work_mem is disabled in postgresql.conf by running a select query for pg_settings returns it is enabled
2017-06-25 07:53 pg9.6 - maintenance_work_mem is disabled in postgresql.conf by running a select query for pg_settings returns it is enabled rajan <vgmonnet@gmail.com>
@ 2017-06-25 08:35 ` Ashish Tiwari <tashish786@gmail.com>
2017-06-25 13:27 ` Re: pg9.6 - maintenance_work_mem is disabled in postgresql.conf by running a select query for pg_settings returns it is enabled rajan <vgmonnet@gmail.com>
1 sibling, 1 reply; 8+ messages in thread
From: Ashish Tiwari @ 2017-06-25 08:35 UTC (permalink / raw)
To: rajan <vgmonnet@gmail.com>; +Cc: pgsql-admin
Hi ,
Have you restarted after commenting this parameter.
Thanks.
On Jun 25, 2017 1:23 PM, "rajan" <vgmonnet@gmail.com> 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@postgresql.org)
> To make changes to your subscription:
> http://www.postgresql.org/mailpref/pgsql-admin
>
^ permalink raw reply [nested|flat] 8+ messages in thread
* Re: pg9.6 - maintenance_work_mem is disabled in postgresql.conf by running a select query for pg_settings returns it is enabled
2017-06-25 07:53 pg9.6 - maintenance_work_mem is disabled in postgresql.conf by running a select query for pg_settings returns it is enabled rajan <vgmonnet@gmail.com>
2017-06-25 08:35 ` Re: pg9.6 - maintenance_work_mem is disabled in postgresql.conf by running a select query for pg_settings returns it is enabled Ashish Tiwari <tashish786@gmail.com>
@ 2017-06-25 13:27 ` rajan <vgmonnet@gmail.com>
2017-06-25 13:35 ` Re: Re: pg9.6 - maintenance_work_mem is disabled in postgresql.conf by running a select query for pg_settings returns it is enabled Keith <keith@keithf4.com>
2017-06-25 14:23 ` Re: Re: pg9.6 - maintenance_work_mem is disabled in postgresql.conf by running a select query for pg_settings returns it is enabled Ashish Tiwari <tashish786@gmail.com>
0 siblings, 2 replies; 8+ messages in thread
From: rajan @ 2017-06-25 13:27 UTC (permalink / raw)
To: pgsql-admin
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-runn...
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
^ permalink raw reply [nested|flat] 8+ messages in thread
* Re: Re: pg9.6 - maintenance_work_mem is disabled in postgresql.conf by running a select query for pg_settings returns it is enabled
2017-06-25 07:53 pg9.6 - maintenance_work_mem is disabled in postgresql.conf by running a select query for pg_settings returns it is enabled rajan <vgmonnet@gmail.com>
2017-06-25 08:35 ` Re: pg9.6 - maintenance_work_mem is disabled in postgresql.conf by running a select query for pg_settings returns it is enabled Ashish Tiwari <tashish786@gmail.com>
2017-06-25 13:27 ` Re: pg9.6 - maintenance_work_mem is disabled in postgresql.conf by running a select query for pg_settings returns it is enabled rajan <vgmonnet@gmail.com>
@ 2017-06-25 13:35 ` Keith <keith@keithf4.com>
1 sibling, 0 replies; 8+ messages in thread
From: Keith @ 2017-06-25 13:35 UTC (permalink / raw)
To: rajan <vgmonnet@gmail.com>; +Cc: pgsql-admin
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
^ permalink raw reply [nested|flat] 8+ messages in thread
* Re: Re: pg9.6 - maintenance_work_mem is disabled in postgresql.conf by running a select query for pg_settings returns it is enabled
2017-06-25 07:53 pg9.6 - maintenance_work_mem is disabled in postgresql.conf by running a select query for pg_settings returns it is enabled rajan <vgmonnet@gmail.com>
2017-06-25 08:35 ` Re: pg9.6 - maintenance_work_mem is disabled in postgresql.conf by running a select query for pg_settings returns it is enabled Ashish Tiwari <tashish786@gmail.com>
2017-06-25 13:27 ` Re: pg9.6 - maintenance_work_mem is disabled in postgresql.conf by running a select query for pg_settings returns it is enabled rajan <vgmonnet@gmail.com>
@ 2017-06-25 14:23 ` Ashish Tiwari <tashish786@gmail.com>
2017-06-25 14:36 ` Re: Re: pg9.6 - maintenance_work_mem is disabled in postgresql.conf by running a select query for pg_settings returns it is enabled Muthiah Rajan <vgmonnet@gmail.com>
1 sibling, 1 reply; 8+ messages in thread
From: Ashish Tiwari @ 2017-06-25 14:23 UTC (permalink / raw)
To: rajan <vgmonnet@gmail.com>; +Cc: pgsql-admin
It's keep some memories default to perform system operations.
Thanks.
On Jun 25, 2017 6:58 PM, "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
>
^ permalink raw reply [nested|flat] 8+ messages in thread
* Re: Re: pg9.6 - maintenance_work_mem is disabled in postgresql.conf by running a select query for pg_settings returns it is enabled
2017-06-25 07:53 pg9.6 - maintenance_work_mem is disabled in postgresql.conf by running a select query for pg_settings returns it is enabled rajan <vgmonnet@gmail.com>
2017-06-25 08:35 ` Re: pg9.6 - maintenance_work_mem is disabled in postgresql.conf by running a select query for pg_settings returns it is enabled Ashish Tiwari <tashish786@gmail.com>
2017-06-25 13:27 ` Re: pg9.6 - maintenance_work_mem is disabled in postgresql.conf by running a select query for pg_settings returns it is enabled rajan <vgmonnet@gmail.com>
2017-06-25 14:23 ` Re: Re: pg9.6 - maintenance_work_mem is disabled in postgresql.conf by running a select query for pg_settings returns it is enabled Ashish Tiwari <tashish786@gmail.com>
@ 2017-06-25 14:36 ` Muthiah Rajan <vgmonnet@gmail.com>
2017-06-25 14:40 ` Re: Re: pg9.6 - maintenance_work_mem is disabled in postgresql.conf by running a select query for pg_settings returns it is enabled Ashish Tiwari <tashish786@gmail.com>
0 siblings, 1 reply; 8+ messages in thread
From: Muthiah Rajan @ 2017-06-25 14:36 UTC (permalink / raw)
To: Ashish Tiwari <tashish786@gmail.com>; +Cc: pgsql-admin
Thanks all for replies. Now I understand.
On 25 Jun 2017 19:53, "Ashish Tiwari" <tashish786@gmail.com> wrote:
> It's keep some memories default to perform system operations.
>
> Thanks.
>
> On Jun 25, 2017 6:58 PM, "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-con
>> f-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
>>
>
^ permalink raw reply [nested|flat] 8+ messages in thread
* Re: Re: pg9.6 - maintenance_work_mem is disabled in postgresql.conf by running a select query for pg_settings returns it is enabled
2017-06-25 07:53 pg9.6 - maintenance_work_mem is disabled in postgresql.conf by running a select query for pg_settings returns it is enabled rajan <vgmonnet@gmail.com>
2017-06-25 08:35 ` Re: pg9.6 - maintenance_work_mem is disabled in postgresql.conf by running a select query for pg_settings returns it is enabled Ashish Tiwari <tashish786@gmail.com>
2017-06-25 13:27 ` Re: pg9.6 - maintenance_work_mem is disabled in postgresql.conf by running a select query for pg_settings returns it is enabled rajan <vgmonnet@gmail.com>
2017-06-25 14:23 ` Re: Re: pg9.6 - maintenance_work_mem is disabled in postgresql.conf by running a select query for pg_settings returns it is enabled Ashish Tiwari <tashish786@gmail.com>
2017-06-25 14:36 ` Re: Re: pg9.6 - maintenance_work_mem is disabled in postgresql.conf by running a select query for pg_settings returns it is enabled Muthiah Rajan <vgmonnet@gmail.com>
@ 2017-06-25 14:40 ` Ashish Tiwari <tashish786@gmail.com>
0 siblings, 0 replies; 8+ messages in thread
From: Ashish Tiwari @ 2017-06-25 14:40 UTC (permalink / raw)
To: Muthiah Rajan <vgmonnet@gmail.com>; +Cc: pgsql-admin
You're welcome!
On Jun 25, 2017 8:06 PM, "Muthiah Rajan" <vgmonnet@gmail.com> wrote:
> Thanks all for replies. Now I understand.
>
> On 25 Jun 2017 19:53, "Ashish Tiwari" <tashish786@gmail.com> wrote:
>
>> It's keep some memories default to perform system operations.
>>
>> Thanks.
>>
>> On Jun 25, 2017 6:58 PM, "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-con
>>> f-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
>>>
>>
^ permalink raw reply [nested|flat] 8+ messages in thread
* Re: pg9.6 - maintenance_work_mem is disabled in postgresql.conf by running a select query for pg_settings returns it is enabled
2017-06-25 07:53 pg9.6 - maintenance_work_mem is disabled in postgresql.conf by running a select query for pg_settings returns it is enabled rajan <vgmonnet@gmail.com>
@ 2017-06-25 13:46 ` scott ribe <scott_ribe@elevated-dev.com>
1 sibling, 0 replies; 8+ messages in thread
From: scott ribe @ 2017-06-25 13:46 UTC (permalink / raw)
To: rajan <vgmonnet@gmail.com>; +Cc: pgsql-admin
Lines in postgresql.conf being commented out doesn't mean things are disabled, it means the default value is not overridden.
> On Jun 25, 2017, at 1:53 AM, rajan <vgmonnet@gmail.com> 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
--
Scott Ribe
scott_ribe@elevated-dev.com
(303) 722-0567
--
Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-admin
^ permalink raw reply [nested|flat] 8+ messages in thread
end of thread, other threads:[~2017-06-25 14:40 UTC | newest]
Thread overview: 8+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2017-06-25 07:53 pg9.6 - maintenance_work_mem is disabled in postgresql.conf by running a select query for pg_settings returns it is enabled rajan <vgmonnet@gmail.com>
2017-06-25 08:35 ` Ashish Tiwari <tashish786@gmail.com>
2017-06-25 13:27 ` rajan <vgmonnet@gmail.com>
2017-06-25 13:35 ` Keith <keith@keithf4.com>
2017-06-25 14:23 ` Ashish Tiwari <tashish786@gmail.com>
2017-06-25 14:36 ` Muthiah Rajan <vgmonnet@gmail.com>
2017-06-25 14:40 ` Ashish Tiwari <tashish786@gmail.com>
2017-06-25 13:46 ` scott ribe <scott_ribe@elevated-dev.com>
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox