Received: from localhost (unknown [200.46.204.184]) by postgresql.org (Postfix) with ESMTP id D3C722E3EEC for ; Tue, 5 Feb 2008 16:22:11 -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 85738-08 for ; Tue, 5 Feb 2008 16:22:05 -0400 (AST) Received: from lists.commandprompt.com (host-159.commandprompt.net [207.173.203.159]) by postgresql.org (Postfix) with ESMTP id 7B4422E3480 for ; Tue, 5 Feb 2008 16:22:08 -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 m15KMFgL001113 (version=TLSv1/SSLv3 cipher=DHE-RSA-AES256-SHA bits=256 verify=NO); Tue, 5 Feb 2008 12:22:16 -0800 Date: Tue, 5 Feb 2008 12:21:58 -0800 From: "Joshua D. Drake" To: "Chris Hoover" Cc: "Bruce Momjian" , "pgsql-admin@postgresql.org Admin" Subject: Re: Where to find information on the new HOT tables? Message-ID: <20080205122158.253e4a71@jd-laptop> In-Reply-To: <1d219a6f0802051211o4814d979rdc988c2ad60b81d0@mail.gmail.com> References: <1d219a6f0802051142k882827cyd38ea7a3d7c1e4ea@mail.gmail.com> <200802051953.m15JrgJ00998@momjian.us> <1d219a6f0802051211o4814d979rdc988c2ad60b81d0@mail.gmail.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_/vQ3C5n0ZkFet3hcUJDuhfx6"; 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 12:22:16 -0800 (PST) X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200802/37 X-Sequence-Number: 28111 --Sig_/vQ3C5n0ZkFet3hcUJDuhfx6 Content-Type: text/plain; charset=US-ASCII Content-Transfer-Encoding: quoted-printable On Tue, 5 Feb 2008 15:11:49 -0500 "Chris Hoover" wrote: > > Ok that's awesome. However, is there any documentation out there > explaining this feature in detail, and how it works, what to expect, > etc. ? As I understand it, the key to hot is that it is only useful if you are updating non-indexed columns. This is great when dealing with things like session tables where you are doing this: UPDATE sessions SET last_active =3D current_date WHERE sid =3D . last_active may not indexed. 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_/vQ3C5n0ZkFet3hcUJDuhfx6 Content-Type: application/pgp-signature; name=signature.asc Content-Disposition: attachment; filename=signature.asc -----BEGIN PGP SIGNATURE----- Version: GnuPG v1.4.6 (GNU/Linux) iD8DBQFHqMVmATb/zqfZUUQRAsDpAJ4qESX5OgyoiIzdCEqw22r7JuT2SwCgrrm+ b3JQSIwG0SrL5+BV9dnSfqU= =ZFfd -----END PGP SIGNATURE----- --Sig_/vQ3C5n0ZkFet3hcUJDuhfx6--