Received: from localhost (postgresql.org [64.49.215.8]) by postgresql.org (Postfix) with ESMTP id 12B904761B8 for ; Wed, 20 Nov 2002 13:08:14 -0500 (EST) Received: from mail.libertyrms.com (unknown [209.167.124.227]) by postgresql.org (Postfix) with ESMTP id 75D00476306 for ; Wed, 20 Nov 2002 13:04:38 -0500 (EST) Received: from andrew by mail.libertyrms.com with local (Exim 3.22 #3 (Debian)) id 18EZDK-0007Tv-00 for ; Wed, 20 Nov 2002 13:04:38 -0500 Date: Wed, 20 Nov 2002 13:04:38 -0500 From: Andrew Sullivan To: Postgres Admin List Subject: Re: VACUUM Message-ID: <20021120130438.B8903@mail.libertyrms.com> Mail-Followup-To: Andrew Sullivan , Postgres Admin List References: <016e01c28c1d$f9db6340$de138f80@virginia.edu> <1037310288.4723.94.camel@camel> <22545.1037312286@sss.pgh.pa.us> Mime-Version: 1.0 Content-Type: text/plain; charset=us-ascii Content-Disposition: inline User-Agent: Mutt/1.2.5i In-Reply-To: <22545.1037312286@sss.pgh.pa.us>; from tgl@sss.pgh.pa.us on Thu, Nov 14, 2002 at 05:18:06PM -0500 X-Virus-Scanned: by AMaViS new-20020517 X-Archive-Number: 200211/181 X-Sequence-Number: 6369 On Thu, Nov 14, 2002 at 05:18:06PM -0500, Tom Lane wrote: > > The business about "you must vacuum at least every billion transactions" > is a different issue. Either plain or full vacuum will satisfy that > requirement. Note, also, that it is _every_ table needs to be vacuumed in that billion transaction period, but it is nevertheless probable that some of your tables will not need to be vacuumed as often as others. For efficiency's sake, therefore, you may want to vacuum different tables at different times. A -- ---- Andrew Sullivan 204-4141 Yonge Street Liberty RMS Toronto, Ontario Canada M2P 2A8 +1 416 646 3304 x110