Re: Where to find information on the new HOT tables?

From: Adam Tauno Williams <adamtaunowilliams(at)gmail(dot)com>
To: pgsql-admin <pgsql-admin(at)postgresql(dot)org>
Subject: Re: Where to find information on the new HOT tables?
Date: 2008-02-06 16:07:14
Message-ID: 1202314034.5753.28.camel@WM_ADAM1.morrison.iserv.net
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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?

In response to

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message Alvaro Herrera 2008-02-06 16:12:02 Re: Where to find information on the new HOT tables?
Previous Message Alvaro Herrera 2008-02-06 15:40:22 Re: Where to find information on the new HOT tables?