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

Поиск
Список
Период
Сортировка
От Adam Tauno Williams
Тема Re: Where to find information on the new HOT tables?
Дата
Msg-id 1202314034.5753.28.camel@WM_ADAM1.morrison.iserv.net
обсуждение исходный текст
Ответ на Re: Where to find information on the new HOT tables?  (Alvaro Herrera <alvherre@commandprompt.com>)
Ответы Re: Where to find information on the new HOT tables?  (Alvaro Herrera <alvherre@commandprompt.com>)
Список 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 по дате отправления:

Предыдущее
От: Alvaro Herrera
Дата:
Сообщение: Re: Where to find information on the new HOT tables?
Следующее
От: Alvaro Herrera
Дата:
Сообщение: Re: Where to find information on the new HOT tables?