X-Original-To: pgsql-admin-postgresql.org@localhost.postgresql.org Received: from localhost (unknown [200.46.204.144]) by svr1.postgresql.org (Postfix) with ESMTP id 21770D1B252 for ; Mon, 2 Aug 2004 13:11:37 -0300 (ADT) Received: from svr1.postgresql.org ([200.46.204.71]) by localhost (av.hub.org [200.46.204.144]) (amavisd-new, port 10024) with ESMTP id 89018-10 for ; Mon, 2 Aug 2004 16:11:31 +0000 (GMT) Received: from mpls-qmqp-03.inet.qwest.net (mpls-qmqp-03.inet.qwest.net [63.231.195.114]) by svr1.postgresql.org (Postfix) with SMTP id A5725D1B209 for ; Mon, 2 Aug 2004 13:11:30 -0300 (ADT) Received: (qmail 91259 invoked by uid 0); 2 Aug 2004 15:40:07 -0000 Received: from mpls-pop-02.inet.qwest.net (63.231.195.2) by mpls-qmqp-03.inet.qwest.net with QMQP; 2 Aug 2004 15:40:07 -0000 Received: from 63-227-127-37.dnvr.qwest.net (HELO ?10.0.0.2?) (63.227.127.37) by mpls-pop-02.inet.qwest.net with SMTP; 2 Aug 2004 16:11:30 -0000 Date: Mon, 02 Aug 2004 10:12:50 -0600 Message-Id: <1091463170.27166.35.camel@localhost.localdomain> From: "Scott Marlowe" To: "Gaetano Mendola" Cc: "pgsql-admin@postgresql.org" Subject: Re: running only pg_autovacuum for one week In-Reply-To: <410E3CCA.9090805@bigfoot.com> References: <410E3CCA.9090805@bigfoot.com> Content-Type: text/plain Mime-Version: 1.0 X-Mailer: Ximian Evolution 1.4.6 (1.4.6-2) Content-Transfer-Encoding: 7bit X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, hits=0.1 tagged_above=0.0 required=5.0 tests=RCVD_IN_SORBS X-Spam-Level: X-Archive-Number: 200408/7 X-Sequence-Number: 14402 On Mon, 2004-08-02 at 07:08, Gaetano Mendola wrote: > -----BEGIN PGP SIGNED MESSAGE----- > Hash: SHA1 > > Hi all, > I did the experiment of running only the autovacuum for one week without > running my daily autovacuum full and reindex on heavy updated/inserted > tables. > Yesterday I reenabled the vacuum full and reindex and, as you can see > from the attachment, I recover 600MB of wasted space. autovacuum is a daemon. You don't run it once a week, you set it loose and forget about it. Unless you're running it then shutting it down, running once a week is unnecessary. Also, what are you fsm settings in the postgresql.conf file?