Postgres Pro
Downloads
Home   >   mailing lists

Re: Where to find information on the new HOT tables? - Mailing list pgsql-admin

From Chris Hoover
Subject Re: Where to find information on the new HOT tables?
Date
Msg-id 1d219a6f0802080501m442cfd83y1bcb38087fcba61b@mail.gmail.com
Whole thread Raw
In response to Re: Where to find information on the new HOT tables?  (Alvaro Herrera <alvherre@commandprompt.com>)
Responses Re: Where to find information on the new HOT tables?  (Bruce Momjian <bruce@momjian.us>)
List pgsql-admin
Tree view


On Feb 7, 2008 6:48 PM, Alvaro Herrera <alvherre@commandprompt.com> 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.

Chris


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

pgsql-admin by date:

Previous
From: n0g0013
Date:
Subject: Re: Postgres 8.2 install on solaris 10
Next
From: "PostgreSql"
Date:
Subject: Queriy results erratic on Linux