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 6CDAF9DC884 for ; Tue, 17 Jan 2006 06:33:03 -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 85761-03 for ; Tue, 17 Jan 2006 06:33:05 -0400 (AST) X-Greylist: from auto-whitelisted by SQLgrey- Received: from floppy.pyrenet.fr (news.pyrenet.fr [194.116.145.2]) by postgresql.org (Postfix) with ESMTP id 1502B9DC879 for ; Tue, 17 Jan 2006 06:33:01 -0400 (AST) Received: by floppy.pyrenet.fr (Postfix, from userid 106) id 7BE5130949; Tue, 17 Jan 2006 11:33:03 +0100 (MET) From: Michael Riess X-Newsgroups: pgsql.performance Subject: Re: Autovacuum / full vacuum Date: Tue, 17 Jan 2006 11:33:02 +0100 Organization: Hub.Org Networking Services Lines: 20 Message-ID: References: <43CCC711.504@familyhealth.com.au> Mime-Version: 1.0 Content-Type: text/plain; charset=ISO-8859-15; format=flowed Content-Transfer-Encoding: 7bit X-Complaints-To: usenet@news.hub.org User-Agent: Thunderbird 1.5 (Windows/20051201) In-Reply-To: <43CCC711.504@familyhealth.com.au> To: pgsql-performance@postgresql.org X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, score=0.048 required=5 tests=[AWL=0.048] X-Spam-Score: 0.048 X-Spam-Level: X-Archive-Number: 200601/220 X-Sequence-Number: 16698 Hi, did you read my post? In the first part I explained why I don't want to increase the FSM that much. Mike >> So my question is: What's the use of an autovacuum daemon if I still >> have to use a cron job to do full vacuums? wouldn't it just be a minor >> job to enhance autovacuum to be able to perform full vacuums, if one >> really wants it to do that - even if some developers think that it's >> the wrong approach? > > You should never have to do full vacuums... > > Chris > > ---------------------------(end of broadcast)--------------------------- > TIP 6: explain analyze is your friend >