X-Original-To: pgsql-admin-postgresql.org@localhost.postgresql.org Received: from localhost (av.hub.org [200.46.204.144]) by svr1.postgresql.org (Postfix) with ESMTP id 29EBED82C0 for ; Fri, 18 Nov 2005 17:12:04 -0400 (AST) 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 92723-05 for ; Fri, 18 Nov 2005 21:12:04 +0000 (GMT) X-Greylist: from auto-whitelisted by SQLgrey- Received: from smtp101.rog.mail.re2.yahoo.com (smtp101.rog.mail.re2.yahoo.com [206.190.36.79]) by svr1.postgresql.org (Postfix) with SMTP id 18F2AD6D50 for ; Fri, 18 Nov 2005 17:11:59 -0400 (AST) Received: (qmail 75426 invoked from network); 18 Nov 2005 21:12:00 -0000 Received: from unknown (HELO phlogiston.dydns.org) (a.sullivan@rogers.com@209.222.54.227 with login) by smtp101.rog.mail.re2.yahoo.com with SMTP; 18 Nov 2005 21:12:00 -0000 Received: by phlogiston.dydns.org (Postfix, from userid 1000) id 3004E40B6; Fri, 18 Nov 2005 16:11:59 -0500 (EST) Date: Fri, 18 Nov 2005 16:11:59 -0500 From: Andrew Sullivan To: pgsql-admin@postgresql.org Subject: Re: fsm allocation Message-ID: <20051118211159.GD29354@phlogiston.dyndns.org> References: Mime-Version: 1.0 Content-Type: text/plain; charset=us-ascii Content-Disposition: inline In-Reply-To: User-Agent: Mutt/1.5.9i X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, score=0 required=5 tests=[AWL=0.000] X-Spam-Score: 0 X-Spam-Level: X-Archive-Number: 200511/249 X-Sequence-Number: 19622 On Thu, Nov 17, 2005 at 08:20:12AM -0500, Colton A Smith wrote: > By the way, what exactly is the 'free map space' anyway? And why does > it need so much space? There's a useful description in the docs, section 17.4.2 (for 8.1). I'd look at that. Your usage might not be stable right now because your FSM was wrong to begin with. My bet is that you need to do either a VACUUM FULL or a dump and reload before twiddling these settings much more. You also maybe want either autovacuum, or to increase the frequency of your vacuums. Given the database size you discussed, I can't believe you really need that much space. A -- Andrew Sullivan | ajs@crankycanuck.ca In the future this spectacle of the middle classes shocking the avant- garde will probably become the textbook definition of Postmodernism. --Brad Holland