Received: from localhost (unknown [200.46.204.184]) by postgresql.org (Postfix) with ESMTP id 163029F94F8 for ; Fri, 14 Sep 2007 04:19:57 -0300 (ADT) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.184]) (amavisd-maia, port 10024) with ESMTP id 61792-07 for ; Fri, 14 Sep 2007 04:19:40 -0300 (ADT) X-Greylist: from auto-whitelisted by SQLgrey-1.7.5 Received: from westnet.com (westnet.com [216.187.52.2]) by postgresql.org (Postfix) with ESMTP id 5FA929F99E9 for ; Fri, 14 Sep 2007 04:19:52 -0300 (ADT) Received: from westnet.com (localhost [127.0.0.1]) by westnet.com (8.14.0/8.14.0) with ESMTP id l8E7JpFX026335 for ; Fri, 14 Sep 2007 03:19:51 -0400 (EDT) Received: from localhost (gsmith@localhost) by westnet.com (8.14.0/8.13.2/Submit) with ESMTP id l8E7JpdL026329 for ; Fri, 14 Sep 2007 03:19:51 -0400 (EDT) X-Authentication-Warning: westnet.com: gsmith owned process doing -bs Date: Fri, 14 Sep 2007 03:19:51 -0400 (EDT) From: Greg Smith X-X-Sender: gsmith@westnet.com cc: pgsql-performance@postgresql.org Subject: Re: [Again] Postgres performance problem In-Reply-To: Message-ID: References: <46E636CB.8080008@rentalia.com> <43393.192.121.104.48.1189495883.squirrel@zigo.dhs.org> <46E64891.9080005@rentalia.com> <20070911225242.GG38801@decibel.org> <46E79865.906@rentalia.com> MIME-Version: 1.0 Content-Type: TEXT/PLAIN; charset=US-ASCII; format=flowed X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200709/269 X-Sequence-Number: 26814 On Thu, 13 Sep 2007, Scott Marlowe wrote: > I think both things are needed actually. The current docs were > started back when pg 7.2 roamed the land, and they've been updated a > bit at a time... No argument here that ultimately the documentation needs to be updated as well. I was just suggesting what I've been thinking about as the path of least resistance to move in that direction. Updating the documentation is harder to do because of the build process involved. It's easier to write something new that addresses the deficiencies, get that right, and then merge it into the documentation when it's stable. After the main new content is done, then it's easier to sweep back through the existing material and clean things up. > Which leads me to thinking that we then need a simple tutorial on > vacuuming to include the free space map, vacuum, vacuum analyze, > vacuum full, and the autovacuum daemon. Right, that's the sort of thing that's missing right now, and I think that would be more useful to newbies than correcting the documentation that's already there. Also: if you don't have a public working area to assemble this document at, I've set a precedent of sorts that it's OK to put working material like this onto the PG developer's wiki at http://developer.postgresql.org/ as long as your stated intention is ultimately to move it off of there once it's complete. In addition to providing a nice set of tools for working the text (presuming you're comfortable with Wiki syntax) that will get you a pool of reviewers/contributors who can make changes directly rather than you needing to do all the work yourself. -- * Greg Smith gsmith@gregsmith.com http://www.gregsmith.com Baltimore, MD