Received: from localhost (unknown [200.46.204.183]) by postgresql.org (Postfix) with ESMTP id 2E6BC2E0077 for ; Wed, 6 Feb 2008 06:20:19 -0400 (AST) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.183]) (amavisd-maia, port 10024) with ESMTP id 16205-08 for ; Wed, 6 Feb 2008 06:20:11 -0400 (AST) Received: from easy2.in-chemnitz.de (easy2.in-chemnitz.de [88.198.17.232]) by postgresql.org (Postfix) with ESMTP id A0CC62E0057 for ; Wed, 6 Feb 2008 06:20:10 -0400 (AST) Received: from localhost (localhost [127.0.0.1]) by easy2.in-chemnitz.de (Postfix) with ESMTP id 86D14B289B for ; Wed, 6 Feb 2008 11:20:08 +0100 (CET) Received: from easy2.in-chemnitz.de ([127.0.0.1]) by localhost (easy.in-chemnitz.de [127.0.0.1]) (amavisd-new, port 10024) with ESMTP id j8N0q-O7j4AA for ; Wed, 6 Feb 2008 11:20:08 +0100 (CET) Received: by easy2.in-chemnitz.de (Postfix, from userid 1013) id 751F6B2675; Wed, 6 Feb 2008 11:20:08 +0100 (CET) Date: Wed, 6 Feb 2008 11:20:08 +0100 From: Tino Schwarze To: pgsql-admin@postgresql.org Subject: Re: Where to find information on the new HOT tables? Message-ID: <20080206102008.GD16997@easy2.in-chemnitz.de> References: <1d219a6f0802051142k882827cyd38ea7a3d7c1e4ea@mail.gmail.com> <36e682920802052145lc3b566cr1facc1cd76847a5a@mail.gmail.com> <2827.1202278590@sss.pgh.pa.us> <200802061011.11929.dfontaine@hi-media.com> MIME-Version: 1.0 Content-Type: text/plain; charset=iso-8859-1 Content-Disposition: inline Content-Transfer-Encoding: 8bit In-Reply-To: <200802061011.11929.dfontaine@hi-media.com> User-Agent: Mutt/1.5.13 (2006-08-11) X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200802/56 X-Sequence-Number: 28130 Hi there, On Wed, Feb 06, 2008 at 10:11:09AM +0100, Dimitri Fontaine wrote: > > I'm really not seeing the case for user-level documentation of HOT, > > when for instance most of the planner's optimization behavior is not > > so documented. > > In my POV, the case for HOT to appear in the documentation as been made by the > PR and Presskit. They both announce HOT to be a major performance addition in > 8.3 that users will want to benefit from. Now we have to tell some more to > the users, I think we want to answer those two basic questions: > - How do I check that I'm using HOT? (you don't, transparent feature, blah) > - What's HOT is so good about compared to how PostgreSQL used to work? > > My proposal was about answering this without requiring the user to be capable > of understanding internals and 'developer topics'. Which might be pretty difficult, if it's an internal feature. But a short HOT-FAQ would be great, something like this: - What is HOT? ... - How do I exploit it? Make sure that ... - When will HOT kick in? If ... and ... and ... > 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. Yes, I praise it, too! Even though it needs some reading and thinking and reading and thinking to understand, e.g. the internals of VACUUM or freeze_max_age etc., the documentation is very helpful to understand what's going on. > To ease PostgreSQL newbies manual grasping, I certainly don't think it will > need shortening the documentation. Maybe there could be quickstart chapters or HOWTOs. Bye, Tino. -- www.craniosacralzentrum.de www.spiritualdesign-chemnitz.de Tino Schwarze * Lortzingstraße 21 * 09119 Chemnitz