Received: from localhost (unknown [200.46.204.184]) by postgresql.org (Postfix) with ESMTP id 9EB042E3020 for ; Tue, 5 Feb 2008 21:54:05 -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 00749-06 for ; Tue, 5 Feb 2008 21:53:54 -0400 (AST) Received: from noel.decibel.org (noel.decibel.org [67.100.216.10]) by postgresql.org (Postfix) with ESMTP id 1CD662E07DD for ; Tue, 5 Feb 2008 21:54:01 -0400 (AST) Received: by noel.decibel.org (Postfix, from userid 1001) id EB5A856479; Wed, 6 Feb 2008 01:53:59 +0000 (UTC) Received: (hashcash-sendmail, from uid 1001); Tue, 5 Feb 2008 19:53:52 -0600 Date: Tue, 5 Feb 2008 19:53:52 -0600 From: Decibel! To: Tom Lane Cc: "Joshua D. Drake" , Dimitri Fontaine , pgsql-admin@postgresql.org, Alvaro Herrera , Chris Hoover , Bruce Momjian Subject: Re: Where to find information on the new HOT tables? Message-ID: <20080206015351.GM1212@decibel.org> References: <1d219a6f0802051142k882827cyd38ea7a3d7c1e4ea@mail.gmail.com> <200802052213.41185.dfontaine@hi-media.com> <28211.1202247311@sss.pgh.pa.us> <200802052314.02679.dfontaine@hi-media.com> <20080205142535.12e5c28e@jd-laptop> <29236.1202252251@sss.pgh.pa.us> MIME-Version: 1.0 Content-Type: multipart/signed; micalg=pgp-sha1; protocol="application/pgp-signature"; boundary="Dv8qlObl6UganL0I" Content-Disposition: inline In-Reply-To: <29236.1202252251@sss.pgh.pa.us> X-Operating-System: FreeBSD 6.1-RELEASE-p10 amd64 X-Distributed: Join the Effort! http://www.distributed.net User-Agent: Mutt/1.5.13 (2006-08-11) X-Hashcash: 1:20:080206:tgl@sss.pgh.pa.us::8/7F5J1x7clgMZbn:00000000000000000000 0000000000000000000000004fde X-Hashcash: 1:20:080206:jd@commandprompt.com::/iJMniSzUxEOZ0tt:00000000000000000 00000000000000000000000046m8 X-Hashcash: 1:20:080206:dfontaine@hi-media.com::OY5cbfNV8YBvo7yL:000000000000000 0000000000000000000000000fhU X-Hashcash: 1:20:080206:pgsql-admin@postgresql.org::U9NVdUUkgMcOXVDq:00000000000 000000000000000000000000149d X-Hashcash: 1:20:080206:alvherre@commandprompt.com::UKs40340vkakWRFM:00000000000 000000000000000000000000A0Le X-Hashcash: 1:20:080206:revoohc@gmail.com::1wnmqF5PwiRtd16s:00000000000000000000 0000000000000000000000003hTP X-Hashcash: 1:20:080206:bruce@momjian.us::fTnjuuCycSdgbon2:03FV4 X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200802/46 X-Sequence-Number: 28120 --Dv8qlObl6UganL0I Content-Type: text/plain; charset=unknown-8bit Content-Disposition: inline Content-Transfer-Encoding: quoted-printable On Tue, Feb 05, 2008 at 05:57:31PM -0500, Tom Lane wrote: > "Joshua D. Drake" writes: > > 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. , >=20 > > 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 > We have no user-facing documentation on TOAST, either, which would seem > to me to be at least as much of a candidate for people to custom-design > their databases around. In practice I don't think anyone does. Uh... http://www.postgresql.org/docs/8.3/interactive/storage-toast.html --=20 Decibel!, aka Jim C. Nasby, Database Architect decibel@decibel.org=20 Give your computer some brain candy! www.distributed.net Team #1828 --Dv8qlObl6UganL0I Content-Type: application/pgp-signature Content-Disposition: inline -----BEGIN PGP SIGNATURE----- Version: GnuPG v2.0.3 (FreeBSD) iD8DBQFHqRMvdO30qud8SkgRAj07AKCNb3E9kAjV3ZJkkDqIT03dbKB3zwCg48mN FF5n71WOvh0PePuLur/swRo= =sIyM -----END PGP SIGNATURE----- --Dv8qlObl6UganL0I--