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

Поиск
Список
Период
Сортировка
От Alvaro Herrera
Тема Re: Where to find information on the new HOT tables?
Дата
Msg-id 20080206161202.GC17371@alvh.no-ip.org
обсуждение исходный текст
Ответ на Re: Where to find information on the new HOT tables?  (Adam Tauno Williams <adamtaunowilliams@gmail.com>)
Список 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

В списке pgsql-admin по дате отправления:

Предыдущее
От: Adam Tauno Williams
Дата:
Сообщение: Re: Where to find information on the new HOT tables?
Следующее
От: ttw+pgsql@cobbled.net
Дата:
Сообщение: Re: Postgres 8.2 install on solaris 10