From: | Melvin Davidson <melvin6925(at)gmail(dot)com> |
---|---|
To: | "David G(dot) Johnston" <david(dot)g(dot)johnston(at)gmail(dot)com> |
Cc: | Jonathan Vanasco <postgres(at)2xlp(dot)com>, pgsql-general general <pgsql-general(at)postgresql(dot)org> |
Subject: | Re: temporarily disable autovacuum on a database or server ? |
Date: | 2017-01-12 01:19:07 |
Message-ID: | CANu8FixZXHWALGVGNwVS-=HGO3AqRX+bU2TRCxuB+j_RCAn6UQ@mail.gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
On Wed, Jan 11, 2017 at 8:09 PM, David G. Johnston <
david(dot)g(dot)johnston(at)gmail(dot)com> wrote:
> On Wed, Jan 11, 2017 at 5:50 PM, Melvin Davidson <melvin6925(at)gmail(dot)com>
> wrote:
>
>> On Wed, Jan 11, 2017 at 7:26 PM, Jonathan Vanasco <postgres(at)2xlp(dot)com>
>> wrote:
>>
>>>
>>>
>> *I can't confirm this, but have you tried :*
>>
>> *SELECT set_config('autovacuum', 'off'', false);*
>>
>> *SELECT pg_reload_conf(); *
>>
>> *note: you must be a superuser for above*
>>
>
> I'm hoping you meant "ALTER SYSTEM" instead of "set_config()"...
>
> The documentation on these parameters is unclear: the only way to change
> the values is to edit postgresql.conf (or on the command line) but there is
> nothing said regarding whether pg_reload_conf() will work for them. I'd be
> surprised if it did...
>
> If it does - and for other cases where you can, instead of set_config you
> could use "ALTER SYSTEM" and at least avoid having to manually edit the
> config file. When done simply:
> ALTER SYSTEM RESET autovacuum; SELECT pg_reload_conf();
> to get back to normal operation.
>
> David J.
>
>
*Yes, you're right about ALTER SYSTER. Unfortunately, the op provided
neither PostgreSQL version or O/S, so we can't even be sure that is *
*an option. That is why I stated "I cannot confirm".*
--
*Melvin Davidson*
I reserve the right to fantasize. Whether or not you
wish to share my fantasy is entirely up to you.
From | Date | Subject | |
---|---|---|---|
Next Message | David G. Johnston | 2017-01-12 01:25:21 | Re: temporarily disable autovacuum on a database or server ? |
Previous Message | David G. Johnston | 2017-01-12 01:09:24 | Re: temporarily disable autovacuum on a database or server ? |