X-Original-To: pgsql-admin-postgresql.org@localhost.postgresql.org Received: from localhost (av.hub.org [200.46.204.144]) by postgresql.org (Postfix) with ESMTP id 143F69DC9A4 for ; Wed, 22 Mar 2006 15:10:16 -0400 (AST) Received: from postgresql.org ([200.46.204.71]) by localhost (av.hub.org [200.46.204.144]) (amavisd-new, port 10024) with ESMTP id 20229-03-2 for ; Wed, 22 Mar 2006 15:10:15 -0400 (AST) X-Greylist: domain auto-whitelisted by SQLgrey- Received: from xproxy.gmail.com (xproxy.gmail.com [66.249.82.202]) by postgresql.org (Postfix) with ESMTP id BD77A9DD5EE for ; Wed, 22 Mar 2006 15:10:09 -0400 (AST) Received: by xproxy.gmail.com with SMTP id t10so168633wxc for ; Wed, 22 Mar 2006 11:10:10 -0800 (PST) DomainKey-Signature: a=rsa-sha1; q=dns; c=nofws; s=beta; d=gmail.com; h=received:message-id:date:from:to:subject:mime-version:content-type; b=iLtUywwJH4WUnwC2CmYgoQnI3SnxjP9k+QmLHVCzu9dMKq/qtPwdNhmRmVdJv8VUPdI2FPwBxhEw/AVu4f8LskU269Zjmta2EeH6FXf19LM3LEPb/MmvpUQRmzwUDT7OVxy70VUO3jna0jzEaNUmTgB47kdcvkDSByHpJV6MBBc= Received: by 10.70.41.15 with SMTP id o15mr1399321wxo; Wed, 22 Mar 2006 11:10:09 -0800 (PST) Received: by 10.70.83.18 with HTTP; Wed, 22 Mar 2006 11:10:09 -0800 (PST) Message-ID: <1d219a6f0603221110v55c3ebcbm2461a67e61d87945@mail.gmail.com> Date: Wed, 22 Mar 2006 14:10:09 -0500 From: "Chris Hoover" To: "pgsql-admin@postgresql.org" Subject: How to turn off autovacuum MIME-Version: 1.0 Content-Type: multipart/alternative; boundary="----=_Part_9397_18983810.1143054609928" X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, score=0.628 required=5 tests=[AWL=-0.318, HTML_10_20=0.945, HTML_MESSAGE=0.001] X-Spam-Score: 0.628 X-Spam-Level: X-Archive-Number: 200603/212 X-Sequence-Number: 20969 ------=_Part_9397_18983810.1143054609928 Content-Type: text/plain; charset=ISO-8859-1 Content-Transfer-Encoding: quoted-printable Content-Disposition: inline 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 ------=_Part_9397_18983810.1143054609928 Content-Type: text/html; charset=ISO-8859-1 Content-Transfer-Encoding: quoted-printable Content-Disposition: inline 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
------=_Part_9397_18983810.1143054609928--