Received: from localhost (maia-1.hub.org [200.46.204.191]) by postgresql.org (Postfix) with ESMTP id 884639FA492 for ; Sun, 26 Nov 2006 10:34:04 -0400 (AST) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.191]) (amavisd-new, port 10024) with ESMTP id 27973-09 for ; Sun, 26 Nov 2006 10:33:59 -0400 (AST) X-Greylist: from auto-whitelisted by SQLgrey-1.7.4 Received: from main2.mycybernet.net (main2.mycybernet.net [209.222.63.140]) by postgresql.org (Postfix) with ESMTP id 11FA09FA48B for ; Sun, 26 Nov 2006 10:33:59 -0400 (AST) Received: from 227-54-222-209.mycybernet.net ([209.222.54.227] helo=phlogiston.dydns.org) by main2.mycybernet.net with esmtp (Exim 4.62) (envelope-from ) id 1GoM9z-0006ol-BS for pgsql-performance@postgresql.org; Sun, 26 Nov 2006 10:43:15 -0500 Received: by phlogiston.dydns.org (Postfix, from userid 1000) id DAFC94172; Sun, 26 Nov 2006 09:33:52 -0500 (EST) Date: Sun, 26 Nov 2006 09:33:52 -0500 From: Andrew Sullivan To: pgsql-performance@postgresql.org Subject: Re: When to vacuum a table? Message-ID: <20061126143352.GA17832@phlogiston.dyndns.org> References: <1164540257.7902.0.camel@panoramix> <20061126131147.GA4089@uio.no> <195C9B6B-2018-474C-AA80-239A8CEA37E9@gmail.com> Mime-Version: 1.0 Content-Type: text/plain; charset=us-ascii Content-Disposition: inline In-Reply-To: <195C9B6B-2018-474C-AA80-239A8CEA37E9@gmail.com> User-Agent: Mutt/1.5.9i X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200611/222 X-Sequence-Number: 21992 On Sun, Nov 26, 2006 at 09:24:29AM -0500, Rod Taylor wrote: > attempt and fail a large number of insert transactions then you will > still need to vacuum. And you still need to vacuum an insert-only table sometimes, because of the system-wide vacuum requirement. A -- Andrew Sullivan | ajs@crankycanuck.ca The whole tendency of modern prose is away from concreteness. --George Orwell