X-Original-To: pgsql-performance-postgresql.org@localhost.postgresql.org Received: from localhost (unknown [200.46.204.144]) by svr1.postgresql.org (Postfix) with ESMTP id 591A48B9CC0 for ; Wed, 23 Feb 2005 06:04:14 +0000 (GMT) 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 56143-08 for ; Wed, 23 Feb 2005 06:04:05 +0000 (GMT) Received: from floppy.pyrenet.fr (floppy.pyrenet.fr [194.250.190.2]) by svr1.postgresql.org (Postfix) with ESMTP id 3EAA28B9B3B for ; Wed, 23 Feb 2005 06:04:04 +0000 (GMT) Received: by floppy.pyrenet.fr (Postfix, from userid 106) id 5FF1131DA7; Wed, 23 Feb 2005 07:04:04 +0100 (MET) From: Christopher Browne X-Newsgroups: pgsql.performance Subject: Re: is pg_autovacuum so effective ? Date: Wed, 23 Feb 2005 00:35:26 -0500 Organization: Afilias Canada - Operations Group Lines: 31 Message-ID: <60ll9f2601.fsf@dba2.int.libertyrms.com> References: <421B9CD9.6090703@zeut.net> <421BD6BF.4060007@bigfoot.com> Mime-Version: 1.0 Content-Type: text/plain; charset=us-ascii X-Complaints-To: usenet@news.hub.org User-Agent: Gnus/5.1006 (Gnus v5.10.6) XEmacs/21.4 (Jumbo Shrimp, linux) Cancel-Lock: sha1:EHaLDR1JrOzHfTbeDEkHQw5ZGEA= To: pgsql-performance@postgresql.org X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, hits=0.042 tagged_above=0 required=5 tests=AWL X-Spam-Level: X-Archive-Number: 200502/307 X-Sequence-Number: 10636 Gaetano Mendola writes: > Matthew T. O'Connor wrote: > >> Well without thinking too much, I would first ask about your FSM >> settings? If they aren't big enought that will cause bloat. Try >> bumping your FSM settings and then see if you reach steady state. > > FSM settings are big enough: > > max_fsm_pages | 2000000 > max_fsm_relations | 1000 > > at least after a vacuum full I see that these numbers are an overkill... When you do a VACUUM FULL, the FSM is made irrelevant because VACUUM FULL takes the time to reclaim all possible space without resorting to _any_ use of the FSM. If you VACUUM FULL, then it's of little value to bother having a free space map because you're obviating the need to use it. In any case, the FSM figures you get out of a VACUUM are only really meaningful if you're moving towards the "equilibrium point" where the FSM is large enough to cope with the growth between VACUUM cycles. VACUUM FULL pushes the system away from equilibrium, thereby making FSM estimates less useful. -- "cbbrowne","@","ca.afilias.info" Christopher Browne (416) 673-4124 (land)