| From: | Alvaro Herrera <alvherre(at)commandprompt(dot)com> |
|---|---|
| To: | Adam Tauno Williams <adamtaunowilliams(at)gmail(dot)com> |
| Cc: | pgsql-admin <pgsql-admin(at)postgresql(dot)org> |
| Subject: | Re: Where to find information on the new HOT tables? |
| Date: | 2008-02-06 16:12:02 |
| Message-ID: | 20080206161202.GC17371@alvh.no-ip.org |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-admin |
Adam Tauno Williams escribió:
> > > > 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?
For people that use autovacuum, yes, it would, but not everybody does.
--
Alvaro Herrera http://www.CommandPrompt.com/
PostgreSQL Replication, Consulting, Custom Development, 24x7 support
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Bhella Paramjeet-PFCW67 | 2008-02-06 17:40:15 | Re: Postgres 8.2 install on solaris 10 |
| Previous Message | Adam Tauno Williams | 2008-02-06 16:07:14 | Re: Where to find information on the new HOT tables? |