X-Original-To: pgsql-docs-postgresql.org@localhost.postgresql.org Received: from localhost (av.hub.org [200.46.204.144]) by postgresql.org (Postfix) with ESMTP id 224379DC9A6 for ; Wed, 18 Jan 2006 18:20:18 -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 19348-01 for ; Wed, 18 Jan 2006 18:20:11 -0400 (AST) X-Greylist: from auto-whitelisted by SQLgrey- Received: from noel.decibel.org (noel.decibel.org [67.100.216.10]) by postgresql.org (Postfix) with ESMTP id C5B7A9DC83F for ; Wed, 18 Jan 2006 18:20:06 -0400 (AST) Received: by noel.decibel.org (Postfix, from userid 1001) id 690F139820; Wed, 18 Jan 2006 16:19:51 -0600 (CST) Date: Wed, 18 Jan 2006 16:19:51 -0600 From: "Jim C. Nasby" To: Scott Marlowe Cc: pgsql-docs@postgresql.org Subject: Re: vacuum and routine maintenance docs Message-ID: <20060118221951.GT17896@pervasive.com> References: <1137518049.25500.27.camel@state.g2switchworks.com> <20060117224941.GI17896@pervasive.com> <1137538769.25500.49.camel@state.g2switchworks.com> Mime-Version: 1.0 Content-Type: text/plain; charset=us-ascii Content-Disposition: inline In-Reply-To: <1137538769.25500.49.camel@state.g2switchworks.com> X-Operating-System: FreeBSD 6.0-RELEASE amd64 X-Distributed: Join the Effort! http://www.distributed.net User-Agent: Mutt/1.5.11 X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, score=0.094 required=5 tests=[AWL=0.094] X-Spam-Score: 0.094 X-Spam-Level: X-Archive-Number: 200601/33 X-Sequence-Number: 3423 On Tue, Jan 17, 2006 at 04:59:29PM -0600, Scott Marlowe wrote: > Thanks. Yeah, I'm thinking more of a very brief mention of what the FSM > is, with a link to the other part of the docs that discuss it. And then > having a link (possibly in both places) or two to more in depth articles > on fsm and fsm tuning. Got the links... http://www.pervasive-postgres.com/lp/newsletters/2005/Insights_opensource_Dec.asp#2 is general info about MVCC and why you need to vacuum. http://www.pervasive-postgres.com/lp/newsletters/2005/Insights_opensource_Nov.asp#3 is all about the FSM (yeah, I kinda put the horse before the cart...) I'm working on finding out if the community can use that text verbatim without attribution, but if nothing else it might provide you with some ideas. -- Jim C. Nasby, Sr. Engineering Consultant jnasby@pervasive.com Pervasive Software http://pervasive.com work: 512-231-6117 vcard: http://jim.nasby.net/pervasive.vcf cell: 512-569-9461