Received: from localhost (unknown [200.46.204.183]) by postgresql.org (Postfix) with ESMTP id 2F3172E3E0E for ; Tue, 5 Feb 2008 18:26:44 -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 36109-01-8 for ; Tue, 5 Feb 2008 18:26:38 -0400 (AST) Received: from lists.commandprompt.com (host-159.commandprompt.net [207.173.203.159]) by postgresql.org (Postfix) with ESMTP id 3502A2E4061 for ; Tue, 5 Feb 2008 18:26:13 -0400 (AST) Received: from jd-laptop (cmdalert.com [69.55.229.115]) (authenticated bits=0) by lists.commandprompt.com (8.13.8/8.13.8) with ESMTP id m15MPp70005479 (version=TLSv1/SSLv3 cipher=DHE-RSA-AES256-SHA bits=256 verify=NO); Tue, 5 Feb 2008 14:25:55 -0800 Date: Tue, 5 Feb 2008 14:25:35 -0800 From: "Joshua D. Drake" To: Dimitri Fontaine Cc: pgsql-admin@postgresql.org, Tom Lane , Alvaro Herrera , Chris Hoover , Bruce Momjian Subject: Re: Where to find information on the new HOT tables? Message-ID: <20080205142535.12e5c28e@jd-laptop> In-Reply-To: <200802052314.02679.dfontaine@hi-media.com> References: <1d219a6f0802051142k882827cyd38ea7a3d7c1e4ea@mail.gmail.com> <200802052213.41185.dfontaine@hi-media.com> <28211.1202247311@sss.pgh.pa.us> <200802052314.02679.dfontaine@hi-media.com> Organization: Joshua D. Drake X-Mailer: Claws Mail 3.2.0 (GTK+ 2.12.0; i486-pc-linux-gnu) Mime-Version: 1.0 Content-Type: multipart/signed; boundary="Sig_/6SBqg698NcBeYtB3GhbqO0Y"; protocol="application/pgp-signature"; micalg=PGP-SHA1 X-Greylist: Sender succeeded SMTP AUTH, not delayed by milter-greylist-4.0 (lists.commandprompt.com [207.173.203.159]); Tue, 05 Feb 2008 14:25:55 -0800 (PST) X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200802/44 X-Sequence-Number: 28118 --Sig_/6SBqg698NcBeYtB3GhbqO0Y Content-Type: text/plain; charset=UTF-8 Content-Transfer-Encoding: quoted-printable On Tue, 5 Feb 2008 23:13:59 +0100 Dimitri Fontaine wrote: > Le Tuesday 05 February 2008 22:35:11 Tom Lane, vous avez =C3=A9crit=C2=A0: > > The reason there isn't one is it doesn't need one; it's an > > implementation detail not a user-visible feature. , Although it is an implementation detail it is certainly a very user-visible detail. It can and will affect how people design their databases to take advantage of the implementation detail. >=20 > So how do you want us to handle the users questions about how HOT is > good for them and who'd like to have some insights of its inner > working, but don't want to properly learn the internals of PostgreSQL > implementation? We need to write a one page mini-HOWTO on taking advantage of HOT and HOTs limitations. Sincerely, Joshua D. Drake --=20 The PostgreSQL Company since 1997: http://www.commandprompt.com/=20 PostgreSQL Community Conference: http://www.postgresqlconference.org/ Donate to the PostgreSQL Project: http://www.postgresql.org/about/donate PostgreSQL SPI Liaison | SPI Director | PostgreSQL political pundit --Sig_/6SBqg698NcBeYtB3GhbqO0Y Content-Type: application/pgp-signature; name=signature.asc Content-Disposition: attachment; filename=signature.asc -----BEGIN PGP SIGNATURE----- Version: GnuPG v1.4.6 (GNU/Linux) iD8DBQFHqOJfATb/zqfZUUQRAsZyAKCC3HVbCKd4mPv9ErWhkZybYAL4DwCdFLHx jEWqiSjb36TNxME4Gt2Irko= =xBJb -----END PGP SIGNATURE----- --Sig_/6SBqg698NcBeYtB3GhbqO0Y--