X-Original-To: pgsql-admin-postgresql.org@postgresql.org Received: from localhost (wm.hub.org [200.46.204.128]) by postgresql.org (Postfix) with ESMTP id 0C5949FB1D4 for ; Tue, 19 Sep 2006 01:08:37 -0300 (ADT) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.128]) (amavisd-new, port 10024) with ESMTP id 73392-03 for ; Tue, 19 Sep 2006 04:08:24 +0000 (UTC) X-Greylist: from auto-whitelisted by SQLgrey- Received: from outbound.mailhop.org (outbound.mailhop.org [63.208.196.171]) by postgresql.org (Postfix) with ESMTP id 7ABCA9FB1C2 for ; Tue, 19 Sep 2006 01:08:24 -0300 (ADT) Received: from pool-72-88-194-29.nwrknj.fios.verizon.net ([72.88.194.29] helo=[192.168.4.67]) by outbound.mailhop.org with esmtpa (Exim 4.51) id 1GPWuE-000DxM-GB; Tue, 19 Sep 2006 00:08:22 -0400 X-Mail-Handler: MailHop Outbound by DynDNS X-Originating-IP: 72.88.194.29 X-Report-Abuse-To: abuse@dyndns.com (see http://www.mailhop.org/outbound/abuse.html for abuse reporting information) X-MHO-User: tocr Message-ID: <450F6D2E.3030908@zeut.net> Date: Tue, 19 Sep 2006 00:08:14 -0400 From: "Matthew T. O'Connor" User-Agent: Thunderbird 2.0a1 (Windows/20060724) MIME-Version: 1.0 To: arnaulist@andromeiberica.com CC: pgsql-admin@postgresql.org Subject: Re: When vaccuum full should be performed with postgresql-8.1 References: <450E726A.6040508@andromeiberica.com> In-Reply-To: <450E726A.6040508@andromeiberica.com> Content-Type: text/plain; charset=ISO-8859-1; format=flowed Content-Transfer-Encoding: 7bit X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200609/187 X-Sequence-Number: 23101 Arnau wrote: > 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. First off, you should never really need vacuumdb -f, in fact autovacuum doesn't do full vacuums, rather it only does the standard vacuum. In theory autovacuum should perform all the vacuuming that is needed, however, in practice this isn't always the case. First the most people find the default thresholds for autovacuum in 8.1 are too conservative and second it can be a bit hard to monitor what autovacuum is doing. Both of these issues are improved in 8.2. In summary, try it and see.