Received: from localhost (unknown [200.46.204.183]) by postgresql.org (Postfix) with ESMTP id 368E92E42F1 for ; Fri, 8 Feb 2008 12:02:49 -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 95472-01-4 for ; Fri, 8 Feb 2008 12:02:43 -0400 (AST) Received: from momjian.us (momjian.us [70.90.9.53]) by postgresql.org (Postfix) with ESMTP id D56122E43EE for ; Fri, 8 Feb 2008 12:02:34 -0400 (AST) Received: (from bruce@localhost) by momjian.us (8.11.6/8.11.6) id m18G1gn01904; Fri, 8 Feb 2008 11:01:42 -0500 (EST) From: Bruce Momjian Message-Id: <200802081601.m18G1gn01904@momjian.us> Subject: Re: Where to find information on the new HOT tables? In-Reply-To: <1d219a6f0802080501m442cfd83y1bcb38087fcba61b@mail.gmail.com> To: Chris Hoover Date: Fri, 8 Feb 2008 11:01:42 -0500 (EST) CC: Alvaro Herrera , Dimitri Fontaine , pgsql-admin@postgresql.org X-Mailer: ELM [version 2.4ME+ PL124 (25)] MIME-Version: 1.0 Content-Transfer-Encoding: 7bit Content-Type: text/plain; charset="US-ASCII" X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200802/98 X-Sequence-Number: 28172 Chris Hoover wrote: > On Feb 7, 2008 6:48 PM, Alvaro Herrera wrote: > > > Bruce Momjian escribi?: > > > 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=1.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. Sure, we could do that, but it is very technical. I would say 99% of users don't need to know those details. -- Bruce Momjian http://momjian.us EnterpriseDB http://postgres.enterprisedb.com + If your life is a hard drive, Christ can be your backup. +