Postgres Pro
Downloads
Home   >   mailing lists

Re: [GENERAL] temporarily disable autovacuum on a database or server ? - Mailing list pgsql-general

From Jonathan Vanasco
Subject Re: [GENERAL] temporarily disable autovacuum on a database or server ?
Date
Msg-id 6371E32E-17C8-40A0-A3AB-7A5A8CE355AA@2xlp.com
Whole thread Raw
In response to Re: [GENERAL] temporarily disable autovacuum on a database or server ?  (Melvin Davidson <melvin6925@gmail.com>)
Responses Re: [GENERAL] temporarily disable autovacuum on a database or server ?
List pgsql-general
Tree view

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.


pgsql-general by date:

Previous
From: Adrian Klaver
Date:
Subject: Re: [GENERAL] Means to emulate global temporary table
Next
From: Jonathan Vanasco
Date:
Subject: [GENERAL] efficiently migrating 'old' data from one table to another