Received: from maia.hub.org (maia-5.hub.org [200.46.204.29]) by mail.postgresql.org (Postfix) with ESMTP id 3E180636DF0 for ; Tue, 20 Jul 2010 14:04:13 -0300 (ADT) Received: from mail.postgresql.org ([200.46.204.86]) by maia.hub.org (mx1.hub.org [200.46.204.29]) (amavisd-maia, port 10024) with ESMTP id 92721-02 for ; Tue, 20 Jul 2010 17:04:05 +0000 (UTC) X-Greylist: from auto-whitelisted by SQLgrey-1.7.6 Received: from spinlock.commandprompt.com (host-215.commandprompt.net [207.173.203.215]) by mail.postgresql.org (Postfix) with ESMTP id 9A67E636DBA for ; Tue, 20 Jul 2010 14:04:05 -0300 (ADT) Received: from localhost (localhost [127.0.0.1]) by spinlock.commandprompt.com (Postfix) with ESMTP id 7FD63348035; Tue, 20 Jul 2010 10:04:04 -0700 (PDT) X-Virus-Scanned: Debian amavisd-new at commandprompt.com Received: from spinlock.commandprompt.com ([127.0.0.1]) by localhost (spinlock.commandprompt.com.commandprompt.com [127.0.0.1]) (amavisd-new, port 10024) with ESMTP id 2H6X846b0PfW; Tue, 20 Jul 2010 10:04:02 -0700 (PDT) Received: from [75.142.153.107] (unknown [75.142.153.107]) by spinlock.commandprompt.com (Postfix) with ESMTPSA id 248AE348034; Tue, 20 Jul 2010 10:04:02 -0700 (PDT) Subject: Re: Autovacuum on defined interval From: "Joshua D. Drake" Reply-To: jd@commandprompt.com To: =?ISO-8859-1?Q?F=E1bio?= Gibon - Comex System Cc: PostgreSQL - mailing list In-Reply-To: <001001cb2827$85bdb8b0$6500a8c0@gibon> References: <001001cb2827$85bdb8b0$6500a8c0@gibon> Content-Type: text/plain; charset="UTF-8" Organization: Command Prompt, Inc. Date: Tue, 20 Jul 2010 10:03:49 -0700 Message-ID: <1279645429.3623.96.camel@jd-desktop.unknown.charter.com> Mime-Version: 1.0 X-Mailer: Evolution 2.28.3 Content-Transfer-Encoding: 8bit X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=-0.001 tagged_above=-10 required=5 tests=BAYES_40=-0.001 X-Spam-Level: X-Archive-Number: 201007/147 X-Sequence-Number: 35166 On Tue, 2010-07-20 at 13:20 -0300, Fábio Gibon - Comex System wrote: > Hi everybody, > are there how define autovacuum to ON and define the period > time (for example, 00h - 06h) that it's can run? > No. You would need to write your own job manager (or use one of the many that already exist) and vacuum via it. JD > tks > > Fábio Henrique Gibon > Comex System Consultoria -- PostgreSQL.org Major Contributor Command Prompt, Inc: http://www.commandprompt.com/ - 509.416.6579 Consulting, Training, Support, Custom Development, Engineering