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

From Adam Tauno Williams
Subject Re: Where to find information on the new HOT tables?
Date
Msg-id 1202314034.5753.28.camel@WM_ADAM1.morrison.iserv.net
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?  (Alvaro Herrera <alvherre@commandprompt.com>)
List pgsql-admin
> > > I don't think such a document already exists, even rtfm_please doesn't know
> > > about any as of now.
> > The reason there isn't one is it doesn't need one; it's an
> > implementation detail not a user-visible feature.
> One reason to think it needs to be explained is that it affects how you
> plan for VACUUM.  In tables where HOT is in charge of a large part of
> cleanup, you need to do a lot less vacuuming than you were for 8.2.  In
> that sense it is very much user-visible.

Wouldn't the thresholds in the auto-vaccuming make that adjustment
transparent?


pgsql-admin by date:

Previous
From: Alvaro Herrera
Date:
Subject: Re: Where to find information on the new HOT tables?
Next
From: Alvaro Herrera
Date:
Subject: Re: Where to find information on the new HOT tables?