On Thu, Jan 12, 2017 at 12:09 PM, Jonathan Vanasco
wrote:
>
> On Jan 11, 2017, at 8:19 PM, Melvin Davidson wrote:
>
>
>>
> *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 sta
On Jan 11, 2017, at 8:19 PM, Melvin Davidson wrote:
>
> 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".
I didn't think that would matter, but postg
On Wed, Jan 11, 2017 at 6:19 PM, Melvin Davidson
wrote:
>
>>
> *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".*
>
>
​Thought it was just a non-de
On Wed, Jan 11, 2017 at 8:09 PM, David G. Johnston <
david.g.johns...@gmail.com> wrote:
> On Wed, Jan 11, 2017 at 5:50 PM, Melvin Davidson
> wrote:
>
>> On Wed, Jan 11, 2017 at 7:26 PM, Jonathan Vanasco
>> wrote:
>>
>>>
>>>
>> *I can't confirm this, but have you tried :*
>>
>> *SELECT set_config
On Wed, Jan 11, 2017 at 5:50 PM, Melvin Davidson
wrote:
> On Wed, Jan 11, 2017 at 7:26 PM, Jonathan Vanasco
> 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
On Wed, Jan 11, 2017 at 7:26 PM, Jonathan Vanasco wrote:
> I've run into a performance issue, and I think autovacuum may be involved.
>
> does anyone know if its possible to temporarily stop autovacuum without a
> server restart ?
>
> It seems that it either requires a server restart, or specific