Received: from localhost (unknown [200.46.204.184]) by postgresql.org (Postfix) with ESMTP id D3E902E0336 for ; Fri, 8 Feb 2008 09:02:07 -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 53372-07 for ; Fri, 8 Feb 2008 09:01:39 -0400 (AST) Received: from el-out-1112.google.com (el-out-1112.google.com [209.85.162.182]) by postgresql.org (Postfix) with ESMTP id 059B82E0346 for ; Fri, 8 Feb 2008 09:01:45 -0400 (AST) Received: by el-out-1112.google.com with SMTP id r27so1697964ele.5 for ; Fri, 08 Feb 2008 05:01:44 -0800 (PST) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=gamma; h=domainkey-signature:received:received:message-id:date:from:to:subject:cc:in-reply-to:mime-version:content-type:references; bh=d3IOXGLRJ0CS5DxP294xIZ+XgTyPWqF1fYPPvDJVQCk=; b=MU8Zs5TUKg0xdMjWhi8b1/9CC/zbMsyOdd2TNjjnvfJvqG0FnB40upwnXXNOhVHMByDAG+mxBIxYxiNtnh7sTey9TLAy6Sx8FodKYxiZmVCWbMdTYu4fThbTel1ErSIYIS6SNIf4/4ecD07Rxeu7dxXkv9EAEJGwLrdzqQPAbbk= DomainKey-Signature: a=rsa-sha1; c=nofws; d=gmail.com; s=gamma; h=message-id:date:from:to:subject:cc:in-reply-to:mime-version:content-type:references; b=c+RM6p1TgbMIDRP+8RynO2UdzlRt9KsJFUtcsv2SwWNaPU6ihGgSl58uPcfEMQPDzTz+k1FpahE3SNTozzFaNpN5f6lyjomM1pzNKvxATfYpi/PX7JurtWe2u8J7lGsUm23rkDtuGzDcXy5EuifwELN5JVhiMoVj96Sb3QmdFwY= Received: by 10.151.12.1 with SMTP id p1mr5272859ybi.152.1202475704843; Fri, 08 Feb 2008 05:01:44 -0800 (PST) Received: by 10.150.197.17 with HTTP; Fri, 8 Feb 2008 05:01:44 -0800 (PST) Message-ID: <1d219a6f0802080501m442cfd83y1bcb38087fcba61b@mail.gmail.com> Date: Fri, 8 Feb 2008 08:01:44 -0500 From: "Chris Hoover" To: "Alvaro Herrera" Subject: Re: Where to find information on the new HOT tables? Cc: "Bruce Momjian" , "Dimitri Fontaine" , pgsql-admin@postgresql.org In-Reply-To: <20080207234844.GH23336@alvh.no-ip.org> MIME-Version: 1.0 Content-Type: multipart/alternative; boundary="----=_Part_13502_17449815.1202475704826" References: <200802072100.20093.dfontaine@hi-media.com> <200802072231.m17MVBZ18035@momjian.us> <20080207234844.GH23336@alvh.no-ip.org> X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200802/91 X-Sequence-Number: 28165 ------=_Part_13502_17449815.1202475704826 Content-Type: text/plain; charset=ISO-8859-1 Content-Transfer-Encoding: quoted-printable Content-Disposition: inline On Feb 7, 2008 6:48 PM, Alvaro Herrera wrote: > Bruce Momjian escribi=F3: > > Dimitri Fontaine wrote: > > > > What about Alvaro's concern about manual vacuuming policies editing > wrt to > > > HOT? > > > > I think most people will be using autovacuum, and those who aren't will > > have to realize that HOT makes vacuuming less needed. > > Hmm, and how will they realize it, if they don't understand how HOT > comes into the equation? > How about just adding a "for more information look here link" pointing to http://developer.postgresql.org/cvsweb.cgi/pgsql/src/backend/access/heap= /README.HOT?rev=3D1.2 That is the link Alvaro sent me in the first part of the thread. It was a very good read explaining how HOT works along with the caveats. Chris --=20 Come see how to SAVE money on fuel, decrease harmful emissions, and even make MONEY. Visit http://colafuelguy.mybpi.com and join the revolution! ------=_Part_13502_17449815.1202475704826 Content-Type: text/html; charset=ISO-8859-1 Content-Transfer-Encoding: quoted-printable Content-Disposition: inline

On Feb 7, 2008 6:48 PM, Alvaro Herrera &= lt;alvherre@commandprompt.com= > wrote:
> Dimitri Fontaine wr= ote:

> > What about Alvaro's concern about manual vacuumin= g policies editing wrt to
> > HOT?
>
> I think most pe= ople will be using autovacuum, and those who aren't will
> have to realize that HOT makes vacuuming less needed.

Hmm= , and how will they realize it, if they don't understand how HOT
com= es into the equation?

How about just adding a &quo= t;for more information look here link" pointing to http://developer.postgresql.org/cvsweb.cgi/pg= sql/src/backend/access/heap/README.HOT?rev=3D1.2

That is the link Alvaro sent me in the first part of the thread.  = It was a very good read explaining how HOT works along with the caveats.
Chris


--
Come see how to SAVE= money on fuel, decrease harmful emissions, and even make MONEY.  Visi= t http://colafuelguy.mybpi.com= and join the revolution! ------=_Part_13502_17449815.1202475704826--