Received: from localhost (postgresql.org [64.49.215.8]) by postgresql.org (Postfix) with ESMTP id AD34B475E25 for ; Thu, 14 Nov 2002 17:55:12 -0500 (EST) Received: from localhost.localdomain (unknown [65.217.53.66]) by postgresql.org (Postfix) with ESMTP id E8498475E13 for ; Thu, 14 Nov 2002 17:55:11 -0500 (EST) Received: from thorn.mmrd.com (thorn.mmrd.com [172.25.10.100]) by localhost.localdomain (8.12.5/8.12.5) with ESMTP id gAEMxN6P026751; Thu, 14 Nov 2002 17:59:24 -0500 Received: from gnvex001.mmrd.com (gnvex001.mmrd.com [192.168.3.55]) by thorn.mmrd.com (8.11.6/8.11.6) with ESMTP id gAEMtCj01413; Thu, 14 Nov 2002 17:55:13 -0500 Received: from camel.mmrd.com ([172.25.5.213]) by gnvex001.mmrd.com with SMTP (Microsoft Exchange Internet Mail Service Version 5.5.2653.13) id W7RLWLP7; Thu, 14 Nov 2002 17:55:11 -0500 Subject: Re: VACUUM From: Robert Treat To: Tom Lane Cc: Jodi Kanter , Postgres Admin List In-Reply-To: <22545.1037312286@sss.pgh.pa.us> References: <016e01c28c1d$f9db6340$de138f80@virginia.edu> <1037310288.4723.94.camel@camel> <22545.1037312286@sss.pgh.pa.us> Content-Type: text/plain Content-Transfer-Encoding: 7bit X-Mailer: Ximian Evolution 1.0.8 Date: 14 Nov 2002 17:55:12 -0500 Message-Id: <1037314512.4724.103.camel@camel> Mime-Version: 1.0 X-Virus-Scanned: by AMaViS new-20020517 X-Archive-Number: 200211/158 X-Sequence-Number: 6346 On Thu, 2002-11-14 at 17:18, Tom Lane wrote: > Robert Treat writes: > > (Right now the only way to set up an appropriate vacuuming schedule is > for the DBA to hand-craft a cron script. I'd like to see the database > able to launch automatic background vacuum runs by itself.) > There is also an "automatic vacuum daemon" on gborg. I've looked at the code and it looks nifty, though I haven't used it myself. Robert Treat