Received: from localhost (unknown [200.46.204.184]) by postgresql.org (Postfix) with ESMTP id 54CBC2E02A1 for ; Thu, 7 Feb 2008 11:53:04 -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 34535-07 for ; Thu, 7 Feb 2008 11:52:31 -0400 (AST) Received: from mailsrv1.zmi.at (mailsrv1.zmi.at [212.69.162.198]) by postgresql.org (Postfix) with ESMTP id C49042E006C for ; Thu, 7 Feb 2008 11:52:40 -0400 (AST) Received: from mailsrv.i.zmi.at (85-125-129-125.neutorgasse.xdsl-line.inode.at [85.125.129.125]) (using TLSv1 with cipher DHE-RSA-AES256-SHA (256/256 bits)) (Client CN "mailsrv.i.zmi.at", Issuer "mailsrv.i.zmi.at" (not verified)) by mailsrv1.zmi.at (Postfix) with ESMTP id 868DACD7 for ; Thu, 7 Feb 2008 16:52:36 +0100 (CET) Received: from saturn.i.zmi.at (saturn.i.zmi.at [10.0.0.2]) by mailsrv.i.zmi.at (Postfix) with ESMTP id BF3FFBF0A for ; Thu, 7 Feb 2008 16:52:41 +0100 (CET) From: Michael Monnerie Organization: it-management http://it-management.at To: pgsql-admin@postgresql.org Subject: Re: Where to find information on the new HOT tables? Date: Thu, 7 Feb 2008 16:52:35 +0100 User-Agent: KMail/1.9.6 (enterprise 20070904.708012) References: <85978993146E1A4AA9CC4B2945CAFC940258348E@exch-be.terma.com> In-Reply-To: <85978993146E1A4AA9CC4B2945CAFC940258348E@exch-be.terma.com> MIME-Version: 1.0 Content-Type: multipart/signed; boundary="nextPart1873110.HoxAOvCese"; protocol="application/pgp-signature"; micalg=pgp-sha1 Content-Transfer-Encoding: 7bit Message-Id: <200802071652.36258@zmi.at> X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200802/76 X-Sequence-Number: 28150 --nextPart1873110.HoxAOvCese Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable Content-Disposition: inline I let Hans' full e-mail quoted here because it's absolutely true: It's=20 the best documentation available, and that's why we always preferred=20 PostgreSQL over that other - ehrm - "database" MySQL. And of course=20 because it's really a DB ;-) And yes, I'd love even more docu for EXPLAIN, and howto optimize the DB=20 in general. Can there ever be enough detail? Those who don't understand=20 it don't have to read it. mfg zmi On Donnerstag, 7. Februar 2008 Hans Guijt wrote: > On the subject of documentation I'd like to say this: I find > PostgreSQL's documentation to be truly excellent (both in > accessibility and depth), and it is one of the main reasons why we > use PostgreSQL in our projects (the quality of the software itself is > of course the other reason). > > I certainly wouldn't mind explanations of 'internal' features on a > user level; as others have stated, this may be helpful in > understanding the output of EXPLAIN, as a means of building better > databases, or even just because we are interested but not quite so > much that we want to read source code. And I agree with earlier > posters that, now that HOT has been pushed as a great new feature, it > should be properly explained. > > People who complain about the PostgreSQL documentation need to wake > up: the documentation of PostgreSQL is one of the best, if not the > best, I've ever seen for an open source project, and other projects > should take it as a shining example of how things should be done. =2D-=20 // Michael Monnerie, Ing.BSc ----- http://it-management.at // Tel: 0676/846 914 666 .network.your.ideas. // PGP Key: "curl -s http://zmi.at/zmi.asc | gpg --import" // Fingerprint: AC19 F9D5 36ED CD8A EF38 500E CE14 91F7 1C12 09B4 // Keyserver: www.keyserver.net Key-ID: 1C1209B4 --nextPart1873110.HoxAOvCese Content-Type: application/pgp-signature; name=signature.asc Content-Description: This is a digitally signed message part. -----BEGIN PGP SIGNATURE----- Version: GnuPG v2.0.4-svn0 (GNU/Linux) iD8DBQBHqylEzhSR9xwSCbQRAl15AJ9cOSece5ESyDaEDuuURkOopDgmhACfVrQ2 YgNhlFb5XiN2el5YSpcvxjg= =BRWh -----END PGP SIGNATURE----- --nextPart1873110.HoxAOvCese--