Re: temporarily disable autovacuum on a database or server ?

From: Jonathan Vanasco <postgres(at)2xlp(dot)com>
To: pgsql-general general <pgsql-general(at)postgresql(dot)org>
Subject: Re: temporarily disable autovacuum on a database or server ?
Date: 2017-01-12 17:09:49
Message-ID: 6371E32E-17C8-40A0-A3AB-7A5A8CE355AA@2xlp.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general


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 postgres 9.6.1 and ubuntu 16.04

anyways, thanks. i'll test that approach.

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Jonathan Vanasco 2017-01-12 20:06:14 efficiently migrating 'old' data from one table to another
Previous Message Adrian Klaver 2017-01-12 15:05:20 Re: Means to emulate global temporary table