Received: from localhost (unknown [200.46.204.191]) by postgresql.org (Postfix) with ESMTP id 18CA79FA5E6 for ; Fri, 14 Sep 2007 11:00:43 -0300 (ADT) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.191]) (amavisd-maia, port 10024) with ESMTP id 40741-05 for ; Fri, 14 Sep 2007 11:00:39 -0300 (ADT) X-Greylist: domain auto-whitelisted by SQLgrey-1.7.5 Received: from wx-out-0506.google.com (wx-out-0506.google.com [66.249.82.228]) by postgresql.org (Postfix) with ESMTP id 561CB9F9C7F for ; Fri, 14 Sep 2007 11:00:39 -0300 (ADT) Received: by wx-out-0506.google.com with SMTP id r21so808121wxc for ; Fri, 14 Sep 2007 07:00:38 -0700 (PDT) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=beta; h=domainkey-signature:received:received:subject:from:reply-to:to:in-reply-to:references:content-type:date:message-id:mime-version:x-mailer:content-transfer-encoding; bh=4dGlX1B2+USXUVowuigbfPwzGBCBqmf4moGehebia/Q=; b=VtBiuyNynfNbX7EsrDfat+nvYkznQ3ANuVbD+Mb7awiZmubl62NSsfYE/QshMtdtXAuHK3huCW9tJUx4EZ+XgYE5x9dVwPm20eEQ+khsrrYndXPjB1gwxcOqkrRVha9NgMoFNY4tzju/X+VXChjS0ifsEDip9AC6zU7V75jWLf4= DomainKey-Signature: a=rsa-sha1; c=nofws; d=gmail.com; s=beta; h=received:subject:from:reply-to:to:in-reply-to:references:content-type:date:message-id:mime-version:x-mailer:content-transfer-encoding; b=G9j0D/2eAZ7/uU1fE8pw38uOm679fde8Kn2l7muoY/rrYxxKm43pMrFbrHGZRVwGkOv7/iLw2gJi8+nZvZuRwqmCPIvGGI9SqLUXjCkppG677KGVV/+y9BYhd60IsTF5oUX+GGZK5dabla/culU4w+7KZ3jYHXZo4B63PNcZNq4= Received: by 10.100.32.1 with SMTP id f1mr2668728anf.1189778438106; Fri, 14 Sep 2007 07:00:38 -0700 (PDT) Received: from ?192.168.1.212? ( [206.114.45.106]) by mx.google.com with ESMTPS id 8sm764547nzn.2007.09.14.07.00.32 (version=SSLv3 cipher=RC4-MD5); Fri, 14 Sep 2007 07:00:34 -0700 (PDT) Subject: Re: [Again] Postgres performance problem From: Adam Tauno Williams Reply-To: adamtaunowilliams@gmail.com To: pgsql-performance@postgresql.org In-Reply-To: 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> <81405E66-5110-4DA8-B315-D28EA124CDB6@myemma.com> Content-Type: text/plain Date: Fri, 14 Sep 2007 10:00:59 -0400 Message-Id: <1189778459.5199.5.camel@aleph.wmmi.net> Mime-Version: 1.0 X-Mailer: Evolution 2.8.2 Content-Transfer-Encoding: 7bit X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200709/276 X-Sequence-Number: 26821 > > Isn't that the point of the documentation? I mean, if the existing, > > official manual has been demonstrated (through countless mailing list > > help requests) to not sufficiently explain a given topic, shouldn't > > it be revised? Or it proves that no one bothers to read the docs. > > One thing that might help is a hyperlinked glossary > > so that people reading through the documentation can go straight to > > the postgres definition of dead tuple, index bloat, etc. > Yes and no. The official docs are more of a technical specification. > Short, simple and to the point so that if you know mostly what you're > doing you don't have to wade through a long tutorial to find the > answer. I find MySQL's documentation frustrating as hell because I > can never find just the one thing I wanna look for. Yes! MySQL documentation is maddening. This is why, I suspect, for products like Informix and DB2 IBM publishes two manuals (or roughly equivalent to two manuals): a "guide" and a "reference". > written as a tutorial. I.e. I have to pay the "stupid tax" when I > read their docs. Yep. > What I want to do is two fold. 1: fix the technical docs so they have > better explanations of each of the topics, without turning them into > huge tutorials. 2: Write a vacuuming tutorial that will be useful > should someone be new to postgresql and need to set up their system. > I think the tutorial should be broken into at least two sections, a > quick start guide and an ongoing maintenance and tuning section.