X-Original-To: pgsql-performance-postgresql.org@localhost.postgresql.org Received: from localhost (av.hub.org [200.46.204.144]) by postgresql.org (Postfix) with ESMTP id EE24A9DC876 for ; Tue, 17 Jan 2006 10:02:50 -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 22991-08 for ; Tue, 17 Jan 2006 10:02:54 -0400 (AST) X-Greylist: from auto-whitelisted by SQLgrey- Received: from floppy.pyrenet.fr (floppy.pyrenet.fr [194.116.145.2]) by postgresql.org (Postfix) with ESMTP id 71E159DC870 for ; Tue, 17 Jan 2006 10:02:47 -0400 (AST) Received: by floppy.pyrenet.fr (Postfix, from userid 106) id 3C29F30F0B; Tue, 17 Jan 2006 15:02:51 +0100 (MET) From: Christopher Browne X-Newsgroups: pgsql.performance Subject: Re: Autovacuum / full vacuum Date: Tue, 17 Jan 2006 08:59:28 -0500 Organization: cbbrowne Computing Inc Lines: 14 Message-ID: References: Mime-Version: 1.0 Content-Type: text/plain; charset=us-ascii X-Complaints-To: usenet@news.hub.org X-message-flag: Outlook is rather hackable, isn't it? X-Home-Page: http://www.cbbrowne.com/info/ X-Affero: http://svcs.affero.net/rm.php?r=cbbrowne User-Agent: Gnus/5.1006 (Gnus v5.10.6) XEmacs/21.4 (Jumbo Shrimp, berkeley-unix) Cancel-Lock: sha1:Fd6p+sVXstPx1eTWnKh+9tOj+kc= To: pgsql-performance@postgresql.org X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, score=0.662 required=5 tests=[AWL=-0.151, INFO_TLD=0.813] X-Spam-Score: 0.662 X-Spam-Level: X-Archive-Number: 200601/228 X-Sequence-Number: 16706 > I'm curious as to why autovacuum is not designed to do full vacuum. Because that's terribly invasive due to the locks it takes out. Lazy vacuum may chew some I/O, but it does *not* block your application for the duration. VACUUM FULL blocks the application. That is NOT something that anyone wants to throw into the "activity mix" randomly. -- let name="cbbrowne" and tld="gmail.com" in String.concat "@" [name;tld];; http://linuxdatabases.info/info/slony.html Signs of a Klingon Programmer #11: "This machine is a piece of GAGH! I need dual Pentium processors if I am to do battle with this code!"