How to turn off autovacuum

From: "Chris Hoover" <revoohc(at)gmail(dot)com>
To: "pgsql-admin(at)postgresql(dot)org" <pgsql-admin(at)postgresql(dot)org>
Subject: How to turn off autovacuum
Date: 2006-03-22 19:10:09
Message-ID: 1d219a6f0603221110v55c3ebcbm2461a67e61d87945@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

Question, if I turn on autovacuum in PG 8.1, how do I turn it off?

The reason behind this question is that we would love to turn it on and try
it in our production systems. However, if we find that it is causing to
much i/o load, we need to be able to turn it off on a moments notice with
out stopping the database.

Is this possible?

Thanks,

Chris

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message Tom Lane 2006-03-22 19:35:28 Re: How to turn off autovacuum
Previous Message Zuoxin.Wang 2006-03-22 18:02:02 unsubscribe