Received: from localhost (unknown [200.46.204.184]) by postgresql.org (Postfix) with ESMTP id C71BF2E30CF for ; Wed, 6 Feb 2008 09:42:45 -0400 (AST) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.184]) (amavisd-maia, port 10024) with ESMTP id 52836-02 for ; Wed, 6 Feb 2008 09:42:34 -0400 (AST) Received: from wr-out-0506.google.com (wr-out-0506.google.com [64.233.184.235]) by postgresql.org (Postfix) with ESMTP id 8017C2E2368 for ; Wed, 6 Feb 2008 09:42:41 -0400 (AST) Received: by wr-out-0506.google.com with SMTP id 71so2912272wri.5 for ; Wed, 06 Feb 2008 05:42:40 -0800 (PST) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=gamma; 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=lqI+Yq+ZzWgAckmRTfXbwOBG/N+U5YZfmzFJFK53G0s=; b=KEeb4osrqwzYfErPqFUfCArcf6OmKqqnaVuBPNXaz6ufEOzWEArJky7CRPnZ63vr2uiMgy0aTnXev5P7uOW5U/hhogW9WkpV56tnB8bfhekz97n26VkCPlgNa3KYDIbVdlt/LM6x4QK8EcsSDl1CdRXBgmftk/deLitb8KMtDzk= DomainKey-Signature: a=rsa-sha1; c=nofws; d=gmail.com; s=gamma; h=subject:from:reply-to:to:in-reply-to:references:content-type:date:message-id:mime-version:x-mailer:content-transfer-encoding; b=urCqJidQm9BiT88cP2CjZlKsD8201bv1qk8+m55+SsoZur5zcPPjyUo/oqE59Vpx5HTep53lTOYwdeXNh4oCGS9IgI7WJ1zxKI0lkmNfKsqQuP4FGCKlIYqw3K4Pp2a9fJum+LRsypNalvTGFZmRWXyoLIv0vfzFuJu8deG7NPA= Received: by 10.142.212.19 with SMTP id k19mr5223711wfg.224.1202305359313; Wed, 06 Feb 2008 05:42:39 -0800 (PST) Received: from ?192.168.1.212? ( [206.114.45.107]) by mx.google.com with ESMTPS id n44sm28514528pyh.26.2008.02.06.05.42.38 (version=SSLv3 cipher=RC4-MD5); Wed, 06 Feb 2008 05:42:38 -0800 (PST) Subject: Re: Where to find information on the new HOT tables? From: Adam Tauno Williams Reply-To: adamtaunowilliams@gmail.com To: pgsql-admin In-Reply-To: <200802061011.11929.dfontaine@hi-media.com> References: <1d219a6f0802051142k882827cyd38ea7a3d7c1e4ea@mail.gmail.com> <36e682920802052145lc3b566cr1facc1cd76847a5a@mail.gmail.com> <2827.1202278590@sss.pgh.pa.us> <200802061011.11929.dfontaine@hi-media.com> Content-Type: text/plain Date: Wed, 06 Feb 2008 08:43:32 -0500 Message-Id: <1202305412.5753.13.camel@WM_ADAM1.morrison.iserv.net> Mime-Version: 1.0 X-Mailer: Evolution 2.12.0 Content-Transfer-Encoding: 7bit X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200802/58 X-Sequence-Number: 28132 > I'd also like to add that people judging documentation effectiveness by its > length are certainly not real users of it. I've yet to meet a PostgreSQL user > who doesn't praise the product documentation, even if newcomers often need > some time to be able to understand where to find what. The Tsearch enabled > website has been a huge improvement here. > To ease PostgreSQL newbies manual grasping, I certainly don't think it will > need shortening the documentation. Agree, 125%. There are quick start guides for newbies, and a quadrillion goofy little howtos (although I've come to have some contempt for the whole "howto" category). I chose PostgreSQL over that-other-database because it had useful documentation and smelled like a "real" database. I'm also an Informix/DB2 DBA and I think the documentation is very good, there can't be too much documentation so anyone judging on length just needs to be dope-slapped. [And I've personally used the TOAST section to tune a database that uses lots of large values]. The current manual is divided into sections, including a tutorial so I just don't see any grounds for a complexity complaint at all. A new user should, of course, wade into the "System Administration" section with some sense of trepidation. My experience [now extensive] with users of that-other-database is that they will *ALWAYS* claim *ANYTHING* else is too complicated [most of them have never used anything else] before starting to explain why they have two storage backends and the merits between MyISAM and InnoDb; Sheeesh! It is important to distinguish between informed criticism and the triumvirate of laziness, fanboy FUD, and outright whining. OTOH, I think a paragraph explaining how HOT causes performance to differ from previous versions would be sufficient. It isn't really a user, or even an admin, tunable AFAIK. It is just an inherent good in the current version - but since it was mentioned allot in release announcements it merits some mention in the docs. Adam Tauno Williams, Network & Systems Administrator Consultant - http://www.whitemiceconsulting.com Developer - http://www.opengroupware.org