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 6FA569DC81C for ; Tue, 17 Jan 2006 19:11:25 -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 57720-05 for ; Tue, 17 Jan 2006 19:11:25 -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 EBA8D9DC80F for ; Tue, 17 Jan 2006 19:11:20 -0400 (AST) Received: by noel.decibel.org (Postfix, from userid 1001) id 4E3183982E; Tue, 17 Jan 2006 17:11:23 -0600 (CST) Date: Tue, 17 Jan 2006 17:11:23 -0600 From: "Jim C. Nasby" To: Scott Marlowe Cc: pgsql-docs@postgresql.org Subject: Re: vacuum and routine maintenance docs Message-ID: <20060117231123.GJ17896@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/29 X-Sequence-Number: 3419 Sounds good. The articles are part of a Pervasive newsletter, hosted on pervasive-postgres.com, but they can get posted else where with proper attribution. 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. > > On Tue, 2006-01-17 at 16:49, Jim C. Nasby wrote: > > Before you 'put pen to paper', I have two articles that you should look > > at. One is on FSM, the other is more about MVCC from the standpoint of > > why we use it and why it means needing to vacuum. I don't have the URL's > > handy here, but I can post them tomorrow. -- 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