X-Original-To: pgsql-admin-postgresql.org@postgresql.org Received: from localhost (mx1.hub.org [200.46.208.251]) by postgresql.org (Postfix) with ESMTP id 3D2E09FB1B8 for ; Mon, 18 Sep 2006 07:46:55 -0300 (ADT) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.208.251]) (amavisd-new, port 10024) with ESMTP id 11623-07 for ; Mon, 18 Sep 2006 07:46:52 -0300 (ADT) X-Greylist: delayed 00:28:24.172647 by SQLgrey- Received: from svr4.postgresql.org (svr4.postgresql.org [66.98.251.159]) by postgresql.org (Postfix) with ESMTP id 78E209FA5FB for ; Mon, 18 Sep 2006 07:46:51 -0300 (ADT) X-Greylist: domain auto-whitelisted by SQLgrey-1.7.3 Received: from fafnir.androme.com (fafnir.androme.com [62.58.96.158]) by svr4.postgresql.org (Postfix) with ESMTP id 76EF85AF034 for ; Mon, 18 Sep 2006 10:18:41 +0000 (GMT) Received: by fafnir.androme.com (Postfix, from userid 1003) id 0A1CEB92C1A; Mon, 18 Sep 2006 12:18:19 +0200 (CEST) Message-ID: <450E726A.6040508@andromeiberica.com> Date: Mon, 18 Sep 2006 12:18:18 +0200 From: Arnau Reply-To: arnaulist@andromeiberica.com User-Agent: Thunderbird 1.5.0.7 (Windows/20060909) MIME-Version: 1.0 To: pgsql-admin@postgresql.org Subject: When vaccuum full should be performed with postgresql-8.1 and autovaccuum? Content-Type: text/plain; charset=ISO-8859-1; format=flowed Content-Transfer-Encoding: 7bit X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=1.088 tagged_above=0 required=5 tests=AWL, SPF_SOFTFAIL X-Spam-Level: * X-Archive-Number: 200609/174 X-Sequence-Number: 23088 Hi all, I'm migrating our DDBB from postgresql 7.4 to postgresql 8.1. In postgreql 7.4 we don't have autovaccum running. So, every night before doing the daily backup we do a "vaccuumdb -f -z" for each DB. My doubt is, the autovaccuum with the version 8.1 is started by default and I don't know how often I should perform the "vaccuumdb -f -z" or now it's not necessary to do it at all. Thank you very much -- Arnau