Received: from localhost (maia-1.hub.org [200.46.204.191]) by postgresql.org (Postfix) with ESMTP id DC2A49FA1A7 for ; Thu, 30 Nov 2006 10:57:23 -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 26174-10 for ; Thu, 30 Nov 2006 10:57:00 -0400 (AST) X-Greylist: domain auto-whitelisted by SQLgrey-1.7.4 Received: from ug-out-1314.google.com (ug-out-1314.google.com [66.249.92.174]) by postgresql.org (Postfix) with ESMTP id C2C149FA1A1 for ; Thu, 30 Nov 2006 10:56:58 -0400 (AST) Received: by ug-out-1314.google.com with SMTP id k3so1915691ugf for ; Thu, 30 Nov 2006 06:56:57 -0800 (PST) DomainKey-Signature: a=rsa-sha1; q=dns; c=nofws; s=beta; d=gmail.com; h=received:message-id:date:from:to:subject:in-reply-to:mime-version:content-type:content-transfer-encoding:content-disposition:references; b=SmFP3v2+HUlSJHSQH//DnebKUMKpMdzC6ERII12J5SeUixhM/n+NjBVDs36Cu7vohK2HtkB6h7tSMZB+UC1gX9XF8jvdf7MxAm6o3NOU5dKkR1orQ0Zg3U8rJYWRCoqvX0WxWj7rC2WUPCeqPekMUmQqzc9ImMxI6ssFnriGlBI= Received: by 10.78.170.17 with SMTP id s17mr3608872hue.1164898616863; Thu, 30 Nov 2006 06:56:56 -0800 (PST) Received: by 10.78.107.14 with HTTP; Thu, 30 Nov 2006 06:56:56 -0800 (PST) Message-ID: Date: Thu, 30 Nov 2006 14:56:56 +0000 From: "Peter Childs" To: pgsql-sql@postgresql.org Subject: Re: Autovaccum In-Reply-To: <20061130142406.GH15105@alvh.no-ip.org> MIME-Version: 1.0 Content-Type: text/plain; charset=ISO-8859-1; format=flowed Content-Transfer-Encoding: 7bit Content-Disposition: inline References: <55c095e90611300602n18fa7e8v8e985386f74afba1@mail.gmail.com> <20061130142406.GH15105@alvh.no-ip.org> X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200611/291 X-Sequence-Number: 26943 On 30/11/06, Alvaro Herrera wrote: > Ezequias Rodrigues da Rocha wrote: > > Hi list, > > > > I would like to know if it is necessary to set my database to > > autovaccum if the intent of my DB Manager is do not make any deletion > > in any time. > > > > If there is no deletions why autovaccum ok ? > > You need to vacuum from time to time anyway, even if you don't delete > anything. The easiest way to do it is let autovacuum do it for you. > Complete Answer. 1. If you do any updates or deletes you need to vacuum. 2. If you do any update, deletes or inserts you need to analyse. 3. If you never change anything No Updates, No Inserts, No Deletes you need to vacuum once ever 2 billion transactions due to wrap around if you don't your data will disappear. But depending on how busy your database is this could be once a year. 4. Auto Vacuum does all this automatically. Which is kind of useful. 5. You can do this manually via cron or by hand if you wish. Peter.